Can't uninstall or reinstall nonfunctioning sql server

Hot Topic

~* Printing Report omitting the background colors *~
deploy shared datasources
~* Total Pages mismatch *~
database maintenance plan - reorganize data pages and indexes
Problems with SQL 2005 Export Wizard
Writting to multiple tables
Sql stored procedure call hangs from .net
DCOM Error 10016 Problem with opening http://localhost/reports$sqlExpress
connection problem
@@DBTS correct usage

SQL Server

VBA IsError function in MDX with SQL Server 2005
How Can I automatic create all that Objects in assembly in simple way ??
Date conversion
Distributed Transaction on Windows 2000 Professional
what i forgot
Why is taking so long to open/render the reports for the first time?
Upgrade SQL Express to SQL Server 2005
Moving SQL2000 to SQL2005 - COM+ Transaction Issue
Dynamically Generating SMDL (Report Model Definitions) With C#
Error handling with MDX and Reporting Services

Can't uninstall or reinstall nonfunctioning sql server

In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1

Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message:

Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)

Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listing being removed from Add or Remove Programs. Most of the sql server programs are still installed. They can be run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed.

Is a complete reinstall of windows xp, programs and data the only solution I hate to believe it; but, at this point, I see no other choice.

Answer this question

Can't uninstall or reinstall nonfunctioning sql server

  • pasand

    I also had same problem , Could you give me the SQL 2005 uninstall script My server is x86, Please sent to jeffery_jean@msn.com

  • Marco Dorantes

    Thanks for the info! I sure it will come in handy in the future. Unfortunately, I've already done a complete reinstall of winxp and sql server. Hopefully, it will run better this time.

  • stuntpope

    I also had same problem after using Remote Desktop to install/Uniinstall SQL 2005 , Could you give me the SQL 2005 uninstall script My server is x86, Please sent to andy.seymour@bigroup.co.uk asap please. regards Andy.

  • tatero

    I'm trying to cleanly uninstall SQL Server 2003 (I think) and .NET 1.1. Is there a script for this or uninstall series of steps that need be taken Please advise.

  • Pikechan

    I also have problem with removing SQL Server2005. Using Add/Remove Programs does not remove all files.Now I have problem with reinstalling SQL - <Workstation components, Books on line and Development Tools> stage fails with the message: 'There is a problem with Windows Installer package . A program run as part of the setup did not finish as expected.'
    Can you forward me the script to completely remove all SQL Server files and registry references There is not also a way to uninstall SQL Express.
    My email: jurekba@optusnet.com.au
    It's a pity that Microsoft again did not do its job to deliver working uninstall software for SQL Server 2005.

  • arl_garm

    If your machine is of x86, please email me so I can forward a script to you to clean those unwanted SQL Server 2005 Components. What you can do is as follows.

    1. In Add/Remove Program, remove all visible SQL Server 2005 components.

    2. Run command sc, kill all unwanted SQL Server services such as SQL, OLAP, RS, Agent, ...

    3. Run command regedit, remove all of those registry keys related to those unwanted SQL Server 2005 components. Of course, this operation is time-consuming and error-prone. That is why the script is created.

    4. Reboot your machine and rerun SQL Server 2005 setup.

  • tmasboa

    I'm having a similar problem and would like to get the script please.

    -morten

  • Ntech

    I think microsoft should supply this, since so many people need it! Could you send it to me too I've tried all of the above and it still won't install.

  • Geoffrey Jacoby

    I'm another one that needs the script. I tried using the MS Uninstall cleanup utility but it still didn't work. The SQLServer 2005 install thinks I have several components installed -- most notably the database itself -- and fails when it can't start the database engine. I don wonder why MS couldn't have accounted for this in the original install program. Oh well.
    Thanks
    rchrismon@patmedia.net

  • Big--Ben

    I have same problem at hand, Could you kindly give me the SQL 2005 uninstall script My server is x86, Win XP SP2 Please send to tmp74in at yahoo.com

  • diavo

    this is a problem related to the Windows installer MSI database. It believes that the install is part-finished and gets itself a little screwed up. I'd recommend downloading the Windows Installer CleanUp Utility from here http://support.microsoft.com/default.aspx scid=kb;en-us;290301 and removing the relevant SQL Server database entries.

    Following this retry the install, it should go through fine.

  • Nick752008

    I am running an x86 install that I need to remove can you send me the script to vaparicio@cpisolutions.com
    thx.

  • Kijju

    I also am having the same problem. Please email the script to James@azmiller.com

  • Lesley

    Hi,

    Can you please send me that cleaning script, I'm having the same problem.

    thanks

    Bob
  • Can't uninstall or reinstall nonfunctioning sql server
Answer this question