what happens when you initiate the client install from console ..right click on the machine and choose client install.if you still get same error,try to assign or choose different site ,that will mostly solve the problem.but for sure,there will be record in the database that conflicts other computer resourceID or machineID.
RegardsEswar Koneti www.eskonr.com From: [email protected] To: [email protected] Subject: RE: [mssms] sql error Date: Wed, 19 Nov 2014 06:38:35 +0000 Hello Eswar Thank you for your response. But this query select * from dbo.ClientPushMachine_G where machineID='33555616' doesn’t have a result. There is no machineID='33555616' found. I also tried to run this query on all my primaries and cas. From: [email protected] [mailto:[email protected]] On Behalf Of Eswar Koneti Sent: Wednesday, November 19, 2014 1:45 PM To: [email protected] Subject: RE: [mssms] sql error i come across this error few months ago while doing client push on bulk number of computers and it fail at one computer because of duplicate key and then it stops continuing. The below error basically tells you that,there is already an entry exist in database (dbo.ClientPushMachine_G) with resoureID (33555616) with different computer name and cannot update or do anything with new computer. more info,can get from smsprov.log on the site server. If you try select * from dbo.ClientPushMachine_G where machineID='33555616' from SQL management studio,you will get a computer name which is different than what you are trying to push. you cannot do client push until you correct the MachineID/ResourceID for the existing machine . What i did was,delete the record from Database with this machineID and try client push,it worked.--only for client push installation. if you try with other client installation methods,you will not have problems. Regards Eswar Koneti www.eskonr.com From: [email protected] To: [email protected] Subject: [mssms] sql error Date: Wed, 19 Nov 2014 01:38:52 +0000 Hello , Anyone has a solution or encountered the same problem as below? The automatic client push is failing. Microsoft SQL Server reported SQL message 2627, severity 14: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint 'ClientPushMachine_G_AK'. Cannot insert duplicate key in object 'dbo.ClientPushMachine_G'. The duplicate key value is (33555616). : sp_CP_CheckNewAssign Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.
