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


: 
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?   

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.