question

JesalpuraBhupendrakumarGTRTechnolo-4955 avatar image
0 Votes"
JesalpuraBhupendrakumarGTRTechnolo-4955 asked AmeliaGu-msft answered

Unable to Telnet SQL PORT -SQL Server 2019 Developer edition with CU9

Hi Team,


I am using a SQL Cluster with single now.

Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64) Mar 22 2021 18:10:24 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

I am able to connect my SQL Server from SQL Studio Manager but while trying to telnet localhost 1433 or telnet A.B.C.D 1433 ( Consider A.B.C.D as IP Address ) , Giving Error " Connecting To 192.168.157.32...Could not open connection to the host,

TCP/IP and named pipes are already enabled.


-Regards,
Bhupendra

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So is this instance listening on port 1433?

And why do you want to connect with Telnet?

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered JesalpuraBhupendrakumarGTRTechnolo-4955 commented

Hi @JesalpuraBhupendrakumarGTRTechnolo-4955

Welcome to Microsoft Q&A!
Was your SQL Server cluster installed as a default instance or named instance? Please make sure it is listening on port 1433.

Giving Error " Connecting To 192.168.157.32...Could not open connection to the host,

Is 192.168.157.32 the IP address of your SQL Cluster?
If it is not, please try to telnet <sql cluster name or sql cluster ip> port.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Amelia,



Thanks for reply. IP Address of SQL 2019 Vm are below :-

Server IP Address :- 192.168.157.32 (Can't telnet)
Fail-over Cluster IP Address :- 192.168.157.33 ( Can't Telnet)
SQL Cluster IP Address :- 192.168.157.34 ( I can telnet )

While in SQL 2016 Developer Edition SQL Cluster I can telnet to localhost as well as Server IP Address and Fail-Over Cluster IP Address as well with SQL Port.

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi JesalpuraBhupendrakumarGTRTechnolo-4955,

Thanks for your reply.

While in SQL 2016 Developer Edition SQL Cluster I can telnet to localhost as well as Server IP Address and Fail-Over Cluster IP Address as well with SQL Port.

Is there any other SQL Server instance installed on the node server?
The SQL Server cluster instance is binding with Virtual IP Address and virtual network name (SQL Server cluster resource), and has nothing to do with the IP address of the node server. We cannot connect to SQL cluster instance and telnet SQL cluster using the IP address of the node server. The virtual IP address and virtual network name is used to make a connection to SQL Server databases from your client applications instead of using the physical server name or physical IP address of the server.

Best Regards,
Amelia


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.