ASP Developer Network - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com

ASPDeveloper

ASPDeveloper.Net / VirtualServerFAQ.COM

Make sure you go to our home page for:

* Virtual Server 2005 FAQ
* ASP.Net 2.0 Information
* ASP.Net 2.0 Streaming Tutorials
* ASP.Net 2.0 HTML based Tutorials

Made possible by Business Internet Technology Shop (BitShop)

Virtual Server 2005

Recent Virtual Server 2005 posts

* Creating a second IDE drive in SCVMM 2007
* Events 592, 600, 593 repeat every minute after installing Virtual
* Virtual Server clustering: does it fit for test of sql server clus
* Permanent Removal of VM from Hper-V on WS 2008?
* Self-Service Portal Media using iso
* VS 2005 R2SP1 Ent x86 on W2K3 R2SP1 Std x64
* Virtual Server 2005 R2 on Vista Business: can"t use Adm Website
* Virtual server versus virtual pc - what is the relationship
* Bad disk performance on 2008 / virtual pc 2007, anybody know how t
* Virtual Server inside Virtual PC
* New VMBus Network Adapter not installed Properly
* Accidental Snapshot Merge
* Windows Server 2008 hosted on Virtual Server 2005 R2 very slow
* Hyper-V Integration Services
* Developer needs help with Hardware/Software for Virtualization
* Server Virtualization and deploy VirtualServer
* Cannot access the admin page
* Updating / installing NIC drivers in HyperV
* Hyper-V
* Can I start a VM from Shell in a Hyper-V Server?

Add Solution

Move VHD - SQL Instance Name Changes

Source: microsoft.public.virtualserver
Sent: 12/02/2008
From: John Schneider
Message:

I have a test environment setup under VS 2005 R2. The VM is running Windows
Server 2003 with SQL Server 2005. I copied the VHD over to another physical
box, but when I bring it up, the SQL Server instance name is different.

In the original VM on the original host system, the SQL instance name is
something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
the VHD over to the new host machine, create a new VM in VS, using the copy
of the VHD. When I bring it up, one of my apps that access SQL errors out,
since it can't find that SQL instance. I just discovered that the SQL
instance name is now "JSELK46", which is the VM's computer name. All of the
databases and tables are intact, but the instance name was lost.

Any idea how/why this happens? Its a real pain to have to go change all
references to the SQL instance name.

Thanks

Post Reply | This is Spam! | Mark as Spam

Related Messages

RE: Move VHD - SQL Instance Name Changes

Sent: 12/16/2008
From: John Schneider
Message:

Does anyone have any ideas about this?

"John Schneider" wrote:

Show quoted text

> I have a test environment setup under VS 2005 R2. The VM is running Windows
> Server 2003 with SQL Server 2005. I copied the VHD over to another physical
> box, but when I bring it up, the SQL Server instance name is different.
>
> In the original VM on the original host system, the SQL instance name is
> something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
> the VHD over to the new host machine, create a new VM in VS, using the copy
> of the VHD. When I bring it up, one of my apps that access SQL errors out,
> since it can't find that SQL instance. I just discovered that the SQL
> instance name is now "JSELK46", which is the VM's computer name. All of the
> databases and tables are intact, but the instance name was lost.
>
> Any idea how/why this happens? Its a real pain to have to go change all
> references to the SQL instance name.
>
> Thanks

Re: Move VHD - SQL Instance Name Changes

Sent: 12/16/2008
From: John Schneider
Message:

"Bo Berglund" wrote:

Thanks for the reply Bo, but I've posted there also and still no replies.

BTW, just as a point of clarification, SQL Server is not being restored to a
different computer. Since the VHD file is just being moved from one host to
another, the actual "computer" (the Virtual Machine) is still exactly the
same. That's what is driving me crazy!

Show quoted text

