SBX - Search With Button

SBX - Forum Post Title

[CRM 2011] Login failed for user domainname\machinename$

Microsoft Dynamics CRM Forum

rr129122 asked a question on 20 Sep 2013 12:15 PM

Question Status

Suggested Answer

Dear Members,

Recently we cloned CRM 2011 & SQL Sever running on one machine to another new machine, and on the new machine we are seeing the below error while accessing crm 2011, any help please?

Server Error in '/' Application.


Login failed for user 'RS\BALI$'.

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: Login failed for user 'RS\BALI$'.

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): Login failed for user 'RS\BALI$'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +706
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +89
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6425982
   System.Data.SqlClient.SqlConnection.Open() +300
   Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection() +322
   Microsoft.Crm.CrmDbConnection.Open() +636
   Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize) +372
   Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString) +39
   Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache() +127
   Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns) +60
   Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id, String[] columns) +236
   Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id) +34
   Microsoft.Crm.LocatorService.GetFederationProvider(Guid id) +46
   Microsoft.Crm.CrmAuthenticationContext.get_DefaultFederationProvider() +91
   Microsoft.Crm.CrmAuthenticationContext.GetFederationProviderInternal(Guid orgId) +469
   Microsoft.Crm.CrmAuthenticationContext.IsClaimsEnabled(Guid organizationId) +53
   Microsoft.Crm.MapOrgEngine.Init(HttpApplication context) +76
   System.Web.HttpApplication.InitModulesCommon() +122
   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1655
   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +374
   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +178
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +329

Event Viewer

Event code: 3005 
Event message: An unhandled exception has occurred. 
Event time: 20.09.2013 19:49:42 
Event time (UTC): 20.09.2013 17:49:42 
Event ID: 0fe1f618a4b640739efa7a19fb5472bb 
Event sequence: 9 
Event occurrence: 8 
Event detail code: 0 
 
Application information: 
    Application domain: /LM/W3SVC/1/ROOT-1-130241700798948154 
    Trust level: Full 
    Application Virtual Path: / 
    Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\ 
    Machine name: BALI 
 
Process information: 
    Process ID: 3924 
    Process name: w3wp.exe 
    Account name: NT AUTHORITY\NETWORK SERVICE 
 
Exception information: 
    Exception type: SqlException 
    Exception message: Login failed for user 'RS\BALI$'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   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.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.MapOrgEngine.Init(HttpApplication context)
   at System.Web.HttpApplication.InitModulesCommon()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
   at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

 
 
Request information: 
    Request URL: http://localhost/RS/main.aspx 
    Request path: /RS/main.aspx 
    User host address: 127.0.0.1 
    User:  
    Is authenticated: False 
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
 
Thread information: 
    Thread ID: 30 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
    Is impersonating: False 
    Stack trace:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   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.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.MapOrgEngine.Init(HttpApplication context)
   at System.Web.HttpApplication.InitModulesCommon()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
   at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 
 
Custom event details: 

Reply
Churchill Kumar responded on 23 Sep 2013 3:36 PM
My Badges
Suggested Answer

Hi,

Check if the login 'RS\BALI$' exist in SQL server under Security> Logins. If its not there then create it manually mapping that to MSCRM_CONFIG and ORG_MSCRM database and give the db_owner permission and verify if this resolves your issue.

Thank You.

Reply
vladimir dj responded on 31 Oct 2014 4:04 PM
Suggested Answer

Thank you, that did the job for me.

Reply
Churchill Kumar responded on 23 Sep 2013 3:36 PM
My Badges
Suggested Answer

Hi,

Check if the login 'RS\BALI$' exist in SQL server under Security> Logins. If its not there then create it manually mapping that to MSCRM_CONFIG and ORG_MSCRM database and give the db_owner permission and verify if this resolves your issue.

Thank You.

Reply
vladimir dj responded on 31 Oct 2014 4:04 PM
Suggested Answer

Thank you, that did the job for me.

Reply

SBX - Two Col Forum

SBX - Migrated JS