May 11, 2009 at 6:17 am
I have a production SQL (SQL01) server online. Using VMware P2V, I created a VM of the physical server. Before bringing the VM on the network I changed the computer name of the virtual server to VSQL01.
Thus far the physical production server is working without error and I am able to test on the virtual server.
My question, I noticed that both the physical and virtual servers, when looking at SQL Server Enterprise Manager, show the DB as SQL01 - will this cause an issue?
I assume because the server computer nameds are different than I am okay.
Any insight appreciated.
Thanks,
Kerry
May 11, 2009 at 9:22 am
To set up the new computer name in SQL Server, refer to this FAQ:
http://support.microsoft.com/kb/257716/en-us
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server 2000. When the SQL Server service starts for the first time after the name change, it automatically recognizes the change and resets the computer name. You do not need to run setup again to reset this value. However, you must perform several additional configuration steps. To correct the sysservers system table, you should manually run the following procedures.
For a default instance:
sp_dropserver
go
sp_addserver , local
go
For a named instance:
sp_dropserver
go
sp_addserver , local
go
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply