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’ ]
File Size : 26.2 MB
Video Size: 800 x 600
Duration : 29:31 min
Issues Faced:
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.
Resolution:
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.
Leave a Reply