Re: Connecting to an instance in a cluster

The only IP you need to fix is the Public IP for the SQL Instance.

GNH


"Yuhong" <Yuhong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:136D4B36-754C-4ACC-B995-9829A4616B8F@xxxxxxxxxxxxxxxx
Hi Geoff,
Thanks for your information. There are many IPs in the TCP/IP properties
window in SQL Server Configuration Manager. Which one should I use? Should I
do the lookback adapter IP or do them all? Sorry I am really confused about
this part. The online help is not very clear about this. Thanks again!

"Geoff N. Hiten" wrote:

You will need to use the SQL Server Configuration Manager to set a static
port for each named instance. You only need to set it once or each
instance on the cluster. You cannot use port 1434 or 1433. Then you open
the firewall for those ports. Note that you will have to restart each SQL
instance after setting the ports so SQL can bind correctly.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP





"Yuhong" <Yuhong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54E0E94E-FAD2-4EDE-86A3-5D63C4E6E5E4@xxxxxxxxxxxxxxxx
> Browser Service is running on all nodes. Dynamic ports are used by > default
> and I did not change it. The servers are behind a firewall. I opened > port
> 1434. And port 1433 is open too. I can connect to the default instance
> fine
> remotely and can connect any instances locally.
>
> "Anthony Thomas" wrote:
>
>> Did you configure static or dynamic ports? Is the Browser service
>> running
>> on all cluster nodes?
>>
>>
>> Anthony Thomas
>>
>>
>> -- >>
>> "Yuhong" <Yuhong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:05184BB4-026E-4FBF-AD14-8684B121A86F@xxxxxxxxxxxxxxxx
>> > Yes.
>> >
>> > "Hilary Cotter" wrote:
>> >
>> > > is the virtual server enabled for remote connections?
>> > >
>> > > -- >> > > Hilary Cotter
>> > >
>> > > Looking for a SQL Server replication book?
>> > > http://www.nwsu.com/0974973602.html
>> > >
>> > > Looking for a FAQ on Indexing Services/SQL FTS
>> > > http://www.indexserverfaq.com
>> > >
>> > >
>> > >
>> > > "Yuhong" <Yuhong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > > news:065C8B43-891D-41CC-8602-04FB551CFE34@xxxxxxxxxxxxxxxx
>> > > > Hello, I just setup a few instances on a cluster. But somehow I
>> > > > cannot
>> > > > conntect to the instances remotely using SQL Server Management
>> > > > Studio.
>> I
>> > > > can
>> > > > connect to them locally. I can also connect to the default >> > > > instance
>> fine.
>> > > > Any
>> > > > idea?
>> > > > Thanks!
>> > >
>> > >
>> > >
>>
>>
>>



.

Relevant Pages

  • 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)
  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)
  • 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)