- 1). Turn on your host virtual server and wait for your terminal to open.
- 2). Enter the following two lines of code to rename your server, replacing "old_name" and "new_name" with your own corresponding values:
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO - 3). Reboot your server.
- 1). Turn on your host Virtual 2005 server and wait for a terminal to open.
- 2). Enter the following code to rename your renamed named instance:
sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO - 3). Replace "old_name\instancename" and "new_name\instancename" in the above step with your own corresponding names. You have now renamed a Virtual Server 2005 host.
previous post