Named Instance in a SQL 2000 Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rubens Sanches - 23 Mar 2005 19:07 GMT

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

Reply to this Message

Rodney R. Fournier [MVP] - 23 Mar 2005 19:15 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Reply to this Message

Hansde Bruin - 23 Mar 2005 20:08 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> Do I must to install two named instances instead one default instance
> and one named instance ?

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.

Signature

Hans

Reply to this Message

Mike Epprecht (SQL MVP) - 24 Mar 2005 14:57 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Reply to this Message

Uttam Parui[MS] - 25 Mar 2005 07:24 GMT

Mike,

SERVER01 is a default clustered SQL instance and is the virtualservername. Since it is a default instance, it will work. It does not need an instance name.

Best Regards,

Uttam Parui
Microsoft Corporation

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Reply to this Message