none
microsoft sql server error 18456

    Question

  • i have windows vista at my pc,but when i want to connect to SQL server 2005  the folowing error appear,

    Server Name: KHALED-PC
    Error Number: 18456
    Severity: 14
    State: 1
    Line Number: 65536

    Saturday, March 01, 2008 8:43 PM

Answers

  • Use "SQL Server 2005 Surface Area Configuration" to add yourself as an administrator on the SQL Server Instance.  In Vista, a Windows admin is not a SQL admin by default - they need to be added.

     

    Sunday, March 02, 2008 11:50 PM
    Moderator

All replies