Re: Renaming Computer Running SQL or MSDE
From: David Vanstone (dave.vanstone_at_fujitsu.com.au)
Date: 04/14/04
- Next message: EK: "Error 1460 When install msde sp3 at win2000"
- Previous message: SqlJunkies User: "Re: MSDE basic setup problems"
- In reply to: J Young: "Re: Renaming Computer Running SQL or MSDE"
- Next in thread: Greg Low \(MVP\): "Re: Renaming Computer Running SQL or MSDE"
- Reply: Greg Low \(MVP\): "Re: Renaming Computer Running SQL or MSDE"
- Messages sorted by: [ date ] [ thread ]
Date: 13 Apr 2004 23:23:45 -0700
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
- Next message: EK: "Error 1460 When install msde sp3 at win2000"
- Previous message: SqlJunkies User: "Re: MSDE basic setup problems"
- In reply to: J Young: "Re: Renaming Computer Running SQL or MSDE"
- Next in thread: Greg Low \(MVP\): "Re: Renaming Computer Running SQL or MSDE"
- Reply: Greg Low \(MVP\): "Re: Renaming Computer Running SQL or MSDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
