Our CRM 2013 and DB servers got migrated (VM only, no change in IP) recently.
After the migration, we are encountering multiple issues
1) Cannot open CRM
a) Error on client machine
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration> |
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web> </configuration> |
b) Error on CRM server
Server Error in '/' Application.
The target principal name is incorrect. Cannot generate SSPI context.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The target principal name is incorrect. Cannot generate SSPI context.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[SqlException (0x80131904): The target principal name is incorrect. Cannot generate SSPI context.] System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +350 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +268 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +314 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +204 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +245 System.Data.SqlClient.SqlConnection.Open() +130 Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection() +193 Microsoft.Crm.CrmDbConnection.Open() +418 Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize) +114 Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString) +41 Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache() +113 Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns) +57 Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id, String[] columns) +164 Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id) +12 Microsoft.Crm.CrmAuthenticationContext.GetFederationProviderInternal(Guid orgId) +1095 Microsoft.Crm.CrmAuthenticationContext.IsClaimsEnabled(Guid organizationId) +77 Microsoft.Crm.CrmAuthenticationContext.get_ClaimsEnabled() +43 Microsoft.Crm.MapOrgEngine.Init(HttpApplication context) +19 System.Web.HttpApplication.InitModulesCommon() +195 System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1056 System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +373 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +418 |
2) Cannot open Deployment manager
Unable to access the MSCRM_CONFIG database. SQL server does not exist or access denied.
3) Cannot start Microsoft Dynamics CRM Sandbox Processing Service and Microsoft Dynamics CRM Unzip Service. Also need to restart Microsoft Dynamics CRM Asynchronous Processing Service (maintenance).
Windows could not start the Microsoft Dynamics CRM Sandbox Processing Service on Local Computer.
Error 1067: The process terminated unexpectedly.
Searching solutions for days! Kindly suggest solutions and root cause of the issue!
*This post is locked for comments