Dan Bright's .NET Weblog

Note To self: MSDE Problem

Note to self:

Server Error in '/AppName' Application.
Login failed for user 'db_reader'. Reason: Not associated with a trusted SQL Server connection.

When you install MSDE2000a and specify mixed mode authentication during setup it does not remember your choice.  You have to go in manually:

SQL Server Enterprise Manager -> Console Root - > Microsoft SQL Servers -> SQL Server Group -> Properties -> Security Tab. Verify that the authentication mode is "SQL Server and Windows".

Just a minor annoyance, but I figured I might save someone the 5 minutes if they ever run into it.

Posted: Mar 25 2004, 11:23 AM by DanB | with 4 comment(s)
Filed under:

Comments

Tara said:

For those of you without the SQL client tools, run this using osql:

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', 'LoginMode', N'REG_DWORD', 2
# March 25, 2004 6:05 PM

SteveB said:

Yes... Thank you. Sometimes we need to be reminded of what we have fixed before, and you have helped me.

SteveB
# April 17, 2004 8:30 PM

Chris Maguire said:

Thanks, the osql command helped me out. Don't work with OSQL much except with remote CRM clients using MSDE.
# June 28, 2004 6:10 PM

Remco said:

Thanx this is exactly the problem I experienced and the right solution
# July 26, 2004 2:28 PM