Uninstall on BizTalk Beta and SQL tables – Cannot drop database “BizTalkMsgBoxDb” because it is currently in use.

Posted: March 2, 2010 in BizTalk
Tags: , ,

Recently I uninstall beta version of BizTalk 2009 Enterprise, I have to remove BizTalk SQL tables because they were not compatible with the development version, but when I try to remove ‘BizTalkMsgBoxDb’ gives the following error:

TITLE: Microsoft SQL Server Management Studio
——————————
Drop failed for Database ‘BizTalkMsgBoxDb’. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————

Cannot drop database “BizTalkMsgBoxDb” because it is currently in use. (Microsoft SQL Server, Error: 3702)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=3702&LinkId=20476

——————————

SOLUTION

  • I restarted the SQL server service and it solved the problem.

Tags: BizTalk | Configuration | Installation | Errors and Warnings, Causes and Solutions

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