Problem :
When I Prepare the Test Environment to the SQL Server Clustering Under Windows Server 2008R2 Clustering I get this issue :
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