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