Re: Removing SQL Instance Name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vikram Vamshi (vikram.vamshi_at_nospam.com)
Date: 06/21/04 

Date: Sun, 20 Jun 2004 20:01:38 -0400

- copy off the mdf and ldf files to a safe location
- uninstall the named instance
- install the default instance
- copy back the mdf and ldf files and attach them

Vikram 

-- 
Vikram Vamshi
Eclipsys Corporation
"Senthil" <kumar.senthil@gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@posting.google.com...
> Hi,
>    I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
>
> Thanks,
> Senthil.

Relevant Pages

  • Re: How do I remove my development server log from my client site during login?
    ... How are you logging in and what tool are you using? ... The mdf & ldf files know nothing of the server they may have been attached to. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 express security issue
    ... Only if they then get hold of the MDF and LDF files and attach them to their ... instance of SQL Server - if you allow access to the underlying files then ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... It is a local standalone application, ... Only if they then get hold of the MDF and LDF files and attach them to their instance of SQL Server - if you allow access to the underlying files then you're at risk no matter what software you use. ...
    (microsoft.public.sqlserver.security)
  • Re: sp_attach_single_file_db
    ... You can put the MDF and LDF files wherever you want and attach them with ... sp_attach_single_file_db (which is for MDF file only). ... > Is there a way to specify NEW file locations when using ... > You see the issue I have here is that, on one of my server ...
    (microsoft.public.sqlserver.server)
  • Re: Newbie Question about SQL Server 2005 Express connection...
    ... This my first attempt at deploying a distributed windows app, ... similar issues with connecting to an .mdf. ... you said the .mdf needs to be attached to the server. ... Access file - a connection string in the app would point to the central ...
    (microsoft.public.dotnet.distributed_apps)