April 2, 2009 at 6:34 am
Ive got a SQL 2000 cluster. We need a SQL2005 instance running on the same windows cluster.
If at all possible, I'd like the SQL2005 instance to be a default instance.
We would need to allocate a new server name/IP for the new virtual, but can this be done?
I have found some info on SQL 2000 saying that there can only be one default instance per windows cluster, but Im not sure about mixing versions (and theres not alot written about intermingled versions) that I have found quickly.
If its got to be a named instance, so be it... however a default instance would be great.
We eventually plan to upgrade the software connecting to the databases on the SQL2000 instance to a platform that supports SQL2005,and if this new instance can be installed as a default instance, it would make life very easy for upgrading them to 2005 eventually!
April 2, 2009 at 6:36 am
either way there can only ever be 1 default instance of sql when installing multiple instances. With clustering remember the virtual name and IP are used to connect to the sql instance and these too, are unique in the domain/network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:39 am
right, so I suppose my question is:
one default instance per WINDOWS CLUSTER or,
one default instance per Virtual Server name/IP?
April 2, 2009 at 6:41 am
the wording here is a bit unclear, and this only applies to SQL2000, but leads me to believe that this isnt possible.
unfortunately I dont have a cluster that isnt in production that I can test this on... otherwise I'd have done so...
April 2, 2009 at 6:43 am
when you install the database engine on a sql cluster the wizard looks normal for the first few steps and will ask you to specify the instance name. There will be a button called "Installed instances" which shows the non cluster representation of the installed instances. If deault hasnt been installed then you'll see it there. However, even if you do install a default or named instance it is the Virtual name and IP that are used to connect.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:45 am
LAW1143 (4/2/2009)
unfortunately I dont have a cluster that isnt in production that I can test this on... otherwise I'd have done so...
http://support.microsoft.com/kb/260414%5B/quote%5D
grab yourself a copy of virtual server 2005 R2 or vmware server 2 and create a virtual sql cluster to test on!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 6:48 am
Perry Whittle (4/2/2009)
when you install the database engine on a sql cluster the wizard looks normal for the first few steps and will ask you to specify the instance name. There will be a button called "Installed instances" which shows the non cluster representation of the installed instances. If deault hasnt been installed then you'll see it there. However, even if you do install a default or named instance it is the Virtual name and IP that are used to connect.
That makes sense, thanks for the responses!
April 2, 2009 at 6:59 am
your welcome, give the virtual server idea a crack it'll make an ideal testbed for you and you wont get fired for wrecking it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply