Excel 2010 against a SQL 2005

From DataSelf Knowledge Base
Jump to navigation Jump to search

We faced this with Excel 2010 against a SQL 2005 db:

Excel issue when trying to connect to SQL:
Cannot generate SSPI context

Resolution:

“If you run the SQL Server service under the LocalSystem account, the SPN is automatically registered and Kerberos interacts successfully with the computer that is running SQL Server. However, if you run the SQL Server service under a domain account or under a local account, the attempt to create the SPN will fail in most cases because the domain account and the local account do not have the right to set their own SPNs.”

Be aware that this change in SQL logon may cause security issues during DataSelf BI’s auto-refresh process. We advise testing the auto refresh or monitoring next time it runs.