SQL Server 2005 and SSPI Context on XP

Hot Topic

Password field (very important)
Need to query max value between several colums for each row ?
Error CS2001 & CS2008
~* Data Loading in Reports *~
How to: SQL Server 2000 Replication?
Cannot open a connection with SQL Server 2005 Developer Edition.
Transactional LOB replication error
SQL Server 2000 and SQL Server 2005 on the same computer
Named Pipes Provider: Could not open a connection to SQL Server [2]
IDW15: DCR: Make precedence constraint editor bigger

SQL Server

LDAP/ADSI data conversion error
how to install SQLDMO without install SQLserver?
Error: Subreport could not be shown
beta headache
Package executing error
sql express on server 2003 and vb6 program
Displaying a SQL Server Report 2005 in a PDA....
obtain the name and path of a report
How can I Use a User Defined function as a default for a column value?
Where are the Graphs saved from Data Mining model viewer

SQL Server 2005 and SSPI Context on XP

Hello,

I have an XP box with SQL 2k working without any problems.  I am trying to install SQL 2005 CTP April on the same machine. Installation goes fine, but when I try to connect, I am getting an error "Can not Create SSPI Context".   Why am getting this error   DOes the machine needs to be on a domain to get connected If yes, is there a work around Can I use mixed mode Where\How do I specify  password for sa


Any help is highly appreciated.
Thanks
_GJK
 
 
 

Answer this question

SQL Server 2005 and SSPI Context on XP

  • Eddie Garcia

    Could you please copy paste and send us the error number and the error text Can you also check the server log and also send us the last error logged there

    Thanks
    Laurentiu

  • mdf

    My laptop is disconnected from domain and SQL Server was looking to authenticate the user under which SQL server is run against the domain. This failed generating the SSPI context error.  To resolve the issue, I created a local user with admin privialges and run the SQL server under this account. Then I logged in to the box with this account, got sqlserver running.

    Thanks for the reply.
    _GJK
  • SQL Server 2005 and SSPI Context on XP
Answer this question