microsoft sql server error 18456


  • 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


  • 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

All replies