Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-09-22
1
Medium Priority
?
380 Views
Last Modified: 2012-06-21
:
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?  
0
Comment
Question by:abgail
1 Comment
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 36584492
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.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discu…
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question