Error in SQL Server authentication using Windows Authentication RRS feed

  • Question

  • Dear,

    I installed SQL Server 2005 64 bit on Windows Server 2008 R2 Enterprise SP1 with "Mixed authetication Mode."

    When I access SQL SERVER through "SQL Server Authentication" (using the SA user), I have success. However when I access SQL SERVER through "Windows Authentication" (using my user administration server), SQL Server returns me the error "Login Failed".

    I'm not understanding why this occurs, because if I I logged on the server with my user administration server / password, then why do that when I access SQL Server through Windows Authentication password error is occurring?

    Anyone know why this happens?

    Thanks in advance,

    Jose Luiz
    Wednesday, April 6, 2011 9:24 PM


  • There are a number of possibilities.

    Most likely its the Windows user access control (UAC) feature. Try right-clicking the SSMS icon, and then click Run as Administrator. That will provide your admin credentials. If that works, add your domain login as a SQL Server login. Then you won't need to use your administrator credentials in the future.

    If you think you already have a SQL Server login, possibly added during setup, then login with the sa account and look at the SQL Server error log. The error log has more information than is returned to the failed login attempt. Lood for the state mentioned in the error. Then check out the error topic in Books online for the state description.

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    • Proposed as answer by Peja Tao Friday, April 8, 2011 7:04 AM
    • Marked as answer by WeiLin Qiao Tuesday, April 19, 2011 1:18 AM
    Wednesday, April 6, 2011 10:23 PM