System Center Updates Publisher - Import Software Updates Catalog Wizard

AndrewLeg used Ask the Experts™

I've now completed the install of SCUP.

I'm now trying to Import Updates, but when i try a Bulk Catalog Import, i get the error message ' Unable to connect to the database. Please check service of the database else contact your system administrator '.

If i go to Settings in SCUP, and under the Update Server tab select Test connection (Connect to a local update server), i get Test connection succeeded.

Again whilst in Settings, if i go to the Data Source tab, and select Test connection, i get Test connection succeeded (The data source server is a remote server). The current Connection Details under the Data Source tab correctly identifies the server and database.

The updates i'm trying to import are from Dell, i added the catalog files through - Settings - Import List - Find - Added both Dell External Catalogs.

I'm logged onto the server with an account that's an Administrator (on that server and the database server).

Any thoughts why i could be getting this error message ?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2009
Top Expert 2010

Are yu using System Centre Configuration Manager? If not you won't be able to use SCUP.  


Yes, the SCUP is just an addition to our SCCM
I called our Microsoft Premier Support and they were able to fix the issue.

Below is the summary given by the Microsoft Engineer for the issue and fix:

When trying to import a catalog in updates publisher the error message occurs- Unable to connect to database.

                SQL Server was generating the error
Msg 8144, Level 16, State 2, Procedure usp_ins_updateProperty, Line 0
Procedure or function usp_ins_updateProperty has too many arguments specified.
The CreateDBFile.sql used was for a different version

Uninstalled the SCUP from the SCCM Server
Dropped the Database, deleted the Database Files
Recreated the database, reinstall the SCUP , the sync was running file.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial