web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Verified answer
    AEdwards Profile Picture
    AEdwards 765 on at
    RE: CRM loses connection to SQL

    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!

  • Community Member Profile Picture
    Community Member on at
    RE: CRM loses connection to SQL

    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.

  • Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: CRM loses connection to SQL

    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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans