SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,739 questions
Which error message do you get?
how to connect remotely to sql server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 9%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aratrika Kundu
0
Reputation points
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
Sort by: Most helpful
-
Olaf Helper 40,896 Reputation points2024-04-17T09:58:28.0633333+00:00 -
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
Sign in to comment -
-
ZoeHui-MSFT 33,126 Reputation points2024-04-18T02:35:58.35+00:00 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 33,126 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 33,126 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
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive 8,521 Reputation points Microsoft Employee2024-04-18T14:04:26.98+00:00 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!