Duplicate Default Instances of SQL on same network
Posted on 2007-04-03
Creating a SQL Server with the same default instance on the same network.
We are using VMWare on an ESX SAN. I have a Server running SQL 2005 on Windows 2003 R2. I want to make a clone of this Server. The physical Server name will of course be different as the original. However, cloning will also clone my SQL Server with the specified default instance as the original Server name. What kind of problems will this create. I know you shouldn't have 2 SQL Servers with the same default instance name. I plan to un-install and re-install SQL so that I can give it another name. From past experience with SQL 2005 even the un-install and re-install will not get rid of everything linked to the default instance name. Before I had to do some registry hacking to rename the default instance in some places.
Thanks for any help you can give on this topic. The second machine is to be a test server to the original production server.