Renaming a Microsoft Sql 2000 Server
slinuxuzer
Member Posts: 665 ■■■■□□□□□□
in Off-Topic
Hi, I am currently building a sql 2000 server running on server 2003 that will replace our current database server. The new server has a interim name, and once we migrate we want the new server to have the old name (we have alot of custom software that relies on the servers name) I was wondering if this is going to be an issue like it would be to change the name of a domain controller.
Thanks in advance.
Thanks in advance.
Comments
-
blargoe
Member Posts: 4,174 ■■■■■■■■■□
Yes there is a procedure you have to undergo. I don't remember specifically the steps, but if you search the knowledge base at Microsoft it will be right there. I've done this a couple of times and it has worked fine.
http://support.microsoft.comIT guy since 12/00
Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
Working on: RHCE/Ansible
Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands... -
bowulf
Member Posts: 19 ■□□□□□□□□□
Open Query Analyzer,
type sp_dropserver <hit F5>
type sp_addserver 'servername'; <hit f5>Kent A.
MCSE - Win2k & Win2k3, MCSA - Win2k3
MCITP - Vista (EST) & Windows 2008, SA
MCTS - Vista; Windows Server 2008 -- Active Directory(640), Network(642), Application Infrastructure (643)
VMware Certified Professional (VCP) - 4,3.x,2.x