February 8, 2008 at 8:22 am
Hi All,
Please provide me the pre-requisites for installing the SQL Server 2005 Cluster. And also please provide me the steps for installing a SQL Server 2005 on Windows Server 2003.
If any body responding regarding this, it would be great helpful to me.
Thanks in Advance.
February 8, 2008 at 11:48 am
The forum is not really a good place to deliver this information. Books are written on the topic you're concerned about. I suggest you look through the Microsoft KBs. This whitepaper is a good start:
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
February 11, 2008 at 10:10 am
The basic thing you need is to have 2 identical nodes for cluster and make them as cluster by installing cluster services in Windows Server 2003. And then you have to install SQL Server on top of that to make it Virtual SQL Server. But before this you need to have IP addresses and virtual names handy and you have to take decision whether you need the MSDTC as a seperate service or runs as part of SQL Server group and the same thing applies to SSIS. Search Forums you will get better idea on this.
Thanks-Mubeen
February 11, 2008 at 1:57 pm
It's all in BOL but is a bit spread out. When I did my one, I started by copying & pasting stuff out of the various BOL pages into a Word document so I didn't have to keep jumping around. Then started planning out things like service accounts required and did a few test runs to tie up any loose ends.
Our server team built the Windows cluster, so I don't really know much about getting that going, although it looks simple enough (assuming the SAN drives have already been setup and presented to Windows - I know nothing about that). I know they didn't use cluster-certified hardware to do it. The only issues we have had was a driver conflict after Windows 2003 SP1 was applied (fixed by a new driver from the vendor). That caused a BSOD on the active node once a week until fixed.
I've attached the Word doco I started with - nothing in it that isn't in BOL, just a bit better flow with regards to pre-requisites and process flow.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
September 6, 2012 at 1:03 pm
Neither Microsoft nor IBM gives strait forward answers in their documents. If you have what the requester have asked, please be kind and give it to the requester. I'm certain he/she had done his/her homework before coming to the forum. Thanks.
September 6, 2012 at 1:29 pm
Please note: 4 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply