Re: 2 instances of 2005, how do delete one?

Tech-Archive recommends: Speed Up your PC by fixing your registry



When I look at where the programs are running under the services control
panel, I've got 2 of everything (Reporting, Full text indexing, agent, etc).
Looking at the details, there doesn't seem to be a lot of rhyme or reason as
to the directory structure.

They're all under Program Files\Microsof Sql Server\... but then there are
a bunch of subdirs from MSSQL.1 - MSSQL.6, etc on a service by service basis.

When I go to Add REmove Software, there aren't 2 instances of Sql Server
just one. Will the uninstaller let me choose an instance?

I don't want to uninstall *everything*; one of those instances I want to keep.

Thanks
-mark


"Immy" wrote:

Obviously you DO want to uninstall the software.
You don't want to delete the service and the folder!!!!!!

However, you need to identify which is the correct service that you are
using before uninstalling it!
Immy

"Mark" <mmodrall@xxxxxxxxxxxxx> wrote in message
news:6ED2A197-8097-4DBD-B93B-5FF5489B9935@xxxxxxxxxxxxxxxx
Hi...

Somehow on a box here, we got 2 instances of 2005 running - one named
<host>
and the other named <host>\<host>. We're trying to clean up, but i can't
find a wizard for doing that.

Obviously I don't want to uninstall the software. Do I want to edit the
registry to delete the extra services for the 2nd instance manually? Then
go
delete the data directory?

Thanks
Mark




.



Relevant Pages

  • Re: Uninstalling SQL Server 2008 Express - "delete local security
    ... "Delete the local security groups. ... Before you uninstall SQL Server, ... MVP Directory Services ... I decided to do an uninstall of the instance. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Install/Uninstall
    ... else stumbling on this thread read the uninstall information CAREFULLY ... If you have SQL Server 2005 September CTP, ... >I'm wanting to install the September 2005 install, ...
    (microsoft.public.sqlserver.setup)
  • How do I uninstall SQL Server 2005 from Vista when uninstall and manual attempts fail
    ... How do I uninstall SQL Server 2005 Developer Ed from Vista Enterprise ed when the following attempts fail ... Detail on add/remove programs - I selected a SQL Server 2005 item and clicked uninstall. ... I was able to uninstall most of SQL Server 2005 but "Uninstall or change a program" Microsoft SQL Server 2005 still was shown. ... In Services I could still see "SQL Server Reporting Services" and I could stop and start it. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Install/Uninstall
    ... Ive got the September CTP, ... I think I need to reinstall Reporting Services. ... any way to just reintall RS, or do I have to uninstall all of SQL? ... > I had the June SQL Server CTP and ran the uninstal utility from the Sept ...
    (microsoft.public.sqlserver.setup)
  • Re: Install SQLS2k after SQLS2k5?
    ... instance through TCP/IP then I will want to uninstall SQL Server 2005 first ... before installing SQL Server 2000. ... Microsoft SQL Server 2005 Backward compatibility Size 26.35MB ...
    (microsoft.public.sqlserver.setup)