Removing an instance

I have SQL Server 2000 running on my development machine and I have installed
a named instance of MSDE. The named instance shows up in Services and is set
to start automatically. The problem... It does not show up in the Service
Manager or Enterprise Manager. I can access it in the Enterprise Manager by
specifically naming the instance when registering a new Server. I now want to
uninstall it. There is no entry in the Add/Remove program files. Any idea how
to remove the instance. I can't release my product until I resolve this issue.
Jim
hi Jim,
"Jim" <Jim@.discussions.microsoft.com> ha scritto nel messaggio
news:F62FD912-20AF-459B-A53B-28640B533F73@.microsoft.com
> I have SQL Server 2000 running on my development machine and I have
> installed a named instance of MSDE. The named instance shows up in
> Services and is set to start automatically. The problem... It does
> not show up in the Service Manager or Enterprise Manager. I can
> access it in the Enterprise Manager by specifically naming the
> instance when registering a new Server. I now want to uninstall it.
> There is no entry in the Add/Remove program files. Any idea how to
> remove the instance. I can't release my product until I resolve this
> issue.
the named instance probably does not show in the Service Manager becouse of
disabled network protocols (default setting for MSDE installations), as
reported in http://support.microsoft.com/default...b;EN-US;814132
you can manually uninstall the MSDE named instance, if you really wanto to,
following http://support.microsoft.com/default...;EN-US;Q290991 KB
article
hints... I was succesfull when I did a mess on a test PC... the only problem
with this method is that it does not clear the Windows Installer entries in
the registry.. the only way to clear it is using Msizap.exe tool form the
Platform SDK as
http://support.microsoft.com/default...b;en-us;320873 reports..
please remind that, from a public known point of view, it's not mandatory to
remove that instance, but I do not know your actual needs about it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, it would have taken me a month to figure it out.
"Andrea Montanari" wrote:

> hi Jim,
> "Jim" <Jim@.discussions.microsoft.com> ha scritto nel messaggio
> news:F62FD912-20AF-459B-A53B-28640B533F73@.microsoft.com
> the named instance probably does not show in the Service Manager becouse of
> disabled network protocols (default setting for MSDE installations), as
> reported in http://support.microsoft.com/default...b;EN-US;814132
> you can manually uninstall the MSDE named instance, if you really wanto to,
> following http://support.microsoft.com/default...;EN-US;Q290991 KB
> article
> hints... I was succesfull when I did a mess on a test PC... the only problem
> with this method is that it does not clear the Windows Installer entries in
> the registry.. the only way to clear it is using Msizap.exe tool form the
> Platform SDK as
> http://support.microsoft.com/default...b;en-us;320873 reports..
> please remind that, from a public known point of view, it's not mandatory to
> remove that instance, but I do not know your actual needs about it...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>