February 1, 2010 at 8:04 am
I found below error in eventlog...trying to understand the error...please guide
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 789.568.34.12]
February 1, 2010 at 8:18 am
Make sure you have changed the security settings of the server to "Mixed Authentication Mode" (SQL+windows autheitcation mode).
Thanks.
February 1, 2010 at 8:19 am
It's an auditing message. You must have a setting enabled to log failed logins and the instance is logging them. It means that someone attempted to log on with an account that does not have rights.
February 1, 2010 at 8:46 am
Resolved. login123 password expired. From now on, it’s set not to expire.
February 1, 2010 at 8:53 am
Sourav-657741 (2/1/2010)
Make sure you have changed the security settings of the server to "Mixed Authentication Mode" (SQL+windows autheitcation mode).
Any reason why it must be changed to Mixed Authentication Mode?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 1, 2010 at 8:56 am
If the login is a SQL Login, and if the server authentication is set to "Windows", it might give the error.
Thanks.
February 1, 2010 at 9:31 am
Setting password to not expire is a bad idea. They ought to be changed periodically.
February 1, 2010 at 10:13 am
Sourav-657741 (2/1/2010)
If the login is a SQL Login, and if the server authentication is set to "Windows", it might give the error.
Understood, but a change in the Authentication Mode would need a restart and that might not be allowed immediately..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply