Orion Configuration Wizard error on SQL Network Interfaces table on Orion Platform

4/8/2019 6:48 PM

5/9/2023 5:34 AM

The following exception occurred on the platform when the connection with the database was lost during the configuration wizard process:

Database configuration failed:

Exception while configuring plugin Orion Core Services component Orion Database. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Orion Platform

There are several causes for this:

• Server name is incorrect
• SQL Instance name is incorrect
• DNS cannot resolve the SQL server
• SQL Server Browser service is not running
• Port 1433 has not been opened bidirectionally

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 January 21, 2018).

 

1. Make sure your server name is correct, e.g., no typo on the name. 
2. Make sure your instance name is correct and there is actually such an instance on your target machine.
3. Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server
4. Make sure SQL Browser service is running on the server.
5. If the firewall is enabled on the server, put sqlbrowser.exe and/or UDP port 1434 into the exception.
6. Ensure TCP Port 1433 is open bidirectionally

Additional resource: Solarwinds Port Requirements