We are trying to upgrade a sql server 2008 database to sql2008 r2. The problem is this database was created by cloning one vmware server (and database) to another server.
So, the machine name in SQL and the registry is the old server. But to connect to ssms, the new server name is used. What would need to be done to correct the cloned database, so it has the correct servername?
What is the best way to do this upgrade? Should we uninstall sql 2008, and do a clean install of sql 2008 r2?