Re: Renaming Computer Running SQL or MSDE

From: Greg Low \(MVP\) (greglow_at_lowell.com.au)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 18:49:48 +1000

I've only seen problems with SQL Server 7 (ie and MSDE v1).

HTH, 

-- 
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"David Vanstone" <dave.vanstone@fujitsu.com.au> wrote in message
news:78d72c83.0404132223.739b363e@posting.google.com...
> Thanks for the response Jim, but earlier versions of MSDE and SQL
> often fail to work if the computer is renamed although that does not
> seem to be the case recently and I have heard a rumor the MSDE2003
> will not have this problem. I would like to know the offical Microsoft
> position on the, but it is hard to come by.
>
> Thanks again.
>
> "J Young" <thorium48@hotmail.com> wrote in message
news:<O1wV5RRIEHA.3664@TK2MSFTNGP11.phx.gbl>...
> > In my experience (and those of my customers) when you rename a computer
and
> > reboot, SQL Server will reconfigure itself to the new machine name just
> > fine. Of course any scripts, DTS packages, or any other processes and
> > procedures that reference the old server name will need to be brought up
to
> > date.
> >
> > Jim
> >
> > "David Vanstone" <dave.vanstone@fujitsu.com.au> wrote in message
> > news:78d72c83.0404122023.225e5433@posting.google.com...
> > > A number of questions have been posted in the past regarding the
> > > problems encountered when renaming a computer that is running SQL or
> > > MSDE. I too have had these problems but recent experience prompts me
> > > to suspect that it is permissible to rename a computer that is running
> > > XP Pro with MSDE2000 without any such problems.
> > >
> > > Does anyone know of, or can anyone direct me to official Microsoft
> > > information which details the restrictions on renaming a host computer
> > > that is running SQL2000 in its various forms (Enterprise, Standard,
> > > Personal Ed, MSDE)
> > >
> > > Thanks

Relevant Pages

  • Re: What version of SQL is on SBS R2 Standard and can I use it?
    ... I followed your instructions and successfully installed SQL Express, ... During the application install the applicaton didn't reconize the default ... SQLEXPRESS and two MSDE instances. ... super administrative purposed within SQL Server and is not the same as the ...
    (microsoft.public.windows.server.sbs)
  • Re: Renaming Computer Running SQL or MSDE
    ... Thanks for the response Jim, but earlier versions of MSDE and SQL ... >> to suspect that it is permissible to rename a computer that is running ...
    (microsoft.public.sqlserver.msde)
  • Re: What version of SQL is on SBS R2 Standard and can I use it?
    ... named instance but default for SQL Express). ... A user level account works ... super administrative purposed within SQL Server and is not the same as the ... you can have MSDE and 2005 Express ...
    (microsoft.public.windows.server.sbs)
  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL or Access DB
    ... But with SQL Express ... is it worth it any longer to mess with an MSDE installation? ... > correctly write an installer project that installed MSDE correctly and set ... It comes with SQL Server 2000 Standard. ...
    (microsoft.public.dotnet.languages.vb)