Mssql 2008 Windows Authentication failure (Microsoft SQL Server,Error: 18456) RRS feed

  • Question

  • Hi,

    Iam using MSSQL Server 2008 Developer Edition.  Iam not able to login using windows authentication through Microsoft SQL Server Management Studio.  When i try to login it through  the error message  ( Login failed for user testserver\administrator (Microsoft SQL Server,Error:  18456))

    but iam able to login successfully using sa account.

    OS Version:  windows 2008 standad Edition R2

    DataBase  :  MSSQL 2008 Developer Edition.

    Any one can help me on this? Thanks






    Wednesday, September 29, 2010 7:18 AM


All replies

  • Hi,

    One small update. The windows Authentication is not working for Administrator account only. When i try to login with other users with administrator privileges,  Able to login without issues.




    Wednesday, September 29, 2010 7:35 AM
  • Have you added the respective administrator user to sql server login/user or not ??



    - MS (We are what we repeatedly do, Excellence, then, is not an act, but a habit.)
    Wednesday, September 29, 2010 12:20 PM