Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2000

From Wiki

Jump to: navigation, search

I am seeing a ton of searches reaching Lessthandot from Yahoo and Google with this search “Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.” So this is what causes the problem: your SQL Server has been setup with windows authentication only. In order to make it mixed mode authentication right click on the server name in enterprise manager select properties and click on the security tab. Select SQL server and Windows (see picture…) and that will fix it

For the SQL server 2005 version go here: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2005


Image:Loginfailed_0.jpg


Contributed by: --SQLDenis 15:36, 9 June 2008 (GMT)


Part of SQL Server Admin Hacks

392 Rating: 0.0/5 (0 votes cast)