Network Management

Cannot connect to the SQL server after migration or new installation of the Orion Platform

Configuration Wizard cannot connect to SQL database giving the error "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."

First published date

10/15/2018 2:06 PM

Last published date

11/28/2022 4:56 AM

Overview

After migrating the SQL server to a new machine, or  deploying a new SQL server, you get the following error in the Configuration wizard when trying to configure the 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.

Product section

Network Performance Monitor

Cause

The SQL server is not configured to accept incoming connections.

Resolution

  1. Use the name of the instance as well as the server.
  2. In the Configuration Wizard, make sure you enter the SQL Server name in the format:
SERVERNAME\INSTANCENAME
  1. Make sure no firewall is blocking port 1433.
  2. There should be no firewall between the Orion server and the SQL server, blocking communication on port 1433.
  3. Verify that the SQL Server Browser service is running:
    1. On the SQL Server, open services.msc.
    2. Verify that the SQL Server Browser service is NOT disabled, and is running.
    3. If it is stopped, start it.
  4. Verify that the TCP protocol is enabled on port 1433
    1. On the SQL Server, open SQL Server Configuration Manager.
    2. Under each category, make sure that TCP/IP is enabled under Client Protocols.
    3. Under Protocols for <instancename> > double click TCP/IP > click IP Address tab > add 1433 to TCP Port for IP1.
  5. Verify DNS is resolving the proper IP address/DNS name combination.
  6. If you need to, create a new user in the SQL Database via SQL Management Studio with sysadmin and dbowner rights. Run the Configuration Wizard and try to input this name instead of the default user.