Named Instance in a SQL 2000 Cluster

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.codecomments.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@.yahoo.com.br> wrote in message
news:%23SB%233M9LFHA.1472@.TK2MSFTNGP14.phx.gbl...
> 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.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Rubens Sanches wrote:
> 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 ?
>
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:

> 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.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
|||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
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