Async Service won't start error: System.Data.SqlClient.SqlException: Cannot generate SSPI context

(0) Share

Report

Posted on by Community Member

Hello,

I am unable to restart my asynchronous services on the crm app server. I am using the same account for the SQL Server (CRM) service, which restarts fine. Only the Asynchronous Service has the issue.

Here is the error message found in the event viewer:

Host CRMUATAP1: failed while starting monitoring asynchronous operations queue. Exception: System.Data.SqlClient.SqlException: Cannot generate SSPI context.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Crm.CrmDbConnection.Open()
at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
at Microsoft.Crm.SharedDatabase.DatabaseService.Initialize(String tableName)
at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
at Microsoft.Crm.ServerLocatorService.GetSiteSettingIdFromDatabase()
at Microsoft.Crm.ServerLocatorService.GetSiteSettingId()
at Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName)
at Microsoft.Crm.Asynchronous.AsyncService.InitializeComponents()
at Microsoft.Crm.Asynchronous.AsyncService.OnStart(String[] args)

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

Did you check this: social.microsoft.com/.../in-one-of-the-environment-we-are-getting-error-can-not-generate-sspi-context-when-browsing-the

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi HIMBAP,

Yes I had looked at that before. Removing the Network Service and adding it back doesn't resolve the problem. I still am unable to restart the service without that error being thrown.

Was this reply helpful? Yes No
Suggested answer

Satish Tiwari - CRM Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Devin,

It seems to be a SPN issue. You might need to add a SPN on the Async Service account in order to start it. You can refer to TechNet for more info - technet.microsoft.com/.../hh699825.aspx

I would also request you to check following things as well:

1. The MSCRM Asynchronous Service is ran by an AD user account please verify that it is a local administrator on the machine.

2. Verify this user account is part of the PrivUser group and SQLAccess group.

3. Check that the account in AD is trusted for delegation.

Was this reply helpful? Yes No