BizTalk 2010: Notification Services

It is best practice in my opinion when installing BizTalk to follow BizTalk installation manuals. Microsoft provides manuals for each supported operating system or multi-server installation. BizTalk 2010 is supported on:

▪ Windows Server 2008 R2
▪ Windows Server 2008 with Service Pack 2
▪ Windows 7
▪ Windows Vista with Service Pack 2
▪ Windows XP with Service Pack 3

Other requirements are:

▪ Microsoft Internet Information Services (IIS) 7.0 or 7.5
▪ Microsoft Office Excel 2010 or 2007
▪ Microsoft .NET Framework 4 and .NET Framework 3.5 SP1
▪ Microsoft Visual Studio 2010 with Visual C# .NET. Required for BizTalk Server applications development and debugging; not required for production-only systems
▪ SQL Server 2008 R2 or SQL Server 2008 SP1
▪ SQL Server 2005 Notification Services with Service Pack 2
▪ The Windows SharePoint Services adapter Web service requires SharePoint Server 2010, SharePoint Foundation 2010, Windows SharePoint Services 3.0 with Service Pack 1, or Microsoft Office SharePoint Server 2007.

What interesting is SQL Server 2005 Notification Services with Service Pack 2 in combination with SQL Server 2008 R2. If you follow the manual and proceed step by step you eventually are going to configure BizTalk 2010. When you reach step to configure BizTalk BAM Tools and Alerts you can stumble on this kind of error:

Microsoft.BizTalk.Bam.Management.BamManagerException: Failed to set up BAM database(s). ---> Microsoft.BizTalk.Bam.Management.BamManagerException: There was a failure while executing nscontrol.exe. Error:"Microsoft Notification Services Control Utility 9.0.242.0 c Microsoft Corp. All rights reserved. An error was encountered when running this command. Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. " at Microsoft.BizTalk.Bam.Management.AlertModule.ExecNSControlCommand(String commandArg) at Microsoft.BizTalk.Bam.Management.AlertModule.SetupAlertInfrastructure() at Microsoft.BizTalk.Bam.Management.BamManager.SetupDatabases() --- End of inner exception stack trace --- at Microsoft.BizTalk.Bam.Management.BamManager.SetupDatabases() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleSetupDatabases() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run() at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)

I stumbled on it and so did other people I noticed on BizTalk General Forum (see this thread). Solution to this problem is by installing SP3 for SQL Server 2005. I installed BizTalk 2010 on different environments and what I did when following manual instructions is to install SQL Server 2005 Notifications Services through one of SQL Server 2005 ISO’s and then applied first SP2 and later SP3. When you install SQL Server 2008 R2 later on you will see this screen.

BizTalk R2 SQL NS

When you reach this screen you will first see it has Named instance selected, but I changed it to Default instance and proceeded further with my installation. During configuration of BizTalk 2010 BAM Tools and Alerts everything went smoothly. I guess is that requirement should be  SQL Server 2005 Notification Services with Service Pack 3. At least in the case when you want to use SQL Server 2008 R2. The suggested feature pack mentioned in installation document is not going to work, because you will get an error as displayed above.

Cheers!

Technorati:

Comments

Veeren said…
i am using SQL Server 2008 and using the BAM 2010 when i try to config the Alerts i am getting error please send me some solution

Veeren.
veer4urs@gmail.com
8:09 AM
Veeren said…
I am fcing the same problem but i am using SQL server 2008 and BAM 2010 please let me know how to create BAM Alerts with out any error.
8:11 AM
Steef-Jan Wiggers said…
Hi,

I think you can find some answers through this thread on BizTalk forums: http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/c5f01a07-b4fa-45b5-a0f1-6e9b443598d2 or other threads. It basically comes down to installing SQL NS from SQL 2005 media and SP3.
2:22 PM
Silverbugg said…
Hi,

When I originally configured BTS 2010 all was resolving correctly for all BAM databases. I tried to go back in to update portal and notification settings when I noticed that my BAMAnalysis DB was throwing an error. "could not load file or assembly 'microsoft.analysisservices.adomdclient version=9.0.242.0,..." when looking in the Assembly file I have only 10.0 version but of this specific assembly but 2 versions of the rest of the analysis assemblies in both the needed 9.0.242.0 and the 10.0 versions. Is there a SQL 2008 R2 update that moght hose this? How can I get the 9.0.242.0 version back?
5:54 PM
Silverbugg said…
Solved it. Needed more of the feature pack from SQL Server 2005 than what was indicated in the "BizTalk 2010 Installation and Configuration Guide" by Jay Kladiva specifically SQLServer2005_ADOMD_x64 in conjunction with SQLServer2005_NS_x64 & SQLServer2005_XMO_x64 on SQL 2008 R2 server.
6:27 PM
Post a Comment

Popular posts from this blog

DTAP Strategy: Pricing and Licensing

Image
To implement BizTalk solutions it is a good practice to have an DTAP environment in place. DTAP stands for Development, Test, Acceptance and Production. Development and test environments are equal (mirrored) and same account for acceptance and production. Deploying DTAP environments is easy, because there are many factors influencing outcome of DTAP. One factor is pricing and licensing costs. BizTalk is available in different editions and since BizTalk depends on operating system and database there are some configuration options to. Here is an overview of possible configurations for DTAP environments, hence there is a nice BizTalk Feature Dependency Matrix. Besides features, there are non-functional requirements to reckon with like fail-over, availability and scalability. On Microsoft Pricing and Licensing FAQ section of BizTalk I found this on non functional side. In a large BizTalk Server 2006 R2 deployment, two key considerations ensure redundancy in all areas of the architect
Read more

Table Operation on Oracle 11g XE with OracleDbBinding

Image
Last year I did a post on table operations on SQL Server Table with WCF-SQL Adapter from BizTalk on SQL. Now I like to do similar thing on table in Oracle 11g Express database using the Oracle Binding from BizTalk Adapter Pack 2010. Oracle 11g Express Edition is available through OTN. For downloading software you will need to have an account! It is important that when accessing Oracle you have appropriate client installed. This can sometimes be a hassle if you do not know, which client you need. When you trying to connect to Oracle you will get error messages like: Connecting to the LOB system has failed. Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.. This can be pretty annoying, but there is documentation that can help you going the right direction. In installation documentation I read that supported versions are: Oracle d
Read more

Integration, the community blasting into 2017!

Image
In the past, now and tomorrow I will keep saying that integration is relevant, even in this day and age of digitalization. Integration professionals will play an essential role in providing connectivity between systems, devices and services. Integration drives the digitalization forward by connecting everything with anything. Integration skills are still in demand. A LinkedIn study revealed a top 10 with integration and middleware in top 5 with Cloud, Data Science, UX and Web. And the expectation for 2017 is that this will be similar. Our toolbox is expanding from on premise tooling to cloud services; we have WCF, BizTalk Server, MSMQ to Logic Apps, API Management and Service Bus. Formats ranging from flat file, EDI, XML to JSON, several protocols open and proprietary, tooling from mappers to BizTalk360. It can be challenging yet much more exciting. My conclusion is more options, more fun, at least in my view. In February I, will be travellin
Read more