Microsoft Dynamics CRM: There was a problem accessing this site

Question

I have Microsoft Dynamics CRM 2013 installed on Windows Server 2008 that suddenly stopped working and gave this error

There was a problem accessing the site. Try to browse to the site again!
If the problem persists, contact the administrator of this site and provide the reference number

what could be the reason and resolution?

Comments

Hi, We need more details to can help you?  First, what's the last action you have did on your current environment?

---

Please check your log with this reference number and update your question with what you have found to can investigate your issue!

---

We added 2 new users to active directory and then it was down

---

Where can I check the logs?

---

You can check how to enable the trace log at https://support.microsoft.com/en-us/topic/how-to-enable-tracing-in-microsoft-dynamics-crm-818e8774-e123-4995-417d-7ea02395c6d0

---

@Nesma Adding users action doesn't raise this error,  Is it a general issue for all users? Have you tried to log in with the system account?

---

It seems there is a problem with SQL on CRM it's giving an error that "Unable yo access MSCRM_CONFIG database. SQL server does not exist or access denied."

---

Yes no users can access the CRM

Answer 1

Based on the provided log, this error "Unable to access MSCRM_CONFIG database. SQL Server does not exist or access denied." usually occurs in the following cases:

1. The Database Server is down.
2. The SQL Server Services stopped.
3. The Database server is not reachable from the Application server (Firewall Issue / SQL Server Port closed).
4. The SQL Server license has expired.
5. The SQL Server Service account password was changed.
6. The SQL Server Service account is locked or disabled.
7. The App Pool account for the web applications is locked or disabled.
8. The Admin account doesn't have sufficient permission to access the config database.
9. The Admin account is locked or disabled.
10. The Admin account password is expired.
11. A new security policy has been recently applied that affects the Admin account permission!

Follow How to Check SQL Server Connectivity between Application Server and Database Server. Also, check this article that would help you to trace your issue "SQL Server does not exist or access denied" (It's mainly related to SharePoint. However, the mentioned fixes should be also valid for any DB system)

Comments

Yes, it's correct, I also agree with Mohamed's answer!

---

Well another problem we are facing is that we can't access SQL server management studio... which of the above reasons could possibly be the reason for that as well ?

---

@Nesma Abdel Hady, What's the error message that appears when connecting to your SQL instance using SSMS?

---

"A network-related or instance-specific error occured while establishing a connection to SQL server. The server was not found or not accessible. Verify the instance name is correct and that the SQL Server is configured to allow remote connections. (provider : SQL  Network Interfaces , error : 26 - Error Locating Server/ Instance Specified)(Microsoft SQL Server)"

---

It's mainly related to the first three reasons in my answer! So, you should make sure that

1.the DB server is up and running,
2. the SQL Server default port is opened and you can reach the DB server from the App server,
3. all SQL services are started!
4. Finally, you should check with the DB and network/infra team to ensure that there are no changes have been recently applied especially for the IP, default port, and server name of the DB server!
Good Luck!