Re: Error connecting to the Windows Server Update Services database

The SQLAgent$WSUS service should not be running on an (W)MSDE installation.
It /might/ be running on an SQL Server 2000 named instance installation if
you have used the Database Maintenance utilities to configure scheduled
maintenance or scheduled backups of the WSUS named instance.

Changing the server name and/or IP Address should not interfere with normal
WSUS operations, unless you have also configured IIS to use Host Headers
and/or specified IP Addresses, in which case they might not be able to
respond to the new name. If there are no host headers configured, and "All
Unassigned" is configured, then IIS should respond to any HTTP GET request
sent to the machine, regardless of the name resolution used to obtain the IP
Address.

However, there is also a registry key that identifies the location of the
database server. The key is located at:

HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup\



and it should contain a value "SQLServerName" with data pointing to your
WSUS instance. If this key has the actual name (or original name) of the
server (rather than (local) or localhost), this would account for the
inability to find the database server after renaming the WSUS server.

My default instance on SBS2003 is set to %computername%, so it's also
possible that an installation on a named instance would be
%computername%\WSUS (I don't have a named instance available to verify
against.) This could also be an issue if the environment variable
%computername% did not get properly redefined after changing the name of the
server.

"gurvinder.nijjar" <gsnijjar@xxxxxxxxxxx> wrote in message
news:eDnquNGDGHA.2320@xxxxxxxxxxxxxxxxxxxxxxx
> Every time I connect to the WSUS admin console I get the following error
> message:
>
> Error connecting to the Windows Server Update Services database
> There was an error connecting to the Windows Server Update Services
> database. Either the database is not available or you do not have the
> correct privileges to access the database.
>
> If you believe you have received this message in error, please check with
> your system administrator.
>
> In event viewer I also get an error log with event id: 421.
>
> The only thing i did on my server was change the server name and IP of the
> server. I have changed the server back to its original server name and IP
> address.
>
> I have checked the services the Background intelligent service is running.
> The SQLAgent$WSUS service is not running. Should this be running.
>
> Is there anything else I can check.
>
>
>


.

Relevant Pages

  • Re: Error connecting to the Windows Server Update Services database
    ... The cost of reinstalling WSUS is rather small, ... database and content, and the uninstall/reinstall process takes less than 30 ... > I have changed the server back to its original name. ...
    (microsoft.public.win2000.windows_update)
  • Re: WSUS Errors after System state restored
    ... You didn't mention what version of WSUS you are running but my first thought is to download v3 SP1 and run the installer. ... It should uninstall the old version, stopping the appropriate services and removing the database, and you can get a nice upgrade from there as well. ... recover sufficiently and the server went off whilst running. ... see Help and Support Center at ...
    (microsoft.public.windows.server.sbs)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
Loading