Unable to connect to SQL server

  • Hi Friends,

    We have a two node SQL cluster, with SQL 2008 on Windows 2008. Till yesterday we were able to connect from clients to this cluster. Today we are getting time out errors while trying to connect from clients. Checked that 'remote connections to this server' is enabled. Its not even connecting from the passive nodes. We are able to connect from the active node only. We also recycled SQL services. Still no use. We tried to connect with named pipes, with port number and also by creating aliases.

    Can anyone help?

  • windows firewall ? connections don't just go away, something will have changed.

    Try telnet to the sql port, then make sure the server network protocols are enabled.

    I'd still suspect port blocking.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • Is the Clustername pingable? if it is, try this? Go to Server Property-->Connections

    >-->Allow remote connections to this server..Set the timeout as 0.

    >-->Maximum connections =0

  • Hi

    Thanks. The issue was with port only. In last few days security team has updated e-trust anti virus and port 1433 was removed from the exception list of firewall. I added port 1433 in windows firewall exception list [Add Port] and the issue got resolved.

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

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