Cannot Generate SSPI Context

11 Feb

MS Sql server 2008 on windows2008 R2. If you get the above error about sspi context, go the command prompt (domain\username – username which is used to start the sql service):

setspn -A MSSQLSvc/dbmssql2.npta.no:1433 domain\username

http://blogs.msdn.com/sql_protocols/archive/2005/10/15/481297.aspx

http://support.microsoft.com/kb/277658/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: