Re: Renaming Computer Running SQL or MSDE

From: J Young (thorium48_at_hotmail.com)
Date: 04/13/04


Date: Mon, 12 Apr 2004 22:02:08 -0700

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: Renaming Computer Running SQL or MSDE
    ... I've only seen problems with SQL Server 7 (ie and MSDE v1). ... >> In my experience when you rename a computer ...
    (microsoft.public.sqlserver.msde)
  • Re: SQLEVN70.RLL
    ... Perhaps Office installed SQL Server (MSDE), ... No i didn't rename my computer and that's what confusing me, ...
    (microsoft.public.sqlserver.server)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Need help & support regarding MBSA 2.1 beta 2
    ... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
    (microsoft.public.security)