BizTalk 2009 Upgrade error: Invalid object name ‘BizTalkMgmtDb.dbo.bts_orchestration’

When upgrading BizTalk 2006 R2 with SQL Server 2005 + SP3 server to BizTalk 2009. During the upgrading/installation, you might get the following error:
Invalid object name ‘BizTalkMgmtDb.dbo.bts_orchestration’.

Reason could be if you have different names to the default BizTalk DBs names.

But, If you restart SQL Server services and stop all BizTalk services except EntSSO service and Repair the BizTalk 2009 installation, it completes with no errors.

Also, When you upgrade any accelerators (like RosettaNET, SWIFT etc) with different DB Names, you will encounter similar error. but if you repair the installation it will resolve the error and install successfully.

Digg This

Advertisements
This entry was posted in BizTalk. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s