Find here the latest version of MBV.
Hi Kelvin,
yes I had fixed MSDTC query when running against 64 bits servers but I already made this fix few months ago; which version did you use before to get th latest ?
About Windows 2008 R2, only BizTalk >= 2009 R2 will be supported on it
JP
I am a DBA and need to provide permissions for our Biz Talk admins to have the ability to run the BizTalk MessageBox viewer but it appears they need permission to drop/recreate a few tables. Is this true? What are the permissions that should be granted to a user of the BizTalk MessageBox Viewer tool?
Hello
this tool is a troubleshooting one and uses lof of SQL cripts which need really to be executed by a sysadmin
if you can not gran,t these permissions, the tooo will fail to execute correcty some queries but will process util the end ts query cataog.It will report however lot of ACCESS DENIED errrors and migfht report wrong information in the warnings
I am looking for an older version of MessageBox Viewer, to use with BizTalk Server 2004 SP1. The current version (11) requires .NET Framework 2.0, which is not available in our environment. Please direct me to the URL where I can download an older version that uses .NET Framework 1.1 from.
Hello,
realy sorry to reply so late to your demand but I was quite busy these past days
MBV can be used on any types of servers and not only on BizTalk Servers, so the best in your case would be for example to run MBV on a server belonging to the same doamin than your bizTalk group but using .NET > 1.x.If you do not have a such server in your BizTalk domain, I can try to put the hand on old version but I just need to rememebr where I could save such build ;-)
I keep you informed as soon I have one
Thanks !
Is it possible to see some of the queries?
how complex are they? Some of them should be usfull to execute without MBV sometimes as well? Is it possible?
Hi Peter,
All the repository of MBV tool is currently emdbeded in the dll provided with the tool and encoded and is not exposed in a .XML file (even if MBV supports to load an XML repository file). It is was choice util now to not expose the queries (SQL, WMI, VBS,etc...) because we did not want to have these queries used elsewhere outside the scope of the tool.
If you have specific demand for some queries let me know and I can send them to you on demand if there is nothing "internal " inisde and if they are not sensitive.
Now nothing prevent you to run SQL profiler to see SQL queries;-) but I'm sure you wil understand that MS can not be responsible of the impact if the tool queries would be executed outside the tool as we can not validate how they will be used.
Thanks
hi, where is the tool BTSDBCOLLECT.EXE ?
I get "Error Connecting Mgmt DB, Error=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".
Is there any setting I need to change? We're running BizTalk 2002 on SQL Server 2000 and remote access is turned on.
Thanks,
RB
Really great tool. I use it all the time. Will you continue to update this when the next CU's and BizTalk versions comes as well?
Hi Jean-Pierre,
I wanted to write an article about how to get rid of records in the MarkLog table(s) and wanted to use MessageBoxViewer to show a warning in case you have too many records.
I am using v1.10 but I can't find the query which checks the MarkLog table(s). Is the query still there? I have 150.000+ records in the MarkLog table of my BizTalkMgmtDb.
Hope to hear from you!
Best regards,
Lex
Hi Lex,
sorry to reply only now, I was quite busy in my job and did not look at MBV blog recently.
The rule checkintg for MarkLog table is located in the Query "MsgBox Tables Size sorted by Custom order" in the query category titled "Important".
In MBV gui just select this query in the list and then select the tab "Query Rules" in the right pane of MBV and you will see this rule; to see its details just press the "Show rules Details".
let me know if you have any issue to locate it
and thanks to use MBV; I really hope that it help you to keep a healthy BizTalk System ! ;-)
Mandatory tool to keep your BizTalk environment healthy. I included this tool in a recipe (Chapter 7 of Monitoring and Maintenance of BizTalk Server) in my BizTalk Server 2010 Cookbook (www.packtpub.com/.../book).
The key tool for all BizTalk Role keeps getting better. Thanks for making our jobs easier.