Solved

Windows Internal database error on Windows 2008 R2

Posted on 2011-02-25
22
3,664 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
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…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

751 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