Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2007-10-16 : 07:35:37
|
| Well following on from my post on Collation sequences, what has been decided is to move from a Single Instance Cluster (Dual Node), to a two instance cluster (Dual Node).Now I'm happy installing a Single instance cluster, and from what I've read the installation for a dual instance is pretty much the same, although playing with a cluster in our VMWare environment has shown that it may not be as simple as I think, Or (Most likely) I am making assumptions on how to do things.Firstly I need to provision some Additional Disk Space (LUNS) on our SANS to be presented to the Servers in the Cluster, as the instances cannot share disk resourcesSecondly, Create a Named Pipes 'connection' for the instance as per [url]http://support.microsoft.com/kb/815431/en-us[/url] this KB ArticleNow when running the Install Program Do I have to specify a new Virtual Server for the instance? I have been assuming that I can have a Virtual Server Called BCSQLVS01 With a default Instance, and then the second instance would be BCSQLVS01\IMAGES, although from the limited amount of playing that I've been able to do, It appears that I have to set up a new VS, BCSQLVS02 to run the BCSQLVS01\IMAGES instance. . . . . . Or am I merely confused?Some guidance would be helpful at this moment in time, as the BOL doesn't really cover this in a step by step sort of manner, and I've yet to find a good online article that describes it. I'll keep looking in the meantime-- RegardsTony The DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-16 : 11:58:16
|
| Each SQL instance gets its own virtual server. You'll need to set that up inside Cluster Administrator and also have your network admins provide an IP address for it. You can't reuse BCSQLVS01 for the second instance name. It must be unique on clusters.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-10-17 : 06:20:26
|
| Thanks Tara,I'll hopefully be able to try this out today.-- RegardsTony The DBA |
|
|
|
|
|
|
|
|
Multiple Instance Clustering