• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

how to upgradea cloned sql 2008 to 2008 r2 on a vmware server

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?  
1 Solution
Anthony PerkinsCommented:
As suggested in your duplicate question all you have to do is change the server name in SQL Server.  No need to repeat the technical details as it has already been done.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now