Connect to SQL Server Cluster - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Connect to SQL Server Cluster

Author

Topic

baskaranselva
Starting Member

2 Posts

Posted - 2008-11-26 : 15:14:09

Hi,
I have a SQL Server 2005 cluster, which has been installed as a default instance. My Static port is 1432. I am able to connect to the instance using the virtual name without mentioning the port number. When I try to connect using IP address, I am able to connect only using port number.
Whether there is an option to conect via IP address without mentioning the port number.
I have another SQL Server 2005 cluster which has static port as 1433 and I am able to connect via IP address without mentioning the port number.

Please let me know your comments

Thanks
Baskaran

Elisabeth Redei
Starting Member

15 Posts

Posted - 2008-11-26 : 16:10:12

Hi Baskaran,

1433 is the default port so that makes sense. Check which protocol your connection is made with by querying sys.dm_exec_connections and you will probably see that when you specify the name, you are not using TCP.

/Elisabeth

elisabeth@sqlserverland.com

baskaranselva
Starting Member

2 Posts

Posted - 2008-11-26 : 17:40:58

Thanks Elisabeth,

Is there any configuration change can be done in order to connect to a cluster instance without mentioning port number 1432.

Baskaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources