Re: connect to named instance in a cluster

The short answer is that the behavior you observed is perfectly normal. SQL will decide on a port when the service restarts unless it is a default instance or you have locked SQL to a specific port number.

You can use the SQL Server Configuration Tool to "lock" the instance to a specific port. This is done whenever a client needs a static port to connect to.


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




"Claudia" <Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:17766F0D-BF9B-4DA1-9D1A-126B57E422B4@xxxxxxxxxxxxxxxx
Windows 2003 N+1 cluster, SQL2005 enterprise + sp2

I have a N+1 cluster and installed default sql instance and one named
instance. SQL Browser service is running on the node which owns the named
instance; UDP port 1434 is opened on the firewall.

I had problem connecting to the named instance. Then I found the port number
in the sql error log which the named instance listens on. Opening this port
in firewall solved the connection problem.

My questions:

1. What's the best/secure way to connect to the named instance in a cluster?
Why does it not work with UDP opened and SQL Browser running before the
specific port is opened?

2. Will the port number change when the sql instance restarts? If yes, how
to assign a static port number?

Thanks.

Claudia

.

Relevant Pages

  • Re: SQL Management Studio will not connect to x64 bit SP2 server
    ... Management studio communicates over the port that SQL is listening on. ... Management Studio on the x64 bit server with named instance. ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection to SQL Server 2005
    ... Only the default instance listens on port 1433. ... named instance or are running SQL Express, which is a named instance named ... Microsoft, SQL Server Books Online ... on a Windows 2003 Server machine behind a router. ...
    (microsoft.public.sqlserver.connect)
  • sql browser and named instance connection issue
    ... Checking file permisisons on:\Program Files\Microsoft SQL ... Restart SQLBrowser and then your named instance. ... The suggestions in the blog post include setting the Port property in SSAS ...
    (microsoft.public.sqlserver.olap)
  • 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)
Loading