Hi,

I a a two node win 2003 cluster running active / active with serveral SQL
2000 virtual servers between them. I have noticed the following and am
wondering if this is correct behaviour and if not how I correct it:

1) If I start up enterprise manager and go to register one of the Virtual
servers, it is not automatically found to be added but normally connects OK
if I type in the virtual server/Instance.

2) The virtual servers are not able to be connected to from client PC's
without running cliconfg.exe and alias being created with the alias name the
same as the virtual server/instance and the connection actually including the
port number that SQL virual server is on.

Any guidance appreciated.
Jon

Hi

Generally, we have all our developers use "virtualname\instancename,
portnumber" to connect to our servers as we have a number of firewalls that
might not let port 1434 traffic though. Also check that MDAC 2.6 or later
are on the client machines.

EM not showing all the instances can be caused by 1434 issues too, like with
clients.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Jon" <Jon (AT) discussions (DOT) microsoft.com> wrote

Hi Mike,

Thanks for the reply.

I knew what was causing the problem but was wondering if this behaviour was
normal or had I missed something in the setup to make them easily accessible.

The EM problem isn't too bad but when you use third party software you have
problems with the client connecting if it cannot find the database because of
the port number. So far it has been for a limited number of clients and I
have created the alias using cliconfg. I now have an app. to go to 300+
clients so want to make sure all our config. is correct as this is the first
serious use of the cluster.

Jon

"Mike Epprecht (SQL MVP)" wrote:

Hi Mike,

Another poinr - I am not a developer (I'm the network infrastructure
manager) how would the developers specify the port number in their app if it
is writen in house?

Thanks,
Jon

"Mike Epprecht (SQL MVP)" wrote:

Hi

In the connection string when they connect to the Server.

e.g

ConnectionString = "Initial Catalog=FoodMart 2000; Data
Source=SQLServer01;Connect Timeout=15;Trusted_Connection=yes"

Changes to

ConnectionString = "Initial Catalog=FoodMart 2000; Data
Source=SQLServer01\Instance01, 5001;Connect
Timeout=15;Trusted_Connection=yes" is it was on port 5001.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Jon" <Jon (AT) discussions (DOT) microsoft.com> wrote

Jon wrote:
When the sqlservice accounts are not local admins the udp 1434 listener wil
not work. The best way to check this is by installing ethereal on a client
and trace a connection setup

--
Hans