June 9, 2010 at 2:00 pm
Hello Everyone
Does anyone have documentation or a good site that can help with a step by step list for setting up a Cluster environment on a Windows 2008 box, running SQL 2008?
Any type of docs would be most helpful. I am reading thru the SQL BOL, but they are not the best, it seems to me. I would like to have something a little more robust.
Thanks
Andrew SQLDBA
June 9, 2010 at 3:06 pm
If the BOL isn't helping, try this
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 9, 2010 at 3:13 pm
Thanks Grant
But not really what I am after.
Thanks
Andrew
June 10, 2010 at 4:02 am
Technet has a really good whitepaper called:
Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services
Writers: Allan Hirt (Avanade, Inc.) and Dave Whitney (Microsoft)
2008 Clustering is basically the same and this guide should get you there.
Cant find the link but the actual filename is SQLServer2005FOC.doc
I have the file and can email a compressed version if you want to PM me.
Hope this helps.
MCITP SQL 2005, MCSA SQL 2012
June 10, 2010 at 4:24 am
here is the link 😉
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 10, 2010 at 6:13 am
Allen is pretty much "the guy" when it comes to this stuff. Sorry the book wasn't helpful, but track down anything he writes. Some of it has to help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2010 at 7:59 am
Hey Just went through this myself.
Here is the best thing I found on the net
http://www.mssqltips.com/tip.asp?tip=1687
I made my own step by step guide, but this was the foundation.
I read the white paper on Windows 2008 Clustering
*****Some things to keep in mind!
If your running Windows 2008 R2 I and some others have run into certian issues with a Kerberos error on installation. I think it is because of some of the settings
http://support.microsoft.com/kb/955725/EN-US
To work around this error I had to install SQL using the slipstream install out lined here by Perter Saddow
Also make sure you have Debug programs rights and Manage auditing and security log rights from group policy
To check:
Click Start| Run | type GPEDIT.MSC
Click OK
Click Computer Configuration | Windows Settings | Local Policies | User Rights Assignment
Check the Debug programs rights and Manage auditing and security log groups and make sure your Administrators local group or your user account have access or the install could fail
The clustering white paper should help you find out what type of cluster to create.
it used to just be Disk or Majority Node Set
Now it is
No Majority - Disk Only (just like the old Disk only)
Node Majority (just like old majority node set)
Node and Disk Majority (new and the recommended option)
Node and File Share Majority (for file servers not really for SQL)
I made my own build guide, unfortunately the 70-432 book still used windows 2003 (2008 wasn't available when it was being written)
Best of luck on the install!
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply