Solved

Unable to remove SQL 2005 instance

Posted on 2013-01-10
5
308 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
ID: 38766632
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
ID: 38767442
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
ID: 38779297
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
ID: 40845592
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
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…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

829 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