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 Installation Confusion

I recently obtained Visual C++ .NET 2003, and am under the impression that I
have to install MSDE to provide SQL support for applications I write.
Do I need to install SQLServer as well? (None of the documentation I have
read so far says so, but some comments I have read make me want
confirmation).
Regards
Dave
Hi Dave,
If you have SQL Server, you have no need to install the MSDE. The MSDE is
basically a cut-down SQL Server mostly used for deployment with apps where
the client doesn't have SQL Server. For development, you should use the
Developer Edition of SQL Server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>I recently obtained Visual C++ .NET 2003, and am under the impression that
>I have to install MSDE to provide SQL support for applications I write.
> Do I need to install SQLServer as well? (None of the documentation I have
> read so far says so, but some comments I have read make me want
> confirmation).
> Regards
> Dave
>
|||Thanks lots for that clarification.
Regards
Dave
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23wWf3Xl5EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Hi Dave,
> If you have SQL Server, you have no need to install the MSDE. The MSDE is
> basically a cut-down SQL Server mostly used for deployment with apps where
> the client doesn't have SQL Server. For development, you should use the
> Developer Edition of SQL Server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Dave Bolt" <dave@.NO_SPAM_PLEASE_davebolt.fsnet.co.uk> wrote in message
> news:usPPlBk5EHA.2012@.TK2MSFTNGP15.phx.gbl...
>

msde from sql server

Hi,
If I write an sql server application can I use the application and the
database that the application create on different computer running msde?
Can I use msde from a remote computer?
Thanks!
Hi,
No problems at all. You could backup the database and restore it in the new
MSDE database.
As well as you can connect to re
"Dave" <dbg@.012.net.il> wrote in message
news:OManl$nyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> If I write an sql server application can I use the application and the
> database that the application create on different computer running msde?
> Can I use msde from a remote computer?
> Thanks!
>
|||Hi,
No problems at all. You could backup the database and restore it in the new
MSDE database.
As well as you can connect using your appliacion to the remotely installed
MSDE database.
Thanks
Hari
SQL Server MVP
"Dave" <dbg@.012.net.il> wrote in message
news:OManl$nyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> If I write an sql server application can I use the application and the
> database that the application create on different computer running msde?
> Can I use msde from a remote computer?
> Thanks!
>