Re: Connect problems with Sql Server Authentication

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

Date: Mon, 04 Oct 2004 22:07:03 GMT

"tshad" <tscheiderich@ftsolutions.com> wrote in message
news:1ef8d.6228$nj.302@newssvr13.news.prodigy.com...
> "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.
>

This is ridiculous.

I am getting the same error if I try to connect using "sa", with or without
a password ???????

I am using Sql Server 2000 Developer version on an XP. Could that be a
problem?

I also can't seem to log on as the same login initials I use to logon my
machine (with or without a domain in front of the login - domain/user) -
which is what I am logging on with in Windows Authentication mode.

Thanks,

Tom

>>
>> Thanks,
>>
>> Tom.
>>
>
>

Loading