Sunday, February 19, 2012

2005 mgmt studio -> 2000 clustered instance

Is there any way to connect to a SQL Server 2000 clustered instance uinsg 2005 Management Studio? I have not been able to get this to work. Is this a known inability of 2005 mgmt studio?

Hi,

got no problem. Which error are you getting ? Didi you connect to the virtual adress or a node adress. In some cases the direct node adresses aren′′t accessible due to network restrictions.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Connecting to the virtual sql server address. The error message is "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)|||Found it...problem was in getting around the firewall using tcp/ip. After changing the protocol order on the client side and using Named Pipes before tcp/ip, the problem was resolved. Interestingly enough, this was not an issue with SQL Server 2000 EM.

No comments:

Post a Comment