The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Thursday, April 18, 2024 Login
Public

Installing SQL Server 2005 on a Cluster 9/26/2008 1:57:48 PM

Been a long time since i've had to install and setup SQL Server on a clustered server that wasn't Polyserve.  Suddenly you've got 4 of them to do in one day.  And of course we run into a set of gotcha's...

  1. Logged onto remote node
  2. MSDTC not running as part of a cluster group
  3. Network DTC not installed
  4. Not Enough Disk Space
  5. IRPStackSize too small

1.  Make sure no one else is logged on to the other cluster nodes

2 and 3.  DTC

http://support.microsoft.com/kb/301600

http://support.microsoft.com/kb/817064/

4.  Not Enough Disk Space, this one was frustrating, as the error message is actually caused by the next issue, IRPStackSize:

These is not enough disk space on the destination disk for the current SQL Server data files. To proceed, free up disk space to make room for data files, or install the data files to a different drive.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2953409&SiteID=1 

http://sqlserver-qa.net/blogs/tools/archive/2008/01/04/error-there-is-not-enough-disk-space-on-the-destination-disk-during-a-sql-server-failover-cluster-installation.aspx

5.  IRPStackSize

http://blogs.technet.com/askcore/archive/2008/01/25/irpstacksize-and-clusters.aspx

http://support.microsoft.com/?id=285089

http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/regentry/58629.mspx?mfr=true


Blog Home