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:51:33 GMT

    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?

    Thanks,

    Tom.

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