Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hi CRM gurus,Please help me out on the below issue:We are getting the below error when users are trying to browse the CRM site (Pre - Prod environment)
An error has occurred. Try this action again. If the problem continues, check the Microsoft Dynamics 365 Community for solutions or contact your organization's Microsoft Dynamics 365 Administrator. Finally, you can contact Microsoft Support.Things done so far:
I checked the event viewer and the following error is being recorded when ever I browse the site:
Hope you are well.
These type of behavior can be complex to troubleshoot and the information provided is not enough to make any meaningfull suggestions.
I would advise to use CRMdiagTool to enable verbose traces and retry the action.
You can then read the traces properly using the tool CRMtraceReader from Xrmtoolbox:
That would give a more detailed error on what is happening.
Discussing a bit your exception
On a default environment, the only identity trying to access SQL would be the CRMappPool identity.
Its access to SQL is controlled by its membership on the activedirectory group SQLaccessGroup:
Maybe something got changed here causing the problem, or some configuration is missing/wrong.
If this information didn't help, i would advise to create a ticket to our support team, so we can guide you through the resolution.
Many thanks for your quick reply, Pedro.Sorry for not providing with the complete details of the issue.I will use the CRMDIGTool as suggested to dig deeper into this issue.Please see below on complete issue description:
Exception type: SqlException
Exception message: Login failed for user 'Domain\App pool account'. (this is an example account, changed it due to security reasons)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
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 Microsoft.Crm.CrmDbConnection.InternalOpenWithRetry(IDbConnection connection, String descriptionText)
at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString)
at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String columns)
at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id, String columns, Boolean includeDisabled)
at Microsoft.Crm.ServerLocatorService.GetFederationProvider(Guid id)
at Microsoft.Crm.Core.DataServices.Configuration.ConfigProviders.LocatorServiceAuthManagementInfoProvider.GetFederationProvider(Guid id)
at Microsoft.Crm.CrmAuthenticationContext.IsClaimsEnabled(Guid organizationId)
at Microsoft.Crm.MapOrgEngine.Execute(Object sender, EventArgs e)
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Thank you for the provided logs, but that is still not enough.
With this log we just see the same stack trying to make a connection to the database.
We might need to work using a support request if you are interested.
This should be lack of permissions on the appPool account running CRM.
Hello Hari ,
please check below things ..
All the services are up and running
SQL serverMicrosoft Dynamics CRM Asynchronous Processing ServiceMicrosoft Dynamics CRM Asynchronous Processing Service (maintenance)Microsoft Dynamics CRM Monitoring ServiceMicrosoft Dynamics CRM Sandbox Processing ServiceMicrosoft Dynamics CRM Unzip ServiceMicrosoft Dynamics CRM VSS Writer
World Wide Web Publishing Service
IIS Admin Service
Open IIS and check if the Microsoft Dynamics Site is working or nor
then Application Pool
Cross check , your MS Dynamics Production server is in Domain
is this deployment configured for IFD , if yes you need to check more stuff.
if any services accounts used to configure SQL , and any other services cross check the accounts are in place not expired , locked out etc.
hope this will help you , let us know if this help will try to to get it done.
Many thanks for your reply.
URL is seems to be working now.
I modified the Web.config file under Programs > CRM > CRM dynamics > Web.config f
The Issues URL not rendering is fixed but now we got another issue, where the URL is keep asking the users to enter credentials. Which is not always the case. As the users are logged into the CRM site using SSO in general. But now the URL is keep prompting for the credentials.
Yes, I did check the below:
- IIS pools and sites are up an running
- Services regarding CRM and World wide web are up and running on Services.MSC.
Just wanted to add some notes on the issues:
- This is a pre-prod environment
- Internet facing is configured but on HTTP (as its only for internal team for testing purposes)
- Used to work before with a SSO login
- Now it keep prompting for the users to login in a infinite loop.
- We checked with AD team no group policy changes were made.
- Restarted the servers
- IIS reset were performed.
- Checked all sites and app pool are in start state in IIS manager
- Restarted the services related to IIS admin, CRM and WWB in Services.MSC
here the screenshot.Thanks in advance.
Thanks for your response.
We checked permissions for App pool account on SQL server for CRM_config database.
App pool account does have DB_owner and System admin permissions.
CRM Url is working now after we did some changes in configuration in Web.Config file for CRM.
Please see my latest response below in the below loop.
New issue raised now, CRM URL is prompting users to type credential over and over again, as this was not the case previously. Users used to login automatically using SSO.
Do you have any suggestions on how to troubleshoot the SSO issue.
Business Applications communities