Unable to Uninstall SQL Server 2005 Instance

  • Hi,

    We have 3 instances in SQL Server 2005. We are not using 2 instances and Iam trying to uninstall them.

    But Iam getting the below error. Please advise me ..what will be the reason for this?

    What should I do to uninstall these 2 instances?

    === Verbose logging started: 6/2/2009 13:11:37 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===

    MSI (c) (A4:B8) [13:11:37:746]: Resetting cached policy values

    MSI (c) (A4:B8) [13:11:37:746]: Machine policy value 'Debug' is 0

    MSI (c) (A4:B8) [13:11:37:746]: ******* RunEngine:

    ******* Product: {481DFF26-7C67-4085-9A27-758283EA494A}

    ******* Action:

    ******* CommandLine: **********

    MSI (c) (A4:B8) [13:11:37:746]: Client-side and UI is none or basic: Running entire install on the server.

    MSI (c) (A4:B8) [13:11:40:746]: Failed to grab execution mutex. System error 258.

    MSI (c) (A4:B8) [13:11:40:761]: Cloaking enabled.

    MSI (c) (A4:B8) [13:11:40:761]: Attempting to enable all disabled priveleges before calling Install on Server

    MSI (c) (A4:B8) [13:11:40:777]: Incrementing counter to disable shutdown. Counter after increment: 0

    MSI (c) (A4:B8) [13:11:40:777]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1

    MSI (c) (A4:B8) [13:11:40:777]: MainEngineThread is returning 1618

    === Verbose logging stopped: 6/2/2009 13:11:40 ===

  • R u trying to uninstall your SQL instance by running your .exe file by running set up through SQL 2005 CD or uninstalling by going to ADD/Remove programs in ur control panel? I usually try first method I had mentioned if that doesnt works then the second method.

  • Iam uninstalling from Add/Remove programs

  • Go to-->control panel-->add remove programs-->selct sqlserver-->click Remove button--->select inst3 d'nt select below servieces(aware services like integration services ,sql browser,notification services)

  • Try the first method then, uninstalling by running ur SQL C.D or exe file

  • try the first method then, uninstalling by running ur SQL C.D or exe file

    could you please explain me how uninstall from .exe???

  • Do u have your SQL 2005 C.D with you which u had initially used to install SQL server on your machine?

  • First time when I installed sql server,I had copied installatio files from the CD and then installed.

    Now, I have the copied installation files on the local drive.

  • I dont remember the whole path of the file, if u have a dump of SQL.

    But u can do search on that folder for file, setup.exe

    (I think u can use .ini file to run the installation/uninstallation too)

    Double click on it, and run the process.

  • If I click setup.exe from the installation files, the installation wizard is coming up but not the uninstallation wizard.

    I have the sql software in 2 folder;

    1)Servers ->this is the place you saying to click the setup.exe????

    2)Tools

    please clarify from which path I need to invoke setup.exe to uninstall sql server??

  • Try using the arpwrapper from the command line.

    "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"

    Refer: http://support.microsoft.com/kb/909967

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • rambilla4 (6/11/2009)


    If I click setup.exe from the installation files, the installation wizard is coming up but not the uninstallation wizard.

    I have the sql software in 2 folder;

    1)Servers ->this is the place you saying to click the setup.exe????

    2)Tools

    please clarify from which path I need to invoke setup.exe to uninstall sql server??

    There is no uninstallation wizard, in Instalation wizard if u move further steps 'next', wizard will sense that you allready have three installations installed and it will ask you later on that which instance do you want to uninstall through the same wizard. Then carefuly choose ur named instances to uninstall. Go slowly reading directions in each step before you click Next.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply