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

[497 byte] By [GJK] at [2008-1-25]

«« SQL Server 2005 and SSPI Context on XP
»» How do I get out what I put into a stream?

# 1

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

LaurentiuCristofor at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Security...

# 2

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

GJK at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech