dbTalk Databases Forums  

cluster connection issue

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


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



Reply
 
Thread Tools Display Modes
  #1  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default cluster connection issue - 09-21-2008 , 05:35 AM






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
  #2  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM






On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #3  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #4  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #5  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #6  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #7  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #8  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #9  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
  #10  
Old   
tagtagboys@gmail.com
 
Posts: n/a

Default Re: cluster connection issue - 09-21-2008 , 03:38 PM



On Sep 21, 10:35*pm, tagtagb... (AT) gmail (DOT) com wrote:
Quote:
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
Also forgot to mention the new SQL cluster is a named instance whereas
the standalone was default...thanks in advance!


Reply With Quote
Reply




Thread Tools
Display Modes

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.