> On Tue, 16 Dec 2008 07:23:01 -0800, John Schneider
> <(email address - cut out)am> wrote:
>
> >Does anyone have any ideas about this?
> >
> >"John Schneider" wrote:
> >
> >> I have a test environment setup under VS 2005 R2. The VM is running Windows
> >> Server 2003 with SQL Server 2005. I copied the VHD over to another physical
> >> box, but when I bring it up, the SQL Server instance name is different.
> >>
> >> In the original VM on the original host system, the SQL instance name is
> >> something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
> >> the VHD over to the new host machine, create a new VM in VS, using the copy
> >> of the VHD. When I bring it up, one of my apps that access SQL errors out,
> >> since it can't find that SQL instance. I just discovered that the SQL
> >> instance name is now "JSELK46", which is the VM's computer name. All of the
> >> databases and tables are intact, but the instance name was lost.
> >>
> >> Any idea how/why this happens? Its a real pain to have to go change all
> >> references to the SQL instance name.
> >>
> >> Thanks
>
> This is better asked in an sql-server oriented newsgroup.
> What sqlserver does when restored to a different computer is probably
> what they can discuss there.
>
> --
>
> Bo Berglund (Sweden)
>

Re: Move VHD - SQL Instance Name Changes

Sent: 12/16/2008
From: Bo Berglund <(email address - cut out)>
Message:

On Tue, 16 Dec 2008 07:23:01 -0800, John Schneider
<(email address - cut out)am> wrote:

This is better asked in an sql-server oriented newsgroup.
What sqlserver does when restored to a different computer is probably
what they can discuss there.

--

Bo Berglund (Sweden)

Show quoted text

>Does anyone have any ideas about this?
>
>"John Schneider" wrote:
>
>> I have a test environment setup under VS 2005 R2. The VM is running Windows
>> Server 2003 with SQL Server 2005. I copied the VHD over to another physical
>> box, but when I bring it up, the SQL Server instance name is different.
>>
>> In the original VM on the original host system, the SQL instance name is
>> something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
>> the VHD over to the new host machine, create a new VM in VS, using the copy
>> of the VHD. When I bring it up, one of my apps that access SQL errors out,
>> since it can't find that SQL instance. I just discovered that the SQL
>> instance name is now "JSELK46", which is the VM's computer name. All of the
>> databases and tables are intact, but the instance name was lost.
>>
>> Any idea how/why this happens? Its a real pain to have to go change all
>> references to the SQL instance name.
>>
>> Thanks

Re: Move VHD - SQL Instance Name Changes

Sent: 12/16/2008
From: John Schneider
Message:

"Bo Berglund" wrote:

You may be on to something there Bo. I'll do another test, by first
disabling networking on the VM, then reboot it to see if SQL has changed. If
not, I'll then copy the VHD to the other host and bring it up there. If its
still good, then I'll reactivate networking on the new host.

I've never had this problem with VMs running SQL 2000. In fact, I routinely
move them around from host to host. This problem only surfaced when using
SQL 2005.

Thanks again for the replies. There may be a light at the end of this tunnel.

Show quoted text

> On Tue, 16 Dec 2008 13:08:02 -0800, John Schneider
> <(email address - cut out)am> wrote:
>
> >"Bo Berglund" wrote:
> >
> >> On Tue, 16 Dec 2008 07:23:01 -0800, John Schneider
> >> <(email address - cut out)am> wrote:
> >>
> >> >Does anyone have any ideas about this?
> >> >
> >> >"John Schneider" wrote:
> >> >
> >> >> I have a test environment setup under VS 2005 R2. The VM is running Windows
> >> >> Server 2003 with SQL Server 2005. I copied the VHD over to another physical
> >> >> box, but when I bring it up, the SQL Server instance name is different.
> >> >>
> >> >> In the original VM on the original host system, the SQL instance name is
> >> >> something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
> >> >> the VHD over to the new host machine, create a new VM in VS, using the copy
> >> >> of the VHD. When I bring it up, one of my apps that access SQL errors out,
> >> >> since it can't find that SQL instance. I just discovered that the SQL
> >> >> instance name is now "JSELK46", which is the VM's computer name. All of the
> >> >> databases and tables are intact, but the instance name was lost.
> >> >>
> >> >> Any idea how/why this happens? Its a real pain to have to go change all
> >> >> references to the SQL instance name.
> >> >>
> >> >> Thanks
> >>
> >> This is better asked in an sql-server oriented newsgroup.
> >> What sqlserver does when restored to a different computer is probably
> >> what they can discuss there.
> >>
> >> --
> >>
> >> Bo Berglund (Sweden)
> >>
> >Thanks for the reply Bo, but I've posted there also and still no replies.
> >
> >BTW, just as a point of clarification, SQL Server is not being restored to a
> >different computer. Since the VHD file is just being moved from one host to
> >another, the actual "computer" (the Virtual Machine) is still exactly the
> >same. That's what is driving me crazy!
>
> When you say you copied the VHD file over to another computer and used
> it there you created a new virtual machine on that other PC and
> pointed it to the VHD file (copied). This will in actual fact make one
> very significant change to the SQL server PC, it changes the network
> card MAC address. And this is a significant change to the SQL Server I
> am used to (SQLServer 2000) at least.
> To me this counts as the PC being *restored* to another PC.
> SQLServer is known to do strange stuff if it is restored like this....
>
> --
>
> Bo Berglund (Sweden)
>

Re: Move VHD - SQL Instance Name Changes

Sent: 12/16/2008
From: Bo Berglund <(email address - cut out)>
Message:

On Tue, 16 Dec 2008 13:08:02 -0800, John Schneider
<(email address - cut out)am> wrote:

When you say you copied the VHD file over to another computer and used
it there you created a new virtual machine on that other PC and
pointed it to the VHD file (copied). This will in actual fact make one
very significant change to the SQL server PC, it changes the network
card MAC address. And this is a significant change to the SQL Server I
am used to (SQLServer 2000) at least.
To me this counts as the PC being *restored* to another PC.
SQLServer is known to do strange stuff if it is restored like this....

--

Bo Berglund (Sweden)

Show quoted text

>"Bo Berglund" wrote:
>
>> On Tue, 16 Dec 2008 07:23:01 -0800, John Schneider
>> <(email address - cut out)am> wrote:
>>
>> >Does anyone have any ideas about this?
>> >
>> >"John Schneider" wrote:
>> >
>> >> I have a test environment setup under VS 2005 R2. The VM is running Windows
>> >> Server 2003 with SQL Server 2005. I copied the VHD over to another physical
>> >> box, but when I bring it up, the SQL Server instance name is different.
>> >>
>> >> In the original VM on the original host system, the SQL instance name is
>> >> something like "ABC-XYZ", and the computer name is "JSELK46". I then copy
>> >> the VHD over to the new host machine, create a new VM in VS, using the copy
>> >> of the VHD. When I bring it up, one of my apps that access SQL errors out,
>> >> since it can't find that SQL instance. I just discovered that the SQL
>> >> instance name is now "JSELK46", which is the VM's computer name. All of the
>> >> databases and tables are intact, but the instance name was lost.
>> >>
>> >> Any idea how/why this happens? Its a real pain to have to go change all
>> >> references to the SQL instance name.
>> >>
>> >> Thanks
>>
>> This is better asked in an sql-server oriented newsgroup.
>> What sqlserver does when restored to a different computer is probably
>> what they can discuss there.
>>
>> --
>>
>> Bo Berglund (Sweden)
>>
>Thanks for the reply Bo, but I've posted there also and still no replies.
>
>BTW, just as a point of clarification, SQL Server is not being restored to a
>different computer. Since the VHD file is just being moved from one host to
>another, the actual "computer" (the Virtual Machine) is still exactly the
>same. That's what is driving me crazy!

Post Reply | This is Spam! | Mark as Spam

Other groups

Virtual PC (Mac)(3592)	Virtual PC(12844)	Virtual PC (French)(496)
Virtual Server 2005(6245)

Our Sponsors

Virtual Server 2005 Info Here!
http://www.aspdeveloper.net

Wiki

Blogs

Articles

Image galleries

File galleries

Forums

Maps

Directories

ASP Developer Network (since 1996) - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com
Copyright © 1997-2005 by BitShop, Inc. All Rights Reserved.
No content may be reproduced in any form without written permission from BitShop, Inc.
We will be honored to assist with reproduction rights on our material if you contact us.
We also can provide print articles for your magazine, private training seminars at your site, and conference presentations.
Thank you for visiting. Please bookmark our site if you found it useful!
If you wish to make a donation it will help further the development of these free resources: