Solved

Unable to remove SQL 2005 instance

Posted on 2013-01-10
5
244 Views
Last Modified: 2015-06-23
I've got an issue with an SQL Server 2005 instance refusing to be removed. I've tried using the control panel and the instructions found in KB 909967 to remove the instance with no success. Event Viewer shows the following information from the setup:

Log Name:      Application
Source:        MsiInstaller
Date:          1/10/2013 12:26:47 PM
Event ID:      10005
Task Category: None
Level:         Error
Keywords:      Classic
User:          Domain\administrator
Computer:      Server1.Domain.local
Description:
Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MsiInstaller" />
    <EventID Qualifiers="0">10005</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-01-10T19:26:47.000000000Z" />
    <EventRecordID>3960</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Server1.Domain.local</Computer>
    <Security UserID="S-1-5-21-3855484283-3340634759-1625163775-500" />
  </System>
  <EventData>
    <Data>Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
</Data>
    <Data>(NULL)</Data>
    <Data>(NULL)</Data>
    <Data>(NULL)</Data>
    <Data>(NULL)</Data>
    <Data>(NULL)</Data>
    <Data>
    </Data>
    <Binary>7B32414646464444372D454438352D344139302D384335322D3544413945424443394238467D</Binary>
  </EventData>
</Event>

Attached is a setup log grabbed from the failed uninstall process.

This existing instance is from a previous installation of Kaspersky Security Center which was removed from the system and is now preventing the re-installation. I've contacted Kaspersky, who directed me to contact MS since the problem appears to be with MS SQL. Still waiting on MS Support. Thanks for any help / advice.
SQLSetup0016-SQL.log
0
Comment
Question by:shg_itdept
5 Comments
 
LVL 20

Expert Comment

by:Marten Rune
Comment Utility
follow the steps from Microsoft to manually remove the instance.
This link is the starting point.
http://support.microsoft.com/kb/909967

Regards Marten
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
additionally to above post solution, please check

How to clean up a SQL 2005 instance name left behind by a previous uninstall
http://blogs.msdn.com/b/astebner/archive/2005/12/08/501885.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/51028a2a-ba73-4488-908d-cfee44624aa4/
0
 

Accepted Solution

by:
shg_itdept earned 0 total points
Comment Utility
Tried both avenues, with no success. SQL still sees the existing instance of the database. I ended up creating a new instance and using that for the installation of Security Center. Thanks for the suggestions.
0
 
LVL 34

Expert Comment

by:Seth Simmons
Comment Utility
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

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!

Join & Write a Comment

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

763 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