How to add a SQL Server Named Instance as an MSSQL Monitor?

How to add a SQL Server Named Instance as an MSSQL Monitor?

Step 1: Check if the Named instance is running in a static or dynamic port

  • Open SQL Server Configuration Manager.

  • Navigate to SQL Server Network ConfigurationProtocols for [Instance Name].

  • Right-click TCP/IPProperties.

  • Check the IP Addresses tab:

    • Static Port: (typically under IPAll section).

      • TCP Port: Contains a specific port number (e.g., 1433 or any other assigned port).

      • TCP Dynamic Ports: Should be empty.

    • Dynamic Port: (typically under IPAll section). 

      • TCP Port: Will be empty.

      • TCP Dynamic Ports: Contains 0 (f set to 0, SQL Server assigns a port dynamically) or a specific dynamic port number.

                     

Step 2: If a named instance is running in Dynamic port

Enable the "Connect using Named Instance" checkbox and give the instance name while adding MSSQL monitor.
  • SQL Server Browser: Make sure the "SQL Server Browser" Service is running on SQL Server installed machine.

  • Verify UDP Port Accessibility: Named instance connections require the UDP port (Default: 1434) to be reachable. The MSSQL driver uses UDP port 1434 to retrieve information about available SQL Server instances.

  • If the UDP port is inaccessible, you may encounter the following error:

Infojava.sql.SQLException: "Unable to get information from SQL Server"
  • This indicates the driver was unable to fetch details about the running instances.

Notes

Note: On SQL Server 2005 the SQL Browser service must be running on the server host as the instance name lookup port UDP 1434 is hosted by this service on SQL Server 2005 rather than the SQL Server itself. The default installation does not configure the SQL Browser service to start automatically, so you must do it manually.

Step 3: If the named instance is running in Static port

If your SQL instances are configured to use static ports, you can specify the port number directly instead of the instance name.

Alert

Possible error cases:

  1. Timeouts occur when there is no server listening on the specified port or if the UDP port is blocked.
  2. Ensure that the SQL Server is configured to use TCP/IP. You are correctly specifying named instances.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...
                    • Self monitor Applications Manager using Real User Monitoring

                      We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...
                    • Self monitor Applications Manager using APM Insight Java Agent

                      Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...
                    • Troubleshooting URL Monitor

                      When configuring a URL monitor in Applications Manager, you might encounter several errors related to accessibility, configuration, or server-side issues. Below are common errors along with step-by-step troubleshooting instructions to help you ...
                    • Troubleshooting MS SQL Monitor Addition Problems

                      1. Ensure that the SQL Server is running and accessible. Try connecting to the SQL Server instance via SQL Server Management Studio or DBVisualizer using the same credentials. This step helps diagnose connection issues, ensuring that both the server ...