connect to named instance in a cluster

Giganews Newsgroups
Subject: connect to named instance in a cluster
Posted by:  Claudia (Claud…@discussions.microsoft.com)
Date: Thu, 9 Aug 2007

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

Replies