Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

If your BizTalk Management database has a name other than BizTalkMgmtDb, or your BizTalk MessageBox database has a name other than BizTalkMsgBoxDb, you will not able to configure core Web services with the ESB Configuration Tool. You will receive an error: “The database BizTalkMgmtDb does not exist." You can use this PowerShell script file--GrantPermissions--to help you configure core Web services.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2015.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

Notepad

1. Save the script file GrantPermissions.ps1 to a local folder like C:\test>.
2. Open GrantPermissions.ps1 in Notepad. Search and replace BizTalkMgmtDb with your own database name. Search and replace BizTalkMsgBoxDb with your database name, and then save this file.
3. Run the ESB Configuration Tool to configure Core Web Services. It will fail as expected, and that is okay.
4. Go to Windows\System32\WindowsPowershell\V1.0, and right-click pwershell.exe to run as Administrator.
5. In the PowerShell window, run: Set-ExecutionPolicy Unrestricted
6. In the PowerShell window, run: $serverInstance="mysqlserver" (replace mysqlserver with your sql server instance name)
7. In PowerShell window, run: [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')
8. In the PowerShell window, run: [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.ConnectionInfo')
9. In the PowerShell window, run “c:\test\GrantPermissions.ps1” and make sure there is no error here.