Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Bit if a mess

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2007-11-11 : 03:51:38
Hi
I had sql server 2005 standard edition and express edition and sql 2000 desktop edition all installed on my xp notebook.

Whe i tried to create a maintenance plan in sql 2005 standard edition i got an error saying that it couldn't load something (which looked like it might be dll) so I tried to reinstall sql 2005 standard edition over the top to replace the dlls. However the install wizard told me that it can't do anything as all components are already installed!
So i decided to remove SQL 2005 and start again.
In add remove programs i removed various components (like vss writer, and one or two others) then when i clicked on SQL 2005 to remove it I got a message saying that it had already been removed and would i like to remove it from the add remove programs list.. so i said yes.
It actuallly appears that it is installed (after a fashion) although i can't connect to it anymore in ssms. If i put the cd in to try to reinstall it still tells me that it's already installed....i'm stuck now!

So.. i need to do something drastic to remove sql 2005 (as i can't remove it from the add remove programs and the CD won't let me reinstall over the top)
Can anyone help me with any suggestions to physicall remove it

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-11-11 : 18:05:14
I had the exact thing here , go to sql 2005 server configuration manager and remove the via on the protocols.
I have three version of sql 2005 and sql 2000 then it all stopped i could not load sql 2005 - i found this out by reading the error log thats on the program files....C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG and reading the error log
it told me here what the problem was
Go to Top of Page
   

- Advertisement -