Solved

Windows Internal database error on Windows 2008 R2

Posted on 2011-02-25
22
3,511 Views
Last Modified: 2012-05-11
Hi,

I have an issue on one of my wsus server (running on Windows 2008 R2).

It all started when the "Windows Internal Database Service Pack 4 for x64 Edition (KB2463332)" update refused to install on this specific server (no problems on my other servers).

So, I decided to remove wsus and Windows Internal database and then reinstall.

WSUS uninstalled correctly (no errors) but I am unable to uninstall the Windows Internal Database through the remove features in Server Manager.

I am getting an error "Windows Internal Database Removal failed 0x80070643" and some error to some msi.log located in c:\users\administrator\appdata\local\...\msi.log.

I wish I could uninstall the Internal database, and then reinstall it, update it with the patch above and then reinstall wsus.

Can anyone help?

Thanks.
0
Comment
Question by:benjilafouine
  • 13
  • 7
22 Comments
 
LVL 1

Author Comment

by:benjilafouine
ID: 34984768
Seems like I found it by myself...

http://support.microsoft.com/kb/919945

It worked. I decided not to reinstall wsus on that server.

Benji.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 34985958
FYI, you can manually remove the Windows Internal Database thru command line


http://technet.microsoft.com/en-us/library/cc708610%28WS.10%29.aspx


# 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
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35010848
Seems like my issue is not resolved...

I have a second machine that exhbits the same problem: the update won't install and in this case, I do not have the luxury to uninstall it because I believe Windows Internal database is used by my Trend Micro Antivirus console (Worry Free).

So update Windows Internal Database Service Pack 4 for x64 Edition (KB2463332) will not install. Anyone has a clue how to solve it without destroying it?

Thanks.

Benji
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 47

Accepted Solution

by:
Donald Stewart earned 500 total points
ID: 35011058
Looks like "Worry free" is not one of the products mentioned that use MSDE(Windows Internal Database)



 http://us.trendmicro.com/us/products/enterprise/outbreak-prevention-services/system-requirements/
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35011109
Databases—any of the following:
Microsoft Data Engine (MSDE) 1.0 / 2000 (2000 + Service Pack 3 is recommended), Microsoft SQL Server 7.0, Microsoft SQL Server 2000 (2000 + Service Pack 3 is recommended)
Others—SQL ODBC driver 3.7 or higher
Windows Installer (included in Control Manager package)

I see MSDE here or SQL server. I am pretty sure it is being used because there is nothing else in this server that could possibly use Windows Interna Database. This is why I want to solve this update error.
0
 
LVL 47

Assisted Solution

by:Donald Stewart
Donald Stewart earned 500 total points
ID: 35011585
Products Supported

Requires installation of one of the following Trend Micro
products. Gateway: InterScan™ eManager™, InterScan
Web Protect™ for ICAP, InterScan™ Messaging Security
Suite for Windows/Unix, InterScan Web Security Suite for
Windows/Solaris, Trend Micro™ Network VirusWall™. Mail:
ScanMail™ for Exchange, ScanMail for Lotus Notes,
ScanMail for eManager. Desktop: Server Protect™ for
Windows, OfficeScan™

"Worry free" is not one of the products mentioned



0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35215468
I prefer not to uninstall the database because I don't know exactly why it is there in the first place. I am going to turn off the service and see what happens.

0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 35215521
"I prefer not to uninstall the database because I don't know exactly why it is there in the first place."


Windows internal database is installed by a default install of WSUS
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35215546
This server has been up for a long time and wsus is definitely not there anymore. Windows Internal Database may just be a leftover. I stopped it and it did not affect my antivirus console.

I may just uninstall it (this I know how).
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 35215618
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35215660
Actually, a simple registry modification enables removal. It has something to do with the database being installed while the machine had a different role (such as a DC).
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 35215742
And what registry modification would that be ?
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35215771
See my link above.

To work around this problem, follow these steps:
Start Registry Editor, and then locate one of the following registry subkeys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2005\Setup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup


Note Only one of these registry subkeys will exist on your computer.
Empty the following registry entries:
SQLGroup
FTSGroup
AGTGroup
Exit Registry Editor.


I did that and was able to uninstall it normally on another server with the same problem.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 35215839
Ok, the msiexec /x would have worked as well :)


Did you get your WSUS up and running on a different server ?

0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35220132
I have a few wsus servers across different sites and along the months/years, servers have changed. Probably that it was in this server many months ago. Not sure.

I installed several wsus servers and linked to the master but because of sync issues, I reverted them to independent ones.
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35407555
Its not abandoned, just not completed...
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35413166
Its not abandoned, just not completed...
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35758846
Still not completed. Do not delete.
0
 
LVL 1

Author Comment

by:benjilafouine
ID: 35760592
Finally took the time to clear up this situation.

In the end, Windows Internal Database was not required anymore on that machine. I removed the registry keys above, uninstall Windows Internal Database, rebooted and tested my Trend Micro application. Result: no issues.

I do not recall why Internal Database was installed in the first place (WSUS?) but for sure it was not needed anymore.

Problem solved.
0
 
LVL 1

Author Closing Comment

by:benjilafouine
ID: 35760604
The registry keys must be deleted in the registry if you are sure you want to removed the product. Most likely, it was install under a different user or while the computer was a domain controller (which it is not anymore).
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

828 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