locked
Login Failed for the user( error 18456) RRS feed

  • Question

  • hi,

    i just installed sql 2005 but with vista home.. but when i m trying to start SQL Server Management Studio tha DATABASE engine could not able to connect and giving error Login failed for the user (server name) error 18456..

    but other services open esily like Analysis service.

    i m using windows Authentication mode without pwd..

    i already reinstalled 2 time but same problem comming..

    if any of you have solution than pls tell.

    thanks

     

    Thursday, December 29, 2011 1:21 PM

Answers

  • Try "Run As Administrator" option while launching SSMS.

    If that doesnot help post complete error message from SQL Server Error Logs http://sqlserver-help.com/2011/06/26/help-where-is-sql-server-errorlog/


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    • Marked as answer by amber zhang Monday, January 9, 2012 8:47 AM
    Thursday, December 29, 2011 3:22 PM

All replies