Serverdba


Hello,

I install Cluster naming instance of MSSQL 2005 Enterprise edition with SP2 and latest patch.

When I try connecting this instance from outside of the server by "server name\instance name" I got connection error.

But when I connecting by "server name,port number" it's connecting with no problem.

Can someone help me resolve connection outside of the server with "server name\instance name"

Thanks




Re: Cannot connect by naming instance in mssql 2005 Cluster

Jag Sandhu


Hi

Is your browser service running

SQL Server Browser is not a clustered resource and does not support failover from one cluster node to the other. Therefore, in the case of a cluster, SQL Server Browser should be installed and turned on for each node of the cluster. On clusters, SQL Server Browser listens on IP_ANY.

Jag







Re: Cannot connect by naming instance in mssql 2005 Cluster

mrdenny

Also make sure that you are connecting to the correct virtual name. If you connect to the wrong virtual name you may not be able to connect.





Re: Cannot connect by naming instance in mssql 2005 Cluster

Serverdba

I have SQL Server Browser installed and turned on for each node of the cluster. And listens



Re: Cannot connect by naming instance in mssql 2005 Cluster

Serverdba

I am connecting correct VN. it is connecting using port but not name.

(vServer name\instance name - NO,

vServer name,port number - YES)





Re: Cannot connect by naming instance in mssql 2005 Cluster

mrdenny

Sounds like something is wrong with the service broker. Try restarting the service broker on the node is question.

What happens if you move the named instnce to the other node






Re: Cannot connect by naming instance in mssql 2005 Cluster

Serverdba

Same thing.



Re: Cannot connect by naming instance in mssql 2005 Cluster

dahc reilloc

Dude, check this out

http://blogs.msdn.com/sql_protocols/commentrss.aspx PostID=539706

I think this is your issue