scerazy
Enthusiast
Enthusiast

How to move DB from SQL 2005 to SQl 2008 R2?

It is needed so I can upgrade VC4 to VC5

It should be as simple as in any other software, detach, copy/move, attach, change DSN entry

But of course, it is NOT:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=796089...

"... may also need to migrate the ADAM database..."

May or have to?

Also after the move I get:

Event ID: 7024

The VMware VirtualCenter Server service terminated with service-specific error The system cannot find the file specified..

And what file would that be?

Anybody has a clue to to fix it?

Seb

0 Kudos
10 Replies
kjb007
Immortal
Immortal

Have you checked your vpxd.log to see what error it shows?

-KjB

vExpert/VCP/VCAP vmwise.com / @vmwise -KjB
0 Kudos
scerazy
Enthusiast
Enthusiast

Did now:

ODBC error: (28000) - [Microsoft][SQL Native Client][SQL Server]Login failed for user ''.

So updated as per:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100648...

and now it works

It really should be simpler....

Seb

0 Kudos
Troy_Clavell
Immortal
Immortal

that is the account used to authenticate to your VCDB.  You have confirmed the user listed in your ODBC connection to your VCDB tested sucessfully?

0 Kudos
kjb007
Immortal
Immortal

Glad it's working, and documentation should reference this issue.  Problem is, there's almost too much documentation at times, and not enough in others.

-KjB

vExpert/VCP/VCAP vmwise.com / @vmwise -KjB
0 Kudos
CRad14
Hot Shot
Hot Shot

Actually just this morning I just posted a blog post about it. Along with some links you might find useful.

http://www.vnoob.com/2011/12/12/upgrade-sql-server-your-vsphere-upgrade/

Let me know if it helps or if you have other questions!

Conrad www.vnoob.com | @vNoob | If I or anyone else is helpful to you make sure you mark their posts as such! 🙂
0 Kudos
scerazy
Enthusiast
Enthusiast

Almost.

You chose the "easier" way of "Uninstall the old versions of vCenter and VUM"

So ofcourse if you re-install the vpxd user/password will be correct

I needed to keep my VC4 for the moment, but move the DB only to SQL 2008 R2

Seb

0 Kudos
vmhyperv
Contributor
Contributor

The link is not working.

thanks

vmguy

0 Kudos
CRad14
Hot Shot
Hot Shot

I just tried all the links in the thread and they all work for me.


Which one isn't working?

Conrad www.vnoob.com | @vNoob | If I or anyone else is helpful to you make sure you mark their posts as such! 🙂
0 Kudos
vmhyperv
Contributor
Contributor

0 Kudos
CRad14
Hot Shot
Hot Shot

That is actually my site.

I have tried with 2 different browsers and it works. I also had a couple different friends check it and they said it loaded fine.

Would you be able to maybe try it with a different browser? Or are you possibly behind a restricted proxy ?

Conrad www.vnoob.com | @vNoob | If I or anyone else is helpful to you make sure you mark their posts as such! 🙂
0 Kudos