cannot start the windows internal database

hi,

strange thing happened a few weeks back

specs of server

windows 2003 se sp2 domain controller
wsus 3.0 not wsus 3.0 sp1

cannot start the windows internal database service

network service is logon account for update services and windows internal database service.

vent Type: Error
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (2)
Event ID: 17207
Date: 3/26/2009
Time: 1:00:13 PM
User: N/A
Computer: FILESERVER2
Description:
FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 43 00 00 10 00 00 00 7C......
0008: 1c 00 00 00 46 00 49 00 ....F.I.
0010: 4c 00 45 00 53 00 45 00 L.E.S.E.
0018: 52 00 56 00 45 00 52 00 R.V.E.R.
0020: 32 00 5c 00 4d 00 49 00 2.\.M.I.
0028: 43 00 52 00 4f 00 53 00 C.R.O.S.
0030: 4f 00 46 00 54 00 23 00 O.F.T.#.
0038: 23 00 53 00 53 00 45 00 #.S.S.E.
0040: 45 00 00 00 00 00 00 00 E.......

any ideas? cannot upgrade to wsus 3.0 sp1 either

2009-03-26 13:17:58 Success MWUSSetup Validating pre-requisites...
2009-03-26 13:23:23 Error MWUSSetup CSetupDriver::LaunchSetup: Setup is cancelled or an error occurred (Error 0x80070642: User cancelled installation.)
2009-03-26 13:23:23 Success MWUSSetup User cancelled the setup
2009-03-26 13:23:24 Error MWUSSetup DoInstall: Wsus setup failed (Error 0x80070642: User cancelled installation.)
2009-03-26 13:43:22 Success MWUSSetup Validating pre-requisites...
2009-03-26 13:43:37 Error MWUSSetup CSqlConnection::Open: Failed to open SQL connection to instance FILESERVER2\MICROSOFT##SSEE (Error 0x80004005: Unspecified error)
2009-03-26 13:43:37 Error MWUSSetup CUpgradeDriver::PerformPreSetupActions: Failed to open connection to SQL instance %computername%\MICROSOFT##SSEE (Error 0x80004005: Unspecified error)
2009-03-26 13:43:37 Error MWUSSetup CSetupDriver::LaunchSetup: Failed to perform pre-setup actions (Error 0x80004005: Unspecified error)
2009-03-26 13:43:37 Error MWUSSetup CProgressManager::EnableCancel: GetDlgItem returning error (Error 0x80070578: Invalid window handle.)
2009-03-26 13:43:51 Error MWUSSetup DoInstall: Wsus setup failed (Error 0x80004005: Unspecified error)

further info. i am unsure if this wsus 3.0 was installed and then dcpromod to a dc. would that cause this? oi do know that server is a dc. wating to hear back from the tech when wsus was installed. should i just remove it and reinstall it or will i need to remove iis first then reinstall iis then uninstall wsus and reinstall.

thanks for the reply.

if i understand you correct all i need to do is uninstall wid and not IIS.

To uninstall Windows Internal Database
1. Open a command shell.
2. Call msiexec with the correct key for the operating system platform.
• On 32-bit platforms: msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe
• On 64-bit platforms: msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe
Important
The removal of the application may not remove the default .mdb and .ldb files, which will cause a subsequent WSUS 3.0 installation to fail. These files can be deleted from the %windir%\SYSMSI\SSEE directory.

Correct? do i also need to uninstall wsus 3.0 from add and remove programs and check the boxes it gives you as items to additionally uninstall.

Yes. In fact, you should uninstall WSUS 3.0 before performing the W.I.D.
uninstallation

wsus 3.0 sp1 rather.

was able to uninstall wsus 3.0 using reg key set to 0 from 1 for uninstall but cannot uninstall windows internal database

error i get is

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 3/27/2009
Time: 6:42:42 PM
User: VCS\vcadmin
Computer: FILESERVER2
Description:
Product: Windows Internal Database -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 43 45 42 35 37 38 30 {CEB5780
0008: 46 2d 31 41 37 30 2d 34 F-1A70-4
0010: 34 41 39 2d 38 35 30 46 4A9-850F
0018: 2d 44 45 36 43 34 46 36 -DE6C4F6
0020: 41 41 38 46 42 7d AA8FB}

cannot of course install wsus 3.0 either

using command line to remove says fatal installation
windows internal database service still shows in services and is not started and cant be.

have not uninstalled iis

any thoughts?

i can start the service wid now.

i still cannot remove wid.

cant install wsus 3.0 either.

fails at setting internal settings for wid.

is there a solution to this? or should i just bail on this dc.

This has resolved my issue. wsus 3.0 installed and wid ok.





Try this from RegEdit:

1) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
Edit the "InstalledInstances" value and remove "MICROSOFT##SSEE"

2) Remove the "MICROSOFT##SSEE" subkey under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

3) Remove the "MSSQL.2005" subkey under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

4) Rename the following folder:
\%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data to \%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data.old


thanks for your help/