System.Data.SqlClient.SqlException : Cannot generate SSPI context.
Hi Dranium,
This issue may occur if the password of the user account that is specified as the siteAppPool application pool identity in Microsoft Internet Information Services (IIS)is incorrect.
To resolve this issue, specify the correct password for the application pool identity in IIS. To do so, follow these steps:
1.
Click Start , point to Administrative Tools
, and then click Internet Information Services (IIS) Manager .
2.
Expand <var>ServerName </var>, and then expand Application Pools
.
3.
Right-click site AppPool , and then click Properties
.
4.
Click the Identity tab.
5.
In the Password box, type the correct password of the application pool account that appears in the
User name box, and then click OK .
6.
In the Confirm Password dialog box, type the password again, and then click
OK
This issue may occur in situations when there are entries that exist in Active Directory from a previous installation of
SharePoint Portal Server, and these entries prevent Microsoft SQL Server from registering itself correctly in Active Directory.
http://support.microsoft.com/kb/811889/en-us
Type the following line at the command prompt,
setspn –l <var>ServerName </var>
A list of service principal names that are currently registered for the server are displayed and check once again
Thanks,
Raj
July 14th, 2011 10:17am


