SCCM2012 Software update (WSUS patch) synchronization successfully failed to get patch issues

Using SCCM2012 to manage WSUS patch distribution, after you install WSUS4.0, add site system roles (software update point), synchronize Software update operations, open the WSUS console to see the synchronization process, open SCCM "All software Updates" After synchronization succeeds, and display "No items found." Indicates that the patch information was not imported into SCCM.

View monitoring-Component status, find Sms_wsus_sync_manager with error warning, view cm server log file C:\Program Files\Microsoft Configuration Manager\logs\ Wsyncmgr.log, report the following error:

Unknown SQL error! $$<sms_wsus_sync_manager><03-06-2015 02:11:11.449-480><thread=4036 (0xFC4) >

Failed to sync update 57a02ff3-31b4-4be8-bcee-33d74eba9a18. error:failed to save update ac675cdd-70e8-447f-8fbd-3fa0225a3ca5. Ccisource Error:-1.

Online query solutions and databases, the solution is as follows:

1. Check the database ownership in SQL Management Studio using the query:

Exec sp_helpdb

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5A/2F/wKioL1T5S1ehFLmUAAIXE8YgufU243.jpg "title=" Screenshot1.jpg "alt=" Wkiol1t5s1ehflmuaaixe8ygufu243.jpg "/>

2. Changed the database ownership back to ' sa ' using the query:

Use [sccm_db] GO EXEC sp_changedbowner ' sa '

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5A/2F/wKioL1T5S26z7y8gAAIpsP2GNOM352.jpg "title=" 2.jpg " alt= "Wkiol1t5s26z7y8gaaipsp2gnom352.jpg"/>

3. Check the Trustworthy property on the SCCM database. Right click on SCCM database,select options and look for trustworthy property in the list of options

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5A/33/wKiom1T5SmyyrVITAAH0R-G-fxE069.jpg "title=" 3.jpg " alt= "Wkiom1t5smyyrvitaah0r-g-fxe069.jpg"/>

4. Change the Trustworthy property on the SCCM database using the SQL query:

ALTER DATABASE [sccm_db] SET trustworthy on

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5A/33/wKiom1T5SufSvQX4AAHwT8-YsCo097.jpg "title=" 4.jpg " alt= "Wkiom1t5sufsvqx4aahwt8-ysco097.jpg"/>

Once the modifications are complete, resynchronize the software updates to see the WSUS patches on all software updates. The first import time will be a bit long.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5A/34/wKiom1T5TnChqpB7AAOLgnxbJi0311.jpg "title=" Screenshot2608.jpg "alt=" Wkiom1t5tnchqpb7aaolgnxbji0311.jpg "/>

PS: It is important to note that by default, WSUS's remote database SUSDB will be generated under the C-drive default path, which can be detached and copied to the other disk and attached. WSUS does not need to be configured after the installation is complete and is configured when the software update point is added to CM.

Reference: https://tjmklaver.wordpress.com/2012/06/19/sccm-2012-software-update-synchronization-fails-with-unknown-sql-errors/

SCCM2012 Software update (WSUS patch) synchronization successfully failed to get patch issues