Login Failed Error
-
Hi All,
This is driving me crazy..Earlier I've receiving this error once every 30 mins..lately I've found that I'm seeing it every 3 secs..I don't believe this..
The error i'm talking about appears on the application event log on the SQL server 2000(SP3) enterprise edition..
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I've even opened a ticket with the help desk and they don't have any concrete fix for this..and we are diagonising this till now..
Has anyone come across this before?
Thanks,
AK.
-
Are you sure this is not an intrusion attempt? I am assuming that by 'Application Event Log', you mean the Windows Application event log and not a log that is being generated by your application? If so, where is the connection attempt comming from (the computer column in the app. log shows the host)?
-
Yeah ofcourse,it is from the application log in the event viewer.The computer column has the name of the virtual server name.is that trying to access the server for any reason?
AK.
-
Can you check the Authentication mode set for the server. Go to Enterprise Manager, right click on the server, go to properties, go to Security Tab.
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
-
yep,
its set to mixed mode authentication only..for windows and sql server login mode..
-
Do you know for which user you are getting this error message? If yes, Then go to the security -> Logins, right click on the user, go to properties, Database Access Tab and check if the domain_name\user_name is exactly as you have defined. Sometimes, you see only user_name with no domain_name. This sometimes throw this kind of error. Check this out.
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
-
the set up we've is a critical application..every changes mades/to be made is all documented..
chkd the login domain stuff too..itz perfect..
-
It could be an issue associated with the user rights of your SQL Server account. See MS KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;840219
-
It could be someone mapping a drive on their computer to your SQL Server. When one of my remote users tried to connect to my SQL Server, I saw these messages every 3 to 5 seconds.
-SQLBill
-
I don't think so..the error reported is only from the application log in the event viewer and it is replicated in the sql error logs too.
also,we don't have any issues reported from users coz of this error.but i wanted to fix this before this kicks off anything critical and i hate seeing it pop up in the log every 30 secs..
-
Hi,
This error message is when a Windows user is trying to connect to your SQL Server and SQL Server can not resolve his SID. For example, this user is from different domain and was using Windows authentication.
Every 3 or 4 seconds means that this person has his Enterprise Manager registration to your server as default (Windows) but your server can not resolve his Windows SID (trusted connection) and his Enterprise Manager continues polling your server every 4 seconds. Check Tools->Options Poll Interval (Seconds) in your Enterprise Manager, I set mine to 10 seconds, default I think was 4 seconds.
30 min. means he had a job or just tried to do something.
Yelena
Regards,Yelena Varsha
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply