October 16, 2002 at 8:26 pm
I´m instaling SQL 2000 active / active, my question is that i need to give the instance name, on the first node i put the default, when i go to install on the second node i need to put a instance name...
Should i use instances names ? on both ? how can i solve this ?
When a client connects it can connect only to the virtual ip or he needs to put the instance name ?
Please help !!!!!!
everything works with 2 diferent instances names on both machines, as i can see when i install the first node it replicates to the second one, so in the second instalation i can´t use the same instance name....
October 17, 2002 at 7:06 am
You can have only one default instance and the rest must be named instances and you don't have to install the default instance in the Active/Active environment. Both can be named instance. During the installation, uncheck the default, the installation will ask you to enter the named instance.
The client can connect to either SQL server virtual IP address or the instance name. Depending on what network protocol you use for connecting to SQL Server, you may also have to configure the client netwoek utility.
October 17, 2002 at 7:32 am
Thank you for your answer, so in the two instalations of the cluster (Active/Active) i must give a instance name, i got the virtual name and instance name.
My question was not to have instance name and using default on both of them if it was possible.
October 17, 2002 at 7:51 am
You can't in Active/Active installation.
October 17, 2002 at 7:55 am
You can't use default on both of them. This is basically how clustering SQL Server works for an active/active cluster.
When you install the first instance of SQL Server, you'll be prompted for all the virtual information. I'll use SQLV1. If you choose to use a default instance, a service will be added on both nodes of the cluster:
MSSQLServer
This will be for the default instance. The physical node that is running SQL Server at the time will have this service started. The other physical node will have it stopped. That's how SQL Server is "clusterable." If you move the node you're running SQL Server on, you'll see it stop on the first node and start on the second node.
As a result, when you instance a second instance of SQL Server, it has to be a named instance. The service MSSQLServer is already taken by the first default instance. It'll create a service based on the name of the named instance.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
October 17, 2002 at 8:04 am
Yes the simplest way is to get 2 virtual servers and in the instance for example the name of physical server.
Thanks 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply