Re: Error connecting to the Windows Server Update Services database


The cost of reinstalling WSUS is rather small, as you can retain the
database and content, and the uninstall/reinstall process takes less than 30
minutes.

If something has gotten out of kilter, a reinstall should rectify any such
issue.


"gurvinder.nijjar" <gsnijjar@xxxxxxxxxxx> wrote in message
news:%23stmq%23SDGHA.628@xxxxxxxxxxxxxxxxxxxxxxx
> Thnaks for the feedback.
>
> I am not using any host headers, and have been using unassigned Ip
> addresses.
>
> I have checked the registry key and it is set to %computername%\WSUS. So
> everything seems normal.
>
> Are there any ideas.
>
> I have changed the server back to its original name.
>
> Is ir worth reinstalling WSUS again.
> "Lawrence Garvin (MVP)" <onsitech@xxxxxxxxxxxxxx> wrote in message
> news:uMe0pGLDGHA.2320@xxxxxxxxxxxxxxxxxxxxxxx
>> 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: 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)
  • Re: WSUS Disappeared
    ... tried reinstalling WSUS 3 with limited success. ... Ran setup again to install administrative console. ... Console is now there but will not allow me to connect to server. ... These documents applies on reinstalling WSUS on SBS2003 ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS - no longer working
    ... Your WSUS 2.0 does not work after failed upgrade to WSUS 3.0, ... After you recover the server, ... Open Windows Explorer to the hard disk volume that contains the most ... This is the database backup file that was created while installing WSUS ...
    (microsoft.public.windows.server.sbs)
  • Re: =?ISO-8859-15?Q?SUSDB.mdf_=3D_3.3GB?=
    ... When I see a database or logs or anythng wsus related that big I clean ... Check your SBS with the SBS Best Practices Analyzerhttp://blogs.technet..com/sbs/archive/tags/BPA/default.aspx ... The WSUS 3 one presumably:) ... ... Start, ADministrative Tools, Microsoft Windows Server Update Services ...
    (microsoft.public.windows.server.sbs)
  • Reindexing WSUS 3.0 Database
    ... I am in the process of setting up the WSUS server so that I can reindex the ... Here is the basic setup information of my server. ... The WSUS is 3.0 and is running the internal SQL database that was upgraded ... The 2nd question is how long will it take to reindex the database once I ...
    (microsoft.public.windowsupdate)