Solved

wsus db

Posted on 2009-04-07
2
375 Views
Last Modified: 2013-11-21
Hi.

We recently installed a trial version of mssql 2008. The trial has run out and the sql service has stopped running.

The Problem is our WSUS server db is on that instance and now I can not open the microsoft windows server update service sp1 snap in. I get a connection error.

From event viewer I get: event id 7032

The WSUS administration console was unable to connect to the WSUS Server via the remote API.

Verify that the Update Services service, IIS and SQL are running on the server. If the problem persists, try restarting IIS, SQL, and the Update Services Service.

Please can some help.
I can't see any option on the snap in regarding  settings.
0
Comment
Question by:mattskiver
2 Comments
 
LVL 58

Accepted Solution

by:
tigermatt earned 250 total points
ID: 24089614
Recover the MDF and LDF files from the SQL Server. Uninstall SQL Server, download SQL Server 2008 Express Edition and install that. Then, attempt to mount the recovered database files as a new SQL server database called 'SUSDB'.

If that doesn't work, I'd remove the SUSDB from SQL Server 2008 Express and then uninstall and reinstall WSUS. That will properly recreate and reconfigure the database, and isn't too much work.

-Matt
0
 
LVL 12

Expert Comment

by:NetAdmin2436
ID: 24089678
If you plan on using the product past the trial period, I'd recommend purchasing it :)

Also,  why in the world would you install trial software on a production server?
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now