Post reply

SQL server Connectivity issue on cluster nodes

  • March 2, 2009 at 3:48 pm

    #131478

    I'm running SQL Server 2000 on 3 node cluster. If a SQL Instance runs on node 2, I'm able to connect to that instance from SQL Client on my desktop without specifying the port number. But when it runs on node 1, I have to specify the port number to connect to instance.

    can anyone please throw some light on this..

    Thanks in advance.

  • March 2, 2009 at 5:24 pm

    #952179

    Is browser service running on that node? If not, then enable it and start it.

    MJ

  • March 2, 2009 at 5:45 pm

    #952182

    This is sqlserver 2000 not 2005.

  • March 3, 2009 at 4:43 am

    #952321

    Is it listening on static port or dynamic one? Also, check whether aliases have been configured on second node or not.

    MJ

  • October 28, 2011 at 8:01 am

    #1400634

    Check the firewall settings on the problem node, if you have to specify the port to be able to connect then this is likely your problem.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply