Wednesday 13 October 2010

Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection

Just the other day I spent  an hour trying to figure the "Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection" error. 


I easily found out that I need to change the server authentication mode to mixed mode.


It took me a while but I just needed to restart the SQL Server as stated here


http://msdn.microsoft.com/en-us/library/ms188670.aspx

No comments:

Post a Comment