SQL Server Performance

Cannot contact clustered SQL via tcp/ip

Discussion in 'SQL Server Clustering' started by phil.holmes, Jul 16, 2004.

  1. phil.holmes New Member

    We have an active / passive SQL2k cluster on Windows 2000.
    Both named pipes and tcp/ip protocols are enabled, but we cannot connect from another machine via tcp/ip. (I ultimately need to connect through a firewall)
    If the client is configured to use on tcp/ip the connection fails.
    I have tried removing tcp/ip and re-adding it to the server, but no luck.
    This only affects our clustered sql, no clustered are ok.

    Anyone know what the problem is?

    Thanks.
    Phil
  2. satya Moderator

  3. phil.holmes New Member

    Thanks for replying.
    When trying to connect via Enterprise Manager the error is usually
    "SQL server does not exist or access denied"
    I cannot telnet to 1433 like I can on several other SQL 2k servers here.
    I'm not sure what you mean when you say
    "And also check Virtual SQL Server IP address for correct connection."
    but the IP I am using is correct, and belongs to the clustered virtual instance.

    Phil
  4. phil.holmes New Member

    A little more info that might help.
    I have obtained and run PortQry, (PortQry -n virtualname -e 1433) this states that port 1433 is NOT listening on this server.
  5. satya Moderator

  6. Argyle New Member

    Are you sure it's using port 1433? Can you telnet to 1433 locally from the server running the sql instance?
  7. phil.holmes New Member

    It would appear that my problem is solved, thanks to satya I have spoken to Microsoft PSS and it appear that the value in HKLMSOFTWAREMicrosoftMSSQLServerClusterClusterIpAddr was incorrectly pointing at the wrong IP address. Although this appears to have had no other side effects!<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks,<br /><br />Phil<br /><br /><br />

Share This Page