Hi,

When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?

Do I must to install two named instances instead one default instance
and one named instance ?

thanks,
Rubens


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can only have one default instance, the rest have to be named. You can
also create only named instances, and not have a default.

At this point, you can uninstall the default instance. Then, install a
second named instance.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Rubens Sanches" <rubensluque (AT) yahoo (DOT) com.br> wrote

Rubens Sanches wrote:
yes, but you can run every instance on the cluster at the default port 1433.
When clients connect to the instance they do not need the instance name when
connecting to the server as long as they use tcp/ip and now the
sqlserverport. Try osql -E -Sserver02,1433 or server02,1433 when
registering the server whith the enterprise manager. When you create an odbc
connection deselect automaticly detect the server port, fill in the port
number and forget the instance name.

--
Hans

Hi

Check that SERVER01 is actually a cluster resource. For clusters, the only
way for it to be correct is virtualservername\instancename

SERVER02/I2 is correct, but SERVER01 can not be.

Regards
Mike

"Rubens Sanches" wrote: