May 20, 2010 at 7:28 am
Issue #1:
We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second named instance. However, I am having difficulty finding documentation on the proper way to add the second instance. (We are relatively new to SQL 2008, and this is the first time we have attempted to add an instance to a cluster.)
I tried the following:
1. Run setup.exe on the first node in the cluster to install the new instance
2. (A “SQL Server Installation Center” window pops up)
3. Click on the “Installation” link in the left pane
4. Click on “New SQL Server stand-alone installation or add features to an existing installation” link in the right pane
5. …
6. On the “Installation Type” window, select: (O) Perform a new installation of SQL Server 2008
7. …
However, this new instance does not appear to be clustered. What should we be doing instead? Should we be treating the second instance like a brand new installation for a cluster? Should we be using the "New SQL Server failover cluster installation" link on the "Installation" window for the second instance?
What is the proper way to uninstall our unwanted instance that does not appear to be clustered? I found a couple of links (http://technet.microsoft.com/en-us/library/ms143412.aspx and http://support.microsoft.com/kb/955499) that talk about it, but it appears that those steps risk unregistering DLLs, meaning that those steps could "hose" other things that currently work on the server. Surely there is a better way...
May 21, 2010 at 1:29 am
shew (5/20/2010)
Issue #1:We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second named instance. However, I am having difficulty finding documentation on the proper way to add the second instance. (We are relatively new to SQL 2008, and this is the first time we have attempted to add an instance to a cluster.)
I tried the following:
1. Run setup.exe on the first node in the cluster to install the new instance
2. (A “SQL Server Installation Center” window pops up)
3. Click on the “Installation” link in the left pane
4. Click on “New SQL Server stand-alone installation or add features to an existing installation” link in the right pane
5. …
6. On the “Installation Type” window, select: (O) Perform a new installation of SQL Server 2008
7. …
However, this new instance does not appear to be clustered. What should we be doing instead? Should we be treating the second instance like a brand new installation for a cluster? Should we be using the "New SQL Server failover cluster installation" link on the "Installation" window for the second instance?
To add a new instance you select the option "New SQL Server failover cluster installation"
To add a node to a current instance you use the option "Add node to a SQL Server failover cluster"
Check my tutorial at the following link for installing a SQL Server 2008 clustered instance
shew (5/20/2010)
Issue #2:What is the proper way to uninstall our unwanted instance that does not appear to be clustered? I found a couple of links (http://technet.microsoft.com/en-us/library/ms143412.aspx and http://support.microsoft.com/kb/955499) that talk about it, but it appears that those steps risk unregistering DLLs, meaning that those steps could "hose" other things that currently work on the server. Surely there is a better way...
This is only valid if SQL Server 2008 is installed along side an instance of SQL Server 2000 and you attempt to uninstall
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2010 at 2:59 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2010 at 8:43 am
Hello,
Sorry, for the hijack.
Can I install a new instance on a SQL Server Default clustered instance with the the shared disks being those that are already used by the default instance?
thanks
Sush
June 2, 2010 at 10:00 am
No, you have to allocate drives to that instance.
June 3, 2010 at 3:23 pm
Thanks. I cant seam to find this in any MS documentation.
February 24, 2011 at 7:08 am
Hi, I have similar problem, i have Disk1 for inst1, disk2 for inst2, and disk3 for inst3 but i cant have other instances running on the same SQL networkname.
pls help,
February 24, 2011 at 7:14 am
THE-FHA (2/24/2011)
Hi, I have similar problem, i have Disk1 for inst1, disk2 for inst2, and disk3 for inst3 but i cant have other instances running on the same SQL networkname.pls help,
Thats normalle ever instance in a cluster has within its own group disks ipadress/networkname and their services
so a 2nd instance will be a new ip and during the installation you assign you re case disk 2 to it
April 17, 2011 at 7:36 am
This documentation seems to be offline. Does anyone can get it online again ?
Thanks
Sven
April 17, 2011 at 9:41 am
Sven Worm (4/17/2011)
This documentation seems to be offline. Does anyone can get it online again ?Thanks
Sven
I have fixed the link for you, right click and download it to hard drive first then open it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply