Re: Connect problems with Sql Server Authentication

From: tshad (tscheiderich_at_ftsolutions.com)
Date: 10/04/04

  • Next message: tshad: "Re: Connect problems with Sql Server Authentication" 
    Date: Mon, 04 Oct 2004 16:53:17 GMT

    "tshad" <tscheiderich@ftsolutions.com> wrote in message
    news:pcf8d.6224$nj.2505@newssvr13.news.prodigy.com...
    >I am trying to allow connection to my ASP page using Sql Server 2000. I
    >have set up a login name "web" and password "web" on my development machine
    >(not my normal Sql System).
    >
    > In Sql Enterprise Manager, it shows "web". In my default database, I have
    > it set up as public,db_datareader,db_datawriter,db_denydatareader and
    > db_denydatawriter.
    >
    > I can see this in my user section of the database as well as the
    > security/logins sections. Both show access to the same database and the
    > same permissions on that database.
    >
    > But when I go to Sql Query Analyser and put in "web" for login and "web"
    > for password, I get:
    >
    > ************************************************************
    > Unable to connect to server JODI:
    >
    > Server: Msg 18452, level 16, state 1
    >
    > [Microsoft][ODBC Sql Server Driver][Sql Server]Login failed for user
    > "web". Reason: Not associated with a trusted Sql Server connection.
    > ***********************************************************
    >
    > I know that I can connect as when I change the "Sql Server authentication"
    > button to "Windows Authentication", it works fine.
    >
    > When I look at the users for my database, I can see my Windows login as
    > dbo and database access as permit. I see "web","web" and "permit" also.
    >
    > So why can't I connect?
    >
    > Do I need to define web somewhere else also?

    I also tried to set "web" to dbo and have the same problem.

    >
    > Thanks,
    >
    > Tom.
    >

  • Next message: tshad: "Re: Connect problems with Sql Server Authentication"
    Loading