Problem :

When I Prepare the Test Environment to the SQL Server Clustering  Under Windows Server 2008R2 Clustering I get this issue :

Clutser validation Error

After I Create the Cluster must be make validate the Configuration when I check this Configuration I get this issue Validate Windows Firewall Configuration in the detail of the error An item with the same key has already been added

Reason of the problem :

This is typically because the NIC GUID is duplicated between cluster nodes. When I won’t to create 3 Virtual machine (Cluster-PC , Node 1 , Node 2 )

I Create the First Virtual machine and take it Twice copy this is the issue because when I make Copy the Node 1 and Node 2 Created with the same Physical Address (MAC IP) so the Conflict in this area

the first solution came to my brain it’s I will Format Node 1 and I will install it from the first (Windows) but I Check more time to another Solution and I defected good Solution by Asking my friend System Administrator Eng.Hamada Abdelkader

Solution :

1- open the Run

2- Write this Command (sysprep)

3- Enter

this Command is System preparation it will male  preparation to the network after this Command finish I Check the mac IP very good new Address and I run the Validate Configuration for the Windows Cluster again and it successful 100%

Thanks For Eng.Hamada Abdelkader

Regards,

Eng.Mostafa Elmasry

Database Administrator

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.