web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2013 Moving and up...
Microsoft Dynamics CRM (Archived)

CRM 2013 Moving and upgrading SQL Server error

(1) ShareShare
ReportReport
Posted on by touristsis 65

Hi,  I have a test environment.  CRM 2013 on a Server 2012 R2 with SQL 2008 R2 on Server 2008 R2.  I move the backup and restore the database to SQL server 2014 SP1 with all the roll up.  This server is a Server 2008 R2 as well.  I've edit the Organization Unit with no problem.  However when I try to connect to the crm I get 404 error.

Below is my log file, can some one help me out?

# CRM Tracing Version 2.0
# LocalTime: 2015-08-22 14:47:35.584
# Categories: *:Error
# CallStackOn: No
# ComputerName: BCSCRM2013
# CRMVersion: 6.1.0003.0119
# DeploymentType: OnPremise
# ScaleGroup:
# ServerRole: AppServer, AsyncService, DiscoveryService, ApiServer, HelpServer, DeploymentService, SandboxServer, DeploymentManagementTools, VssWriter, EmailConnector

[2015-08-22 14:47:35.584] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    9 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c7490254-f5de-42c2-8d69-01f7300e5ed8 | ClaimsUtility.InitializeApplication  ilOffset = 0x0
>Unloaded AppDomain since exception occurred in Application_OnStart ClaimsUtility.InitializeApplication: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'domain\TEST2013$'.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
   at Microsoft.Crm.CrmDbConnection.Open()
   at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
   at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString)
   at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
   at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
   at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id, String[] columns)
   at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id)
   at Microsoft.Crm.LocatorService.GetFederationProvider(Guid id)
   at Microsoft.Crm.CrmAuthenticationContext.get_DefaultFederationProvider()
   at Microsoft.Crm.CrmAuthenticationContext.GetFederationProviderInternal(Guid orgId)
   at Microsoft.Crm.CrmAuthenticationContext.IsClaimsEnabled(Guid organizationId)
   at Microsoft.Crm.CrmAuthenticationContext.get_ClaimsEnabled()
   at Microsoft.Crm.Authentication.Claims.ClaimsUtility.InitializeApplication()
ClientConnectionId:31dceb2f-786c-4ad1-a5d3-93590008df07
Error Number:18456,State:1,Class:14
[2015-08-22 14:47:35.678] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    9 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c7490254-f5de-42c2-8d69-01f7300e5ed8 | MainApplication.Application_OnStart  ilOffset = 0x38
>Exception occurred in Application_OnStart: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'domain\TEST2013$'.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
   at Microsoft.Crm.CrmDbConnection.Open()
   at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
   at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString)
   at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
   at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
   at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id, String[] columns)
   at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id)
   at Microsoft.Crm.LocatorService.GetFederationProvider(Guid id)
   at Microsoft.Crm.CrmAuthenticationContext.get_DefaultFederationProvider()
   at Microsoft.Crm.CrmAuthenticationContext.GetFederationProviderInternal(Guid orgId)
   at Microsoft.Crm.CrmAuthenticationContext.IsClaimsEnabled(Guid organizationId)
   at Microsoft.Crm.CrmAuthenticationContext.get_ClaimsEnabled()
   at Microsoft.Crm.Authentication.Claims.ClaimsUtility.InitializeApplication()
   at Microsoft.Crm.MainApplication.Application_OnStart()
ClientConnectionId:31dceb2f-786c-4ad1-a5d3-93590008df07
Error Number:18456,State:1,Class:14
[2015-08-22 14:47:35.709] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    9 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: c7490254-f5de-42c2-8d69-01f7300e5ed8 | MainApplication.Application_Error  ilOffset = 0x3C
>Application is not initialized and an error has occurred

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    Please check this line :

    (0x80131904): Login failed for user 'domain\TEST2013$'.

    Please check this account have sufficient privileges on DB.

    Mansoor

  • Alpha C Profile Picture
    Alpha C on at

    Have you installed CRM Reporting Extension on SQL server?

  • Suggested answer
    touristsis Profile Picture
    touristsis 65 on at

    thanks for the help.

    I now have a different error now.

    05:09:49|   Info| Check ActiveDirectoryRightsValidator: Success

    05:09:49|   Info| Group Microsoft SQL Serverâ„¢

    05:09:49|   Info| Check CrmSqlDomainValidator: Success

    05:09:50|   Info| Check SqlServerAgentValidator: Success

    05:09:50|   Info| Check SqlInstanceNameValidator: Success

    05:09:52|   Info| SQL Server Version: 12.0.4422.0

    05:09:52|   Info| SQL Server Edition: 2

    05:09:53|   Info| Check SqlServerValidator: Success

    05:09:53|   Info| Check SysAdminValidator: Success

    05:09:53|   Info| Check SqlCollationValidator: Success

    05:09:53|   Info| Check WordBreakerValidator: Success

    05:09:53|   Info| Check FullTextInstalledValidator: Success

    05:09:53|   Info| Check FullTextRunningValidator: Success

    05:09:53|   Info| Check OrganizationDatabaseExistsValidator: Success

    05:09:53|   Info| Group Microsoft SQL Server Reporting Services

    05:09:53|   Info| Check ReportingUrlValidator: Success

    05:09:53|   Info| UrlAccessValidator linking to help topic: html/01f421a9-da60-4d47-a06a-75550ee94430.htm

    05:13:41|   Info| Check ExistingRSValidator: Success

    05:13:47|   Info| Check SrsExtensionsValidator: Success

    05:13:47|Verbose| Validation ran.

    05:13:47|Verbose| Validation completed.

    05:13:47|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run

    05:13:47|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll

    05:13:47|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear

    05:13:47|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear

    05:14:20|   Info| Updating Organization with Id=(e5940353-8345-e511-80c4-00155d96ed01)

    05:14:20|   Info| Update Organization and Users in ConfigDB...

    05:14:40|  Error| Update Organization with Id=e5940353-8345-e511-80c4-00155d96ed01 failed with Exception:

    System.Runtime.InteropServices.COMException (0x80072116): Name translation: Could not find the name or insufficient right to see name. (Exception from HRESULT: 0x80072116)

      at Microsoft.Crm.Tools.ActiveDsWrapper.NameTranslateClass.Set(Int32 lnSetType, String bstrADsPath)

      at Microsoft.Crm.ADNameUtility.Rfc1779NameFromGuid(Guid guid)

      at Microsoft.Crm.SecurityUtils.GetSidFromAD(Guid objectGuid)

      at Microsoft.Crm.Authentication.UserManagementFactory.AddUserToConfigDB(IBusinessEntity systemUser, Guid crmId, Guid objectId, ExecutionContext context)

      at Microsoft.Crm.Setup.Server.Utility.NewOrgUtility.AddExistingUsersToConfigDatabase(Guid organizationId, Boolean disableUsers)

      at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateUsersInConfigDB(Guid organizationId)

      at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateOrganizationAndUsersInConfigDB(Guid organizationId, OrganizationData organizationData, String friendlyName, String sqlServerName, Uri reportingUrl)

      at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.Update(Guid organizationId, String friendlyName, String sqlServerName, Uri reportingUrl)

    05:14:41|   Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting

    05:14:41|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 6.1.0003.0119.

    any ideas?

  • Alpha C Profile Picture
    Alpha C on at

    Have you installed CRM Reporting Extension on SQL server?

  • touristsis Profile Picture
    touristsis 65 on at

    yes.

  • Alpha C Profile Picture
    Alpha C on at

    social.microsoft.com/.../name-trannslation-could-not-find-the-name-or-insufficient-right-to-see-name-exception-from

    030bacf.netsolhost.com/WordPress

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans