Kodyaz Development Resources

While I was trying to connect to a remote Microsoft SQL Server 2008 February CTP (CTP6) installation from the Microsoft SQL Server Management Studio I'm getting the following error message :

Cannot connect to SQLCTP6.

------------------------------
ADDITIONAL INFORMATION:

Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476



"Cannot generate SSPI context" is a known error message which occurs while connecting to SQL Server databases for SQL2000 for instance.

"Cannot generate SSPI context" error message occured when I tried to connect to the remote MS SQL Server 2008 database instance with NT Authentication. When I changed my connection security from Windows Authentication to SQL Server Authentication, I managed to connect to the SQL2008 instance successfully.

Also connecting to the SQL2008 instance using IP address of the server instead of using the sql server name with Windows Authentication worked successfully.

Hi,

There is a knowledge base article from Microsoft Support on this topic named How to troubleshoot the "Cannot generate SSPI context" error message.

You can refer to this article for more information about SSPI context errors.