Solved

Unable to remove SQL 2005 instance

Posted on 2013-01-10
5
326 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
[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
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:Eugene Z
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
NTP problem 24 75
Windows Modify Permissions 19 64
Automate Windows Updates with SCCM 2 83
Change this SQL to get all nodes 3 38
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…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

756 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