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

[scerazy]

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

[kjb007]

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

-KjB

[scerazy]

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

[Troy_Clavell]

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?

[kjb007]

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

[CRad14]

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!

[scerazy]

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

[vmhyperv]

The link is not working.

thanks

vmguy

[CRad14]

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

Which one isn't working?

[vmhyperv]

Hi,

  This one below

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

thanks

vmguy

[CRad14]

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 ?