System Center Updates Publisher - Import Software Updates Catalog Wizard

AndrewLeg
AndrewLeg used Ask the Experts™
on
Hi,

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 ?

Thanks,
Comment
Watch Question

Do more with

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

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

Author

Commented:
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:

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

CAUSE
                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


RESOLUTION
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