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 6 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

TrackBack said:

^_^,Pretty Good!
# April 10, 2005 3:13 AM

Note To self: MSDE Problem - Dan Bright's .NET Weblog | ASP.NET Security Watch said:

Pingback from  Note To self: MSDE Problem - Dan Bright's .NET Weblog | ASP.NET Security Watch

# February 16, 2009 6:42 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)