Login Failed for user , the user is not associated with a trusted sql server connection. (micros

Login Failed for user , the user is not associated with a trusted sql server connection. (microsoft SQL Server,Error:18452)

hi ,

i am getting the above error message once in a while maybe two or 3 times a week , and then it goes away in 10 to 15 minutes or 5 minutes ,

our mode is set to mixed and we are able to connect and use both sql and windows , but once in a while , it will give us the above message when we try connecting throught sql server management studio client (using sql 05) using windows login , although it lets us connect using sql login while the windows login is denied, and after a while it lets us connect with both.

occurs randomly on some days , we run our servers on VM ware virtual machines using windows 2003 r2 enterprise 64 bit with sp2 with esx 301 virtual machine.

would appericate any feedback on this thanks

Are you connecting using domain logins or local logins? If they are domain logins, you may experience issues querying the domain controller and these could cause the login failures.

Please also check the server error log (assuming that you are running SQL Server 2005) and tell us the error state. You could also use the security error ring buffer to see if you can get additional information on which Windows API is failing (requires SP2 - see http://blogs.msdn.com/lcris/archive/2007/02/19/sql-server-2005-some-new-security-features-in-sp2.aspx).

Thanks

Laurentiu

|||

hi ,

this is the error i can see been logged in the sql server agent log files

Date 19/07/2007 9:35:00 AM

Log SQL Agent (Current - 19/07/2007 11:08:00 AM)

Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'POWAT\kena', error code 0x6ba. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

|||

Hi,

the error message in the log is self explainatery, make sure your NT User exists in domain POWAT, and trust relationship between domain and SQL Server are well established. also suggest to take a closer look at windows event viewer for more information.

Regards

Hemantgiri S. Goswami

|||

Hello you i have used aconnection string but it says the the user is not associated with trusted sql server connection, but the server is also in a mix mode but still i am recieving errors and one more thing if i give username and password it does not display my username at the error

Thanks

Vishy007