Installing SQL Server 2008 Clustering on Windows Server 2008

In this webcast we are going to install SQL Server 2008 Clustering on Windows server 2008. Ive already made my both the nodes clustered with Windows server 2008 and the details are below.

Below are the list of SQL Server 2008 editions supporting clustering.

  • SQL Server 2008 Enterprise Edition (16-node failover clustering)
  • SQL Server 2008 Standard Edition (2-node failover clustering)
  • SQL Server 2008 Developer Edition
Node Name
Node1 & Node2
Domain Name
sagar.com
OS
Windows Server 2008 Enterprise Edition
SQL Server
SQL Server 2008 Enterprise Edition

[mediaplayer src=’http://www.sql-articles.com/Old_website/articles/SQL2008/sql2008-cluster.wmv’ ]

Download the Video

File Size : 26.2 MB
Video Size: 800 x 600
Duration : 29:31 min

Problem : While adding node 2 to SQL Cluster, Ive executed the SQL Server 2008 setup on node 1 but it gives the below error.

    The current SKU is invalid.

Upon searching in internet I found a issue link in Microsoft connect for this, you can check it here http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036.

Below are the list of workarounds to use to avoid this problem

Run SQL Server 2008 setup on Node 2 and add that node to SQL Cluster. (Ive tried this and worked as charm)

Copy SQL Server 2008 setup to local disk and open DefaultSetup.ini file, copy the product key to some other file and remove the product key from the file. Now run the setup in Node 1 and enter the product key manually when asked in setup wizard.

Microsoft has a Knowledge base article for this. This has been rectified in SP1, hence install SP1 before installing SQL Server 2008, this will update the setup support files. Check http://support.microsoft.com/kb/957459 for more.


Posted

in

by

Comments

3 responses to “Installing SQL Server 2008 Clustering on Windows Server 2008”

  1. Dinesh Poojary avatar
    Dinesh Poojary

    Do we need separate IP and storage drive for MSDTC services in SQL 2008?

    1. VidhyaSagar avatar
      VidhyaSagar

      @Dinesh — You can check my video for this, it has info http://sql-articles.com/articles/high-availability/installing-msdtc-as-cluster-aware-service/
      If you require more info in DTC service check MSDN blog it has all scenarios and requirements – http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx

  2. satish avatar
    satish

    the info is very usful

Leave a Reply

Your email address will not be published. Required fields are marked *