SQL Cluster Connection Problem from Windows 2008 Machine

#11

Sazzad wrote:

Quote:

Hi,

We have a sql server 2005 cluster on Windows 2003 64 Bit Machine. From our
whole network we can connect to the sql server fine. TCP/IP, Named Pipes are
both allowed.

Recently we installed couple of Windows 2008 machine on our network. When we
try to connect to the cluster from Windows 2008 machines, it takes atleast 10
sec to connect. No error logs anywehere. We have profiled the connection from
SQL Profiler and saw that when ever the windows 2008 machine trying to connet
it's using named pipes. We have tried changing the protocol order,
specifiying the protocol in connection string.

But when we try to connet other Sql servers in the network, which is not
clustered, it connects fine from Windows 2008.

Spent last couple of days trying to look for solutions on the web with no
luck.

On the SQL cluster we also have a named instance sql server on a diff
cluster group. From Windows 2008 we can't even connent to that named instance.

In Summary:

Server
------------ Client
----------------------------------------------------------------------------------------------
SQL Cluster 2005 64 bit SP2, OS: W2k3 64 Bit <--Slow Connection --
W2K8

SQL Cluster 2005 64 bit SP2, OS: W2k3 64 Bit <--No Connection --
W2K8
(Named Instance)

SQL Browser Is also running on the cluster. We have no problem from any
other domain machines, xp, w2k3, w2k.

Our AD is Windows 2008 based with Domain Functional Level Set to -Windows 2008

Any help would be much appreciated.

Thanks

Sazzad

I propose you ask Microsoft why SQL server is firewall and now also
Vista and Windows server 2008 incompatible for 8 years now:
https://connect.microsoft.com/SQLSer...dbackID=296165

Temporarily disable windows Firewall completely if it is possible or
add an Exception to test this.

Regards,

Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Cluster Connection Problem from Windows 2008 Machine

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: SQL Cluster Connection Problem from Windows 2008 Machine - 12-06-2008 , 05:16 PM