Security Compliance

SQL Network Interface error when running DBHelper.exe

When you run the DBHelper.exe command on a Patch Manager server, the following error is displayed: SQL Network Interfaces, error: 26 - Error Locating Server/Instance specified

First published date

11/1/2018 5:51 PM

Last published date

11/1/2018 5:51 PM

Overview

Database Helper (DBHelper.exe) is an open source application that assists with programming and interacting with a Microsoft^® SQL Server^® database. When you run Database Helper on your Patch Manager SQL Server database, the following error displays:

SQL Network Interfaces, error: 26 - Error Locating Server/Instance specified

Product section

Patch Manager

Cause

Network issue
Incorrect server or name instance
Patch Manager server issue

Resolution

To resolve the networking firewall, and SQL-related causes for this error, see SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified (© 2018, Microsoft Corporation, available at https://blogs.msdn.microsoft.com , obtained on February 28, 2018).

If this procedure does not resolve the issue, repair the Patch Manager installation on your Patch Manager server.

Repair the Patch Manager installation

Verify the following:
- Server/instance name
- Port numbers being opened
- SQL Browser service is running
Temporarily disable any antivirus software.
Download the Patch Manager full package (with SQL) for your installed version from the Customer Portal.
1. Log in to the Customer Portal .
2. Click Downloads and select Download Product.
3. Click the Products drop-down menu and select Patch Manager.
4. In the Patch Manager full package (with SQL) field, click the drop-down menu and select your Patch Manager version.
5. Click Download and follow the prompts on your screen.
Log in to the Patch Manager server as a local administrator, preferably using the Patch Manager service account (if you created this account).
Run the SolarWinds Patch Manager installer and complete the installation. The installer will prompt you to install any missing prerequisite software components.
Run the DBHelper.exe command and check for errors.
Re-enable any antivirus software.

See Setting up Patch Manager after the installation for additional installation details.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.