Installing SQL Server 2008 Clustering on Windows Server 2008

Written by VidhyaSagar. Posted in High Availability

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

Download the Video

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.

VN:F [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)
Installing SQL Server 2008 Clustering on Windows Server 2008, 5.0 out of 5 based on 1 rating

Tags: , ,

Trackback from your site.

Comments (3)

Leave a comment

CAPTCHA Image
*

Recent Comments

Amit Bhatt

|

Hi Deepak,

Thanks for such a nice article.

You missed one thing to add in code:
@article = ‘all’,

Hence the script will be like this:
EXEC sp_addsubscription
@publication = ‘mypublication’,
@article = ‘ALL’,
@subscriber = ‘Subscriberservername’,
@destination_db = ‘mydestinationdbname’,
@reserved=’Internal’

Error 18486 | Platformblog

|

[...] SQL-Articles » Troubleshooting Login failed Error 18456This is one of the infamous error message (and number) that most of the DBAs …. 18486. Login failed for user ‘%.*ls’ because the account is currently locked out. [...]

VidhyaSagar

|

Naveen,
I’ll check this out and get back to you.

balakiran

|

Thanks man, Very simple & easy to understand !!!!

Rating