Re: Change default to named instance??

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 08:39:27 +0530

Hi,

No you cant do directly.
1. Take a backup of all databases (Including system databases)
2. Stop SQL Server and copy the MDF and LDF to a safe place
3. Un Install the MSDE
4. Install MSDE and same service pack as old with same folder structure
5. Stop sql server
6. COpy the MDF and LDF (taken in step 2) to the same folder as old
7. Restart SQL server service
8. Execute the below comamnds in OSQL to change the server name

sp_dropserver <oldserver>
go
sp_addserver <new named server>,local

Note:
If these steps fail (Step 6 and 7) then use the database backup taken in
step-1 to restore all the databases.

Thanks
Hari
MCDBA

"Robbs" <rms14can@hotmail.com> wrote in message
news:e1kT4FGOEHA.3312@tk2msftngp13.phx.gbl...
> I have an app that connects to the default instance of msde. After some
> conflicts with other app's msdes, I now want to use a named instance. This
> is no problem from within the app, but can I change the default msde
> instance to a named instance without losing the any data, and without
> reinstalling msde?
>
>

Relevant Pages

  • RE: How to configure WSS to use SQL server instead of MSDE
    ... This is why, in this post, I wanted to focus on only WSS features. ... Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we ... >>MSDE databases for its configuration and content ...
    (microsoft.public.sharepoint.windowsservices)
  • Cannot insert explicit value for identity...
    ... I am developing an integration process between two databases. ... The main database is the SQL Server, the MSDE will contain a really ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie Questions
    ... I have noticed that some of the documentation talkes about SQL Server ... > MSDE is the old database engine there is now as well SQL server Express, ... > hard to find (mostly everything is done with scripting ASP style). ... How do I use the MSDE functionality in relation to databases? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Relocate MSDE 2000 database?
    ... Most of the 2000 versions of SQL Server and thus MSDE have been pulled. ... It can be purchased for about $40 and can manage any version of SQL Server. ... It will be increasingly expensive to support no-supported databases as time goes on. ... post -- these databases are installed and deployed by 3rd party apps ...
    (microsoft.public.sqlserver.msde)
  • Re: Named Instance, Connectivity Question
    ... with SQL Server 2000 Client ... I installed MSDE 2000 under Named Instance. ... yes, you can install only a named instance, only a default instance, or upt ...
    (microsoft.public.sqlserver.msde)
Loading