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.

Thanks Andrea I tried that but when I reinstall SERVER is still blank,
and SERVER\SERVER is still there

hi,
[quoted text, click to view]

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.aspx?scid=kb;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.aspx?scid=kb;en-us;320873
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://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

hi,
[quoted text, click to view]

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.shtm http://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