Sql server named instance connectivity from outside

Question

Hello Experts,
We are using Sql server 2012 sp4 on standalone systems. Browser service is running, and defaults port is used.

While trying to connect to server AB from Server DC, unable to connect. Vice versa. However with using comma port number, it’s connecting. Please suggest

Thanks,
Vinod

Answer 1

See "Named instances with default port":
https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15#ports-used-by-

Answer 2

Hi @Vinod Mallolu ,

you can gather some related information from error log, check if SQL is listening on appropriate protocols by reviewing the ErrorLog.

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.

get instance name from configuration manager:
Sign in to the computer hosting the instance of SQL Server.
Start SQL Server Configuration Manager.
In the left pane, select SQL Server Services.
In the right pane, verify the name of the instance of the database engine.
SQL SERVER (MSSQLSERVER) denotes a default instance of SQL Server. The name of the default instance is <computer name>.
SQL SERVER (<instance name>) denotes a named instance of SQL Server. The name of the name instance is <computer name>\<instance name>

on the SQL Server computer you must configure the firewall to allow connections to the TCP port used by the Database Engine. The default instance is listening on TCP port 1433, inquire among your admins if anyone blocked UDP traffic on port 1434. Those are the typical reasons if the SQL Server Browser service is up and running.

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

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.