July 23, 2008 at 7:59 am
I have Windows XP Pro w/SP-2, and SQL Server 2005 Developer Edition.
In Add/Remove Programs control panel, for SQL Server 2005 option I clicked Remove button which brought up a dialog box for removing SQL Server 2005... I clicked Cancel which exited the removal process, but the SQL Server 2005 option disappeared from Add/Remove programs. Now I want to remove SQL Server 2005 and re-install, but I don't have the option to remove any longer. Please help!
Thanks in advance... Steve
July 23, 2008 at 8:16 am
Strange.
If you need to save databases, I'd copy those, then delete the mssql folder structure off the disk. Also in HKLM/Software, delete the Microsoft SQL Server keys. That should let you reinstall.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 23, 2008 at 9:18 am
re run the SQL installer it should pick up any instances already on the pc, then run repair
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 24, 2008 at 11:45 am
I am having great difficulties getting rid of current SQL Server installation. I have done as suggested several times (because uninstall is not working): blowing away C:\Program Files\Microsoft SQL Server folder and sub-folders, blowing away HKLM\Software\Microsoft\Microsoft SQL Server key and subkeys, and blowing away HKCU\Software\Microsoft\Microsoft SQL Server key and subkeys.
Uninstall fails with message box "The feature(s) specified are not valid for this edition of SQL Server".
Install fails at very last step (most important part) Workstation components, books and development tools. At moment of install failure, the tools setup log has following error messages:
----------------
MSI (s) (88:B0) [13:19:40:551]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe 4: /setup
MSI (s) (88:B0) [13:19:40:641]: Transforming table Error.
MSI (s) (88:B0) [13:19:40:651]: Transforming table Error.
MSI (s) (88:B0) [13:19:40:651]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:19:40:651]: Transforming table Error.
MSI (s) (88:B0) [13:19:40:651]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:19:40:651]: Transforming table Error.
MSI (s) (88:B0) [13:19:40:651]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:20:40:367]: Transforming table Error.
MSI (s) (88:B0) [13:20:40:377]: Transforming table Error.
MSI (s) (88:B0) [13:20:40:377]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:20:40:377]: Transforming table Error.
MSI (s) (88:B0) [13:20:40:377]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:20:40:377]: Transforming table Error.
MSI (s) (88:B0) [13:20:40:377]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (88:B0) [13:20:40:377]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup
Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup
----------------
I have searched many sites to try to figure out what this means, but not helping. Any ideas short of re-imaging my machine to get SQL Server completely off my machine? Could I have bad installation media?
FYI, I have no local databases yet; my company keeps all data on enterprise server boxes.
Thanx... Steve
July 24, 2008 at 2:34 pm
OK, I got it figured out.
The key article was: http://support.microsoft.com/kb/909967
The key point in that article was the Windows Installer Cleanup utility. Even after everything that could be uninstalled was uninstalled, and Program Files and Registry entries for Microsoft SQL Server were blown away, there was still an entry in the Windows Installer that had to be blown away with the cleanup tool.
Thanx... Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply