Authentication Mode

  • SQListic

    SSCertifiable

    Points: 6904

    Hi DBA's

    I can login into sql server using my windows authentication

    for example:

    domain\login

    If i change to authentication mode to Sql Server authentication

    Its throwin error

    Server Name: DVMS

    Error Number: 18456

    Severity: 14

    State: 1

    Line Number: 65536

    Please help me!

  • MyDoggieJessie

    SSC-Forever

    Points: 44278

    You need to research the true nature of the error. Login failure errors aren't going to tell you the problem, in fact I believe every login error (whether it be a bad password, account disabled, etc) will return you the same error number, and always State 1. This is by design...to keep people from obtaining too much information.

    To find out the real reason for the error you need to dive into your SQL error logs. If you have access to those logs then you should see somewhere in there the real reason for the error. Example:

    2012-08-02 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8.

    2012-08-02 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>]

    The most common list of possible error states are:

    2 and 5 - Invalid userid

    6 - Attempt to use a Windows login name with SQL Authentication

    7 - Login disabled and password mismatch

    8- Password mismatch

    9 - Invalid password

    11 and 12 - Valid login but server access failure

    13 - SQL Server service paused

    18 - Change password required

    Any errors outside this general list and you should call perform a healthy Google/Forums search and if that fails, contact Microsoft Support.

    ______________________________________________________________________________
    Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • Dugi

    SSCoach

    Points: 17998

    Did you check if your account is locked in Active Directory, just in case!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • MyDoggieJessie

    SSC-Forever

    Points: 44278

    The OP says Windows Authentication is OK, it's when they log in with a SQL Server account that they get the error...this has no bearing on AD

    ______________________________________________________________________________
    Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply