how to connect remotely to sql server

Question

how to connect remotely to sql server

Aratrika Kundu 0

i have followed all the instructions mentioned in websites to enable remote connectivity to sql server. i am still not able to connect to the server. what could be the possible reason?

3 answers

Your answer

Answer 1

Olaf Helper 47,581

Which error message do you get?

See https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview

Aratrika Kundu 0 Reputation points

2024-04-18T05:35:53.6433333+00:00

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) (Microsoft SQL Server, Error: -1)

this is the error i see

Answer 2

ZoeHui-MSFT 41,536

Hi @Aratrika Kundu,

Is there any error message for us to narrow down the issue?

In addition, you may follow the tutorial to see if you have missed any steps.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Aratrika Kundu 0 Reputation points

2024-04-18T05:36:09.8333333+00:00

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) (Microsoft SQL Server, Error: -1)

i observe this error
ZoeHui-MSFT 41,536 Reputation points

2024-04-18T06:21:33.0066667+00:00

Hi @Aratrika Kundu,

Please check below docs which has provided solution, you may follow it and have a try.

A network-related or instance-specific error occurred while establishing a connection to SQL Server
Aratrika Kundu 0 Reputation points

2024-04-18T06:26:21.2966667+00:00

i followed the tutorial mentioned by you in the first commet i still get the below error from remote device:
Aratrika Kundu 0 Reputation points

2024-04-18T06:26:46.51+00:00

i will check the troubleshooting document
ZoeHui-MSFT 41,536 Reputation points

2024-04-23T06:51:37.4333333+00:00

Hi @Aratrika Kundu,

Try to connect to the remote server with port number, if you have specify another port, please change it.

x.x.x.x\instance,1433

Answer 3

RahulRandive 10,501 Volunteer Moderator

Hi

Please check the similar threads and possible mitigation for given error.

https://learn.microsoft.com/en-us/answers/questions/1192950/how-can-i-solve-this

https://techcommunity.microsoft.com/t5/sql-server/sql-server-connectivity-issues-ideas/m-p/3794493

Thank You!

Share via

how to connect remotely to sql server

3 answers

Your answer