Solved

Windows Internal database error on Windows 2008 R2

Posted on 2011-02-25
22
3,394 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
Comment Utility
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:dstewartjr
Comment Utility
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
Comment Utility
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
 
LVL 47

Accepted Solution

by:
dstewartjr earned 500 total points
Comment Utility
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
Comment Utility
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:dstewartjr
dstewartjr earned 500 total points
Comment Utility
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
Comment Utility
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:dstewartjr
Comment Utility
"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
Comment Utility
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:dstewartjr
Comment Utility
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:benjilafouine
Comment Utility
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:dstewartjr
Comment Utility
And what registry modification would that be ?
0
 
LVL 1

Author Comment

by:benjilafouine
Comment Utility
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:dstewartjr
Comment Utility
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
Comment Utility
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
Comment Utility
Its not abandoned, just not completed...
0
 
LVL 1

Author Comment

by:benjilafouine
Comment Utility
Its not abandoned, just not completed...
0
 
LVL 1

Author Comment

by:benjilafouine
Comment Utility
Still not completed. Do not delete.
0
 
LVL 1

Author Comment

by:benjilafouine
Comment Utility
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
Comment Utility
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

Promote certifications in your email signature

Has your company recently won an award or achieved a certification? They'll no doubt want to show it off. Email signature images used to promote certifications & awards can instantly establish credibility with a recipient and provide you with numerous benefits.

Join & Write a Comment

Recently, I was asked to look into SCCM 2007 by my employer, having a degree of experience of earlier versions of SMS and some previous SCCM knowledge I didn't expect the procedure to involve to much time. I read a number of guides concerning it…
Normally after a failure of Domain Controller, when promoting new DC the DC is renamed, we will discuss the options in Dcpromo to re-create the DC with the same name. Scenario: You are a small IT shop with two Domain Controllers (Domain Contr…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

771 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

11 Experts available now in Live!

Get 1:1 Help Now