Friday, March 23, 2012

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

No comments:

Post a Comment