June 20, 2003 at 1:01 pm
Can any one let me know how do I create second instance on Active / Passive Sql2000 Cluster
venkatesh
venkatesh
June 20, 2003 at 1:07 pm
Once installing second instance, It will be active/active. The installation of second instance is same as the way you installed first instance. If you alrady have default instance installed, the second instance will be the named instance.
June 20, 2003 at 1:07 pm
It's really not very different from creating the initial instance. Make sure you have the name, the IP address, the disk (it'll have to be a separate set of shared disks than what the first instance has). Another key difference is that it'll have to be a named instance because of the way the services work. These are some of the highlights. You can find more info here:
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
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
June 20, 2003 at 1:09 pm
Install SQL Server (pretend you are doing a new install). You will get to a window where you can set the instance name. There will be an option for the Default (which should be grayed out) and an option to input a new instance name. That's basically it. The new instance will need a new IP address and if you are using TCP/IP, it will set a new port to listen on.
-SQLBill
June 20, 2003 at 1:20 pm
Configuration of ours,
We have two nodes, SQL1 and SQL2 with Active / Passsive. We need to create the second instance which will use for different client, Still it will be Active / Active. Please let me because we need to perform this this weekend.
venkatesh
venkatesh
June 20, 2003 at 2:20 pm
Right. Install the second instance just as you did the first. You'll need the name, the IP address, and the instance name. Read the article cited and you should be in good stead.
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply