October 21, 2002 at 6:17 am
when i try to connect to server sometimes i receive a error message:
Connection failled
SQLSate 28000
SQL server Error: 18452
[MICROSOFT][ODBC SQL Server Driver] login failed for user '(null)'.Reason: Not associated with a trusted SQL Server connection.
Could you help me
it s urgent..
October 21, 2002 at 7:38 am
Make sure the login you used to login into NT/2000 has been granted to access SQL Server.
October 21, 2002 at 7:41 am
quote:
Make sure the login you used to login into NT/2000 has been granted to access SQL Server.
is already correct, you have a other idea
October 21, 2002 at 2:36 pm
This will happen if no user can be identified on the connection and you are trying to connect using trusted connection.
This would occur if you use TCP/IP.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
October 22, 2002 at 7:23 am
It's possible that it's a bug. I have been struggling with this ever since our upgrade to SQL2k. It seems to occur randomly and spontaneously. We run the same daily processes every day, and this seems to pop up once or twice a month. Try stopping and restarting SQL Server service and see if it clears it up (does for me!).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply