removing an instance

Hi all,
I have a copy of MSDE running, and it has 2 instances on it, server and
server\server, is there any way to remove server\server and transfer it
to server?
I want to move it as it appears to be interfearing with any setup of
sql based apps (sharepoint refuses to go past the install stage), and
the webadmin pages which wont let me login.
Thanks for the help.
hi,
donaldsmarshall@.gmail.com wrote:
> Hi all,
> I have a copy of MSDE running, and it has 2 instances on it, server
> and server\server, is there any way to remove server\server and
> transfer it to server?
> I want to move it as it appears to be interfearing with any setup of
> sql based apps (sharepoint refuses to go past the install stage), and
> the webadmin pages which wont let me login.
> Thanks for the help.
in order to remove the desired instance you should rely on the standard
Windows "remove application" applet...
if you want to manually remove it, you can have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ... this
method does not clear the registry entries related to Windows Installer MSDE
keys...
in order to clear those entries you have to download and use the MSIZap.exe
tool from the Platform SDK as described in
http://support.microsoft.com/default...b;en-us;320873
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea I tried that but when I reinstall SERVER is still blank,
and SERVER\SERVER is still there
|||hi,
donaldsmarshall@.gmail.com wrote:
> Thanks Andrea I tried that but when I reinstall SERVER is still
> blank, and SERVER\SERVER is still there
in the install/remove application applet, I have a "Microsoft SQL Server
Desktop Engine (instancename)" entry, where the defautl instance
(servername) should only appear as "Microsoft SQL Server Desktop Engine" ...
the first one you have to "drop"...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Yeah I have nothing in Add/Remove, I did have some trouble with the
install routine always failing on the last step, so maybe thats why, I
followed the KB article which told me to use the DISABLEROLLBACK=1
command as it was installing just not starting for some reason.
Oh well I can live with it, if I could just get any apps to work
Thanks Anyway