SQL connectivity issues

Symptoms

When you are connecting to the SQL Server instance hosting the Alloy Discovery database from your computer, these errors may occur:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist

SQL Server Network Interfaces: Error Locating Server/Instance Specified (xFFFFFFFF)

Cause

These and other errors are caused by connectivity issues between your client computer and your SQL Server instance hosting the database. For example, the "SQL Server does not exist" error occurs when the client is unable to find the SQL Server. The "Error Locating Server/Instance Specified" error is caused by similar reasons.

Resolution

Microsoft has published an extremely thorough article on how to troubleshoot SQL Server connectivity issues. See "Troubleshoot Connecting to the SQL Server Database Engine" at https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017.

Before you delve into troubleshooting specific connectivity errors, we recommend you to go through a sequence of easy steps that may resolve the majority of connectivity issues to SQL server.

  1. Ensure SQL Server Browser service is running.

  2. Ensure TCP/IP protocols are enabled.

  3. Verify basic connectivity over IP address and check for any abnormalities: ping –a <SQL Server machine>, ping –a <SQL Server IP address>. If you notice any issues, work with your network administrator to fix the same.

  4. Get the SQL Server instance TCP port. The default instance is listening on TCP 1433. If there is more than one instance of SQL Server installed, some instances must use other port numbers.

  5. Ensure your firewall is configured properly: the SQL Server instance TCP port is opened.

  6. Ensure the user has a login in your SQL Server instance and appropriate permissions to connect to the database that the user is trying to connect to.

  7. Test your ability to connect to your SQL Server instance using TCP.

    TIP: For example, using your PowerShell, execute this:
    Test-NetConnection -ComputerName <SQL Server name or IP> -Port <SQL Server Port>

  8. Test your ability to connect from a client application installed locally on the computer that is using SQL Server (use your SQL Server Management Studio).

    TIP: If the user with Windows Authentication is experiencing login failures, try to use a Database Account with SQL Server authentication.

    NOTE: If your configuration is set properly, but the issue persists, please report it to our Support Team and we will do our best to help you. For details, seeObtaining Technical Support.

More information for administrators