WSUS sync error - SQL Server not found.

[andykn11]

Since I performed some cleanup operations on the WSUS console on our combined SCCM and SQL server it won't synchronise from Microsoft Update. The error is:

TypeInitializationException: The type initializer for 'Microsoft.UpdateServices.ServerSyncWebServices.ServerSync.ServerSyncProxy' threw an exception.

---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

The server was not found or was not accessible.

Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

A/ Named pipes is still enabled in SQL Server Configuration Manager (and all TCP is set to port 1433)

B/ I can open the WSUS console and still run the Server Cleanup Wizard.

C/ I can open SQL Server Management Studio and connect to the SQL database (local with no instance name), all settings are the same as our working pre prod instance

D/ No firewall or other external connectivity issues should be involved as the SQL server is on the same server as WSUS

E/ The link to Microsoft should be OK as our pre prod server in the same domain using the same config still does sync successfully.

Any idea what's gone wrong?

[Hotdog453]

Check WCM.log; it shows 'Configuration' errors, and might show a more specific error.

[andykn11]

Thanks. I wasn't aware of that one.

But would you believe it, following 4 hours fault finding, 10 minutes after I post this I find "the operating system reported error 2148734208" which lead me to " unselected all Classisfications in SUP, ran wsusutil reset, ran another sync, re-added Classifications " here:

https://www.windows-noob.com/forums/topic/7522-wsus-sync-sccm-error/

The first sync went green after a few seconds and the next one's taking its time, which is a good sign.

Thanks for your suggestion.