Windows 2008 cluster for SQL server 2005 cluster

Windows 2008 cluster for SQL server 2005 cluster

Post by Roge » Tue, 22 Apr 2008 22:18:31


I am looking for an article that assumes I know nothing about windows 2008
clustering.

I need to get from it exactly what software is required to allow clustering
SQL server 2005 under windows 2008, what network topologies are required,
and at least a brief explanation of how it is set up so that I can figure
out if we should attempt it in house.

Can anyone point me to this?

Thanks.

Google has THOUSANDS of hits, but all seem to start by being built on other
articles that are built on articles ad infinitum.
 
 
 

Windows 2008 cluster for SQL server 2005 cluster

Post by Meinolf We » Tue, 22 Apr 2008 22:31:32

Hello Roger,

Detailed install for 2008:
https://www.microsoft.com/downloads/details.aspx?FamilyID=518d870c-fa3e-4f6a-97f5-acaf31de6dce&displaylang=en

SQL 2005:
http://www.yqcomputer.com/

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.yqcomputer.com/

 
 
 

Windows 2008 cluster for SQL server 2005 cluster

Post by cHJlY2VkZW » Thu, 22 May 2008 13:46:01

Hi Roger,

To enable SQL clustering you basically need an enterprise or datacenter
version of Windows Server for each instance of SQL that you are running. With
Hyper-V Technology now alive and well, you may want to consider going with a
SQL appliance (using an embedded version of Windows Server and SQL) that runs
both instances of SQL server on the same powerful piece of hardware. You'll
get better pricing on the Windows licenses going embedded. I'm a Microsoft
embedded OEM and I can design a solution for you if you're interested in an
embedded OS solution.