Solved

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

Posted on 2011-09-22
1
367 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 500 total points
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now