Wednesday, January 25, 2006

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

I am seeing a ton of searches on this blog or reaching this blog from MSN/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
I will monitor the searches and write more stuff about things that people are searching for.
For the SQL server 2005 version go here

2 comments:

Anonymous said...

Hi

I am using multimode authentification. but still i have the same error " Login failed for user". this is the only server that i am not able to get connected. i dont know why. Can some one help me?

sourav said...

Hello,
i am using sql server 2005 and installed in mixed mode withe user name sa and password #sa
and from Sql Server Surface Area Configuration i select the Using both TCP/IP and named pipes for remote settings under Database Engine
version is [@@version]
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

My os is Xp with service pack2

I am using asp.net 2.0 and using connection string in web.config


add key="brian" value="server=SOURAV;uid=sa;pwd=#sa;database=test"


SOURAV is my local Database Server name.

I can connect server with the user name password from the SQL Server Management Studio,
But the problem arise when i hit con.open() from asp.net page

error message show login failed for user 'sa'

Please help how to solve,
Thanks in advance
Sourav