?
Solved

Unable to remove SQL 2005 instance

Posted on 2013-01-10
5
Medium Priority
?
400 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 43

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 35

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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

752 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