In the past days I have been installing ESB toolkit 2.0 for BizTalk Server 2009. In 2009 classic environment all seems to work fine but I want to enjoy Exception Management Framework and ESB.Portal in 2006 R2 environment.
Hereunder my “2006 R2” machine :
• Windows Server 2003
• Microsoft .NET Framework 3.5 SP1
• IIS 6.0
• Microsoft SQL Server 2005
• Microsoft BizTalk Server 2006 R2
• Microsoft Visual Studio 2008 SP1
• Microsoft Chart Controls for Microsoft .NET Framework 3.5
Ok, let’s get started
- install/import Microsoft.Practices.ESB.ExceptionHandling.msi
- With VS 2008 : install powershell 1.0 in order to run ESBSource\Source\Samples\Management Portal\Install\Scripts\Management_Install.cmd
- Without VS 2008 : create that 4 virtual dir with the same application pool (see Management_Install.ps1 for details) and build ASP.NET project on separate machine
- deploy bam act and views,ecc.. with bm deploy-all -DefinitionFile:”C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Bam\Microsoft.BizTalk.ESB.BAM.Exceptions.xml”
Now, run ESB configuration tool … ERROR! ESB configuration tool works with SQL.DMO 10.0 that require native client 2008 e SQL Types 2008.
Excluding core components, ESB configuration tool creates :
- EsbExceptionDb and roles
- ESB.ExceptionHandlingServices (with its dedicated app pool)
- ESB.ExceptionHandlingServices.WCF (with its dedicated app pool)
We can manually set that configuration or install SQL Native Client 2008, SQL Types 2008 and SQL.DMO 2008 ( download http://www.microsoft.com/downloads/details.aspx?familyid=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en )
Check the service : http://localhost/ESB.ExceptionHandlingServices/ExceptionHandling.asmx .. it works
Check http://localhost/ESB.ExceptionHandlingServices.WCF/ExceptionHandling.svc … ERROR
Edit web.config file adding in <system.web> section
<trust level=”Full” originUrl=”"/>
check http://localhost/ESB.Exceptions.Service/ExceptionService.svc .. it works
check http://localhost/ESB.Portal … ERROR
(In another machine I have edit web.config in order to remove , Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A string from that entries:
<add assembly=”Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A”/>
<add assembly=”Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A”/> )
ERROR: The HTTP request is unauthorized with client authentication scheme ‘Negotiate’. The authentication header received from the server was ‘NTLM’.
cscript c:\inetpub\adminscripts\adsutil.vbs set w3svc/NTAuthenticationProviders “Negotiate,NTLM”
ERROR : looking at EsbExceptionDb I see that one store procedure miss. Creating it all works fine!
Now I can enjoy ESB.Exception and ESB.Portal with 2006 R2!
usp_insert_Fault
In the past days I have been installing ESB toolkit 2.0 for BizTalk Server 2009. In 2009 classic environment all seems to work fine but what’s the matter if I want to enjoy Exception Management Framework and ESB.Portal in 2006 R2 environment?
Hereunder my “2006 R2” machine :
• Windows Server 2003
• Microsoft .NET Framework 3.5 SP1
• IIS 6.0
• Microsoft SQL Server 2005
• Microsoft BizTalk Server 2006 R2
• Microsoft Visual Studio 2008 SP1
• Microsoft Chart Controls for Microsoft .NET Framework 3.5
Ok, let’s get started
1) install/import Microsoft.Practices.ESB.ExceptionHandling.msi
2) With VS 2008 : install powershell 1.0 in order to run ESBSource\Source\Samples\Management Portal\Install\Scripts\Management_Install.cmd
Without VS 2008 : create that 4 virtual dir with the same application pool (see Management_Install.ps1 for details) and build ASP.NET project on separate machine
3) deploy bam act and views,ecc.. with bm deploy-all -DefinitionFile:”C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Bam\Microsoft.BizTalk.ESB.BAM.Exceptions.xml”
4) Now, run ESB configuration tool … ERROR!
ESB configuration tool works with SQL.DMO 10.0 that require native client 2008 e SQL Types 2008.
Excluding core components, ESB configuration tool creates :
- EsbExceptionDb and roles
- ESB.ExceptionHandlingServices (with its dedicated app pool)
- ESB.ExceptionHandlingServices.WCF (with its dedicated app pool)
We can manually set that configuration or install SQL Native Client 2008, SQL Types 2008 and SQL.DMO 2008 ( download http://www.microsoft.com/downloads/details.aspx?familyid=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en )
5) Check the service : http://localhost/ESB.ExceptionHandlingServices/ExceptionHandling.asmx .. it works
6) Check http://localhost/ESB.ExceptionHandlingServices.WCF/ExceptionHandling.svc … ERROR
Edit web.config file adding in <system.web> section
<trust level=”Full” originUrl=”"/>
7) check http://localhost/ESB.Exceptions.Service/ExceptionService.svc .. it works
check http://localhost/ESB.Portal …
ERROR: The HTTP request is unauthorized with client authentication scheme ‘Negotiate’. The authentication header received from the server was ‘NTLM’.
cscript c:\inetpub\adminscripts\adsutil.vbs set w3svc/NTAuthenticationProviders “Negotiate,NTLM”
ERROR : looking at EsbExceptionDb I see that one store procedure miss. Creating it all works fine!
Remember to change Destination Location of ExceptionHandling.PipelineComponents.dll From “BizTalk Server 2009″ to 2006

Now I can enjoy ESB.Exception and ESB.Portal with 2006 R2!
