Re: cluster connection issue

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@xxxxxxxxx" wrote:

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...@xxxxxxxxx> 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...@xxxxxxxxx> wrote in message

news:1d380ca5-126d-43d7-a642-e4e726ea3a2c@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



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


.

Relevant Pages

  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Will anything change when I install SQL 2008 on the laptop? ... Queries to the Data Engine must go to the port that SQL Server is ... More info: How to: Configure a Windows Firewall for Database Engine Access ...
    (microsoft.public.sqlserver.connect)
  • Re: hack using xp_cmdshell
    ... > Fortunately 14 years of SQL experience, and a little common sense, would ... > should run it on a different port and just have my developers connect to ... Tibor Karaszi, SQL Server MVP ... >> install SQL Server in Windows Only mode and then Switch down to Mixed ...
    (microsoft.public.sqlserver.server)
  • Re: connecting to sql svr express over internet
    ... also add the prefix tcp: to specify the TCP protocol (or np: for named ... of the server and the protocol and the port to be used. ... See SQL Server Configuration Manager | SQL Native Client Configuration | ... I have Sql Server 2005 Express edition installed on a server. ...
    (microsoft.public.sqlserver.server)
  • Re: Getting an absolutely up to date version of MSDE
    ... The real reason for updating is that I have online SQL Server ... >> Enterprise Manager connection does not now work (has worked splendidly ... >dynamically assigned port (actually letting the remote MDAC client stack be ...
    (microsoft.public.sqlserver.msde)