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 loses connection t...
Microsoft Dynamics CRM (Archived)

CRM loses connection to SQL

(0) ShareShare
ReportReport
Posted on by AEdwards 765

Hi Everyone,

I have a Dynamics CRM 2015 On-Premise instance installed on a Windows Server 2012 R2 and a connection to a SQL Server on a different machine with similar specs. 

Just recently an issue has popped up that occasionally (once or twice a day) that when trying to browse to CRM the browser loads for a couple minutes before showing an Error Page. This is accompanied by several errors in the Windows Logs: "A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible."

If I restart the machine where CRM is hosted than the problem gets resolved, but only temporarily.

I've tried a few troubleshooting steps including:

  • Restarting Async Service, but it fails when trying to stop and hangs at 'Stopping'
  • Disabling Firewalls, all the windows firewalls on both servers are turned off

Any thoughts? Thank you

*This post is locked for comments

I have the same question (0)
  • Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at

    Hi, check this list of items to check on the SQL server. So you have a proxy between the servers? you mentioned you disabled the firewall, but I guess  you mean the server windows firewall. do you have a network firewall?

    stackoverflow.com/.../cannot-connect-to-server-a-network-related-or-instance-specific-error

  • Community Member Profile Picture
    Community Member on at

    I am guessing you have quite a few workflows / plugins? Please check the pattern in which the Current connections in Webserver Performance counter (Start --> Run --> perfmon) look like when you face this issue.

  • Verified answer
    AEdwards Profile Picture
    AEdwards 765 on at

    I found that the Email Router was hogging 90-100% of the CPU, which I figured to be the cause of the issues with CRM as after resolving the Email Router issue the CRM connection issue stopped occurring.

    Thank you for your help!

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