login failer for user

  • 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]

  • Make sure you have changed the security settings of the server to "Mixed Authentication Mode" (SQL+windows autheitcation mode).

    Thanks.

  • 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.

  • Resolved. login123 password expired. From now on, it’s set not to expire.

  • 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?


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • If the login is a SQL Login, and if the server authentication is set to "Windows", it might give the error.

    Thanks.

  • Setting password to not expire is a bad idea. They ought to be changed periodically.

  • 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..


    Bru Medishetty

    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