SQL Server DB connectivity

SQL Server DB connectivity

  

Hi,


Please can you help me with this. 

Using Administration->Database Connections, I am trying to connect to a local SQL Server. DB. But it is failing with the error shown below:

Connection String test failed: 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: TCP Provider, error: 0 - The wait operation timed out.)

Please note that:

TCP/IP is enabled

SQL Server is configured to Allow Remote Connections

Firewall is On - please can you help us with the IP/URL that should be white listed/exempted

Thanks & Regards,

Prem

It might be related to your SQL Server instance configuration on local connections.

Have you taken a look at the article bellow?

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-2017