How to connect to sql listener without specifying custom port number - Microsoft Q&A (2024)

2022-04-11T17:55:51.427+00:00

In my company we don't use default port for sql server but the custom one. For example when I connect to named instance with listener I don't have to specify custom port number - just connect ListenerName\InstanceName. We do this with all our servers (around 100). SQL Browser is running everywhere.

Issue is with one of the new listener. When I connect to that one I have to type port number: ListenerName,12345\InstanceName - and I have no idea why it is like that just for this one. I checked all configuration and it is the same as other servers.

SQL Server 2019, Windows Server 2019

Sign in to comment

1. 

   YufeiShao-msft 7,116Reputation points

   2022-04-12T08:27:30.667+00:00

   Hi @MPDBA ,

   In general, when the port is the default port of 1433, then you do not have to specify a port number when connecting to your listener. If you specify a custom port, the client must explicitly specify the port.
   The AG listener port is different from SQL Server instance port
   Here is a thread about these two port, Hope it can give you a little inspiration:
   https://learn.microsoft.com/en-us/answers/questions/601605/alwayson-listener-connection-granted-regardless-sp.html

   AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

   -------------

   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.

   0 commentsNo comments

   Sign in to comment

Sign in to answer