dbTalk Databases Forums  

cluster connection issue

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering cluster connection issue

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


Discuss cluster connection issue in the microsoft.public.sqlserver.clustering forum.



Reply
Page 6 of 6 < 1 2 3 4 5 6
 
Thread Tools Display Modes
  #51  
Old   
egsj
 
Posts: n/a

Default Re: cluster connection issue - 09-28-2008 , 07:55 AM





Named instance uses a dynamic port. Try to assign a static port number for
your new named instance and make sure that this port is open on the FW.

"tagtagboys (AT) gmail (DOT) com" wrote:

Quote:
Thanks for your replies. I've tried opening ALL ports on the firewall
between the two zones to troubleshoot but still having same problem.

SQL Browser service is running on both nodes on the failover cluster.
Basically the errors I get are along the lines of "Connection failed,
SQL Server does not exist or access denied"





On Sep 23, 3:30 am, "Geoff N. Hiten" <SQLCrafts... (AT) gmail (DOT) com> wrote:
One known issues with clusters and firewalls is that while you connect to
the virtual IP address, the reply always comes from the physical IP address.
You will need to allow connections from each physical public NIC back
through the firewall.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

tagtagb... (AT) gmail (DOT) com> wrote in message

news:1d380ca5-126d-43d7-a642-e4e726ea3a2c (AT) s9g2000prg (DOT) googlegroups.com...



Hi

We have an application running on an NLB cluster in the DMZ.
Application data is stored on a standalone SQL 2005 Std server located
not in the DMZ but inside the company's private network. Have
recently setup a 2-node SQL 2005 Std failover cluster running on
Windows 2008 Ent, all 64-bit and in the process of pointing the
application to it.

For some reason I'm having problems connecting to the new cluster.
Have tried allowing all traffic thru the firewall between dmz and
trust zones but no luck. I can ping the SQL cluster as well as the
standalone SQL server from the DMZ and vice versa, but can only get a
successful test ODBC connection to the standalone server.

Windows firewall already disabled on the SQL cluster and no antivirus
is installed. Any ideas?

Thanks
TI

Reply With Quote
Reply
Page 6 of 6 < 1 2 3 4 5 6

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top