SQL Server DB unreachable

Problem

You are trying to start MDM Server or perform some operation in MDM, when you get the error "SQL Server DB unreachable"

Cause

This error occurs due to the following reasons:

• MDM Server cannot access the SQL DB Server
• Ports used by SQL Server is being used by other applications
• SQL server is blocked by firewall

Resolution

MDM Server cannot access the SQL DB Server

Ping the IP address of the SQL server from the machine which is running MDM server. If this is not successful, it implies MDM Server cannot access the SQL DB. Also, ensure the machines running SQL Server and MDM Server are connected to the Internet.

Ports used by SQL Server is being used by other applications

Telnet the ports used by the SQL server to identify, whether its being used by other applications. If yes, then ensure the ports are used only for the SQL server.

SQL server is blocked by firewall

Ensure exclusion rules have been setup in firewall and any third-party filters, for all the ports used by SQL server.

NOTE: If the issue persists, contact MDM MSP Support with the Server logs.