Just got 900/1000 for Biztalk 2006 R2 Exam (70-241) at Australian Tech Ed 2010 on the Gold Coast!

The Biztalk exams don't have any official training materials. After trawling through 2 Apress Biztalk books (including Apress Pro Biztalk 2009), all the Microsoft 2009 Virtual Labs and a SoA Book (~1300 pages in total), I sat the exam this afternoon.

As usual, many of the questions are slightly ambiguous and I did a lot of "um-ing" and "ahh-ing" before a decided to click the "Exit Exam" button. Thankfully the numbers went my way. Updated MCP logo including my Biztalk cert will appear soon!

DDK

Fix - When Configuring BizTalk 2009 - "Failed to connect to the SQL database SSODB on SQL Server SERVERNAME"

If you get the error "Failed to connect the the SQL database SSODB on SQL Server SERVERNAME", in the Biztalk 2009 Configuration Wizard Or the Enterprise SSO Service doesn't start, then you may not have the sso assemblies registered. To do this, do the following:

1. Open a Visual Studio Command Prompt (so regasm.exe is in the path)
2. Go to the directory C:\Program Files\Common Files\Enterprise Single Sign-On
3. Register the assembles with the command regasm ssosql.dll.
4. Reboot.
5. DONE!

Additional Note:
If you are doing this in a 64-bit environment, you MUST use the 64-bit version of regasm to register the assemblies. Otherwise it will succeed the regasm command but will not support the Biztalk 2009 configuration wizard and keep failing. The 64 bit version of regasm is here: C:\Windows\Microsoft.NET\Framework64\v2.0.50727 
[As per
http://abdulrafaysbiztalk.wordpress.com/2010/03/30/enterprise-sso-service-start-failure-due-to-installation-of-vs2010/
]DDK