I am trying to connect with SQL server 2005 with server authentication but I get an error --
Login failed for user '' ". The user is not associated with a trusted SQL Server connection.
I am already performed following steps ----
"Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode"
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode"
login --enabled.
Please provide me appropriate solution .
--
Thanks in advance.
Jignesh TrivediPosted Apr 17, 2013, 11:56 PM
hi,
is there anonymous account has been set? also it might possible credentials for login are different from the ones you specified in SQL Server.
also refer below link it might help you.
http://support.microsoft.com/kb/555332
http://blog.sqlauthority.com/2008/11/02/sql-server-fix-error-login-failed-for-user-username-the-user-is-not-associated-with-a-trusted-sql-server-connection/
KRayudu VPosted Apr 17, 2013, 10:19 PM
but u have to create sqlserver code.