MSDE over SQL 2005 accidentaly - how to restore SQL 2005?

Hello all!
I write this post on behalf of my colleagues so I don't know a full picture
but this is the situation:
On a Win 2k3 machine with a SQL Server 2005 installed, a colleague
mistakenly installed a software (MBS Navision) with an option for MSDE
installation checked. The result turned out to be non-functional SQL Server
2005 that cannot be reinstalled, removed or repared.
Is there a way to remove the MSDE components and repair or reinstall SQL
Server 2005 without formatting?
Thank youin advance,
HrvojeGu
"Hrvoje Vrbanc" wrote:

> Hello all!
> I write this post on behalf of my colleagues so I don't know a full pictur
e
> but this is the situation:
> On a Win 2k3 machine with a SQL Server 2005 installed, a colleague
> mistakenly installed a software (MBS Navision) with an option for MSDE
> installation checked. The result turned out to be non-functional SQL Serve
r
> 2005 that cannot be reinstalled, removed or repared.
> Is there a way to remove the MSDE components and repair or reinstall SQL
> Server 2005 without formatting?
> Thank youin advance,
> Hrvoje
>
Have you checked out http://support.microsoft.com/kb/290991 on how to remove
SQL 2000 manually.
To remove SQL 2005 manually see http://support.microsoft.com/kb/909967
although there is a command line option to reinstall (REINSTALLMODE) the
instance see http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Johnsql

MSDE from SBS200 on Windows 2k3

Hello,
I am attempting to install MSDE on a client's Windows 2003 server machine
from their Small Business Server 2000 CD containing MS SQL.
The Windows 2003 server unfortunately was partitioned in such a way that I
would like the installation program files, etc. to reside on the D: drive and
not the C: drive.
For some reason I have some vague memory that the destination location for
MSDE cannot be changed from here?
I hope I am wrong and someone can tell me how to fix it. The programs keep
going to the C: drive.
thanks,
Rob
hi Rob,
wallyworld wrote:
> Hello,
> I am attempting to install MSDE on a client's Windows 2003 server
> machine from their Small Business Server 2000 CD containing MS SQL.
> The Windows 2003 server unfortunately was partitioned in such a way
> that I would like the installation program files, etc. to reside on
> the D: drive and not the C: drive.
> For some reason I have some vague memory that the destination
> location for MSDE cannot be changed from here?
> I hope I am wrong and someone can tell me how to fix it. The
> programs keep going to the C: drive.
you can both specify alternate location for data files and executable files
providing the optional
DATADIR="d:\somefolder\" TARGETDIR="d:\somefolder\"
parameters to the setup.exe boostrap installer...
just a note... there's a part of executable that are shared among all
instances of SQL Server 2000/MSDE 2000 that will always be installed in
c:\program files\Microsoft SQL Server\ , and you can not bypass this as,
again, this shared componentes have to be there..
please have a look at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
for additional parameters synopsis..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply