[THIN] Re: Renaming a sql server
- From: "Doyle, Kevin" <Kevin.Doyle@xxxxxxxxxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Wed, 7 Aug 2002 12:01:44 -0500
I have done this in the past, but not to a SQL box that was the DS so YMMV
(your mileage may vary)
How To rename a SQL server:
If you rename a SQL server you will have to re-run SQL setup (disk 2 in
SELECT)
Follow these steps:
1) Log on to the server at the console and start up SQL query analyzer
2) Run the following commands: sp_dropserver 'OldServerName'
Sp_addserver 'NewServerName'
Note: use actual servernames
3) Shut down the SQL services. (right click SQL icon in systray and choose
STOP Mssql)
4) Remove the server from the domain
5) Rename the server and reboot
6) Run SQL setup (disk 2 in SELECT).
Answer YES to "Do you want to upgrade to standard edition"
7) Add server to domain and reboot
8) Add new sever to DNS and if necessary delete old servername
9) If Necessary delete oldserver name references from WINS
-----Original Message-----
From: Michael Boggan [mailto:MBoggan@xxxxxxxxxxx]
Sent: Wednesday, August 07, 2002 1:45 PM
To: THIN (E-mail)
Subject: [THIN] Renaming a sql server
I have a MSSql 2k box as the DS for my xp farm. Can that server be renamed?
if so what needs to be done to do that?
_________________________________
Michael Boggan, Network Engineer
Virtual Desktop Inc.
Dallas, Texas
Ph: (972) 960-6400
Fax: (972) 960-6445
email: mboggan@xxxxxxxxxxx
http://www.virtualdesktopinc.com
_________________________________
For Technical Support please send email to support@xxxxxxxxxxx
===================================
This weeks Sponsor:
triCerat, Inc
ScrewDrivers fxp: Self Configuring Printer Driver with Bandwidth Control
Learn more at:
http://www.tricerat.com/?page=products&product=sdfxp
===================================
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
===================================
This weeks Sponsor:
triCerat, Inc
ScrewDrivers fxp: Self Configuring Printer Driver with Bandwidth Control
Learn more at:
http://www.tricerat.com/?page=products&product=sdfxp
===================================
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
Other related posts:
