Home > MS CRM 2011 > Can not generate SSPI

Can not generate SSPI


I was experiencing periodically “Can not Generate SSPI context”  Error in one of our test MS CRM 2011 environment .

This error is not consistent though that was causing me to run crazy for a week. FInally i was able to get bottom of this issue . The issue is with SQL server Service Logon account .. Here is the story .

When i have done Sql server installation used Domain account as Logon account .It tuns out to be the issue  as SPN won’t be created by default in Active Directory if  login user does not have domain admin privillege.

Solution:

1.Change logon user account of the Sql server service to Local system.

2.Restart the service .By default whenever service start it looks for SPN in Active directory and creates if one does not exist.

 

 

 

 

Advertisements
Categories: MS CRM 2011
  1. No comments yet.
  1. No trackbacks yet.

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: