Could Not Load File Or Assembly Microsoft Sqlserver Batchparser Version

  1. Could Not Load File Or Assembly 'microsoft.sqlserver.batchparser Version=12

Today while doing a BAM POC to one of my clients, I found a number of problems/errors, some of them unexpected and uncommon, while trying to deploy my BAM definition file.

Could Not Load File Or Assembly 'microsoft.sqlserver.batchparser Version=12

  1. How I fixed “Could not load file or assembly ‘Microsoft.sqlserver.smo, version=10.0.0.0′” issue A couple of hours ago, the Backup team sent an email that they are not able to backup databases on an instance using Tivoli Data Protection (TDP).
  2. The Cause: This problem can be taken literally – Microsoft.SqlServer.Batchparser is not installed on your computer. The Solution: Go To this link on the Microsoft site and download the Microsoft SQL Server 2005 Management Objects Collection. Then install the MSI.
  3. The server is missing or unable to call a necessary dynamic-link library (dll) file. On a typical machine, you may find multiple copies of Microsoft.SqlServer.BatchParser.dll. However, in some configurations, the dlls installed with TimeXtender and SQL Server Management Studio (SSMS) do not seem to load, while the ones installed with SMO 2016 are.
  4. Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Could I get help regarding this issue?? I tried re-install SSMS-Setup-ENU but still have the same issue.

In order to contextualize the problem, for this POC we are using only one BizTalk Server machine with BAM Portal, one dedicated SQL Server, and Analysis Server and Integration Server in another dedicated server. So, more or less a simple Multi-Computer Environment.

In this post I will address the most unusual of them:

Deploying Activity… Done.
Deploying View… ERROR: The BAM deployment failed.
Could not load file or assembly ‘Microsoft.SqlServer.ASTasks, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Signature does not have enough data at specified byte. (Exception from HRESULT: 0x80131238) (Microsoft.SqlServer.ConnectionInfo)-Signature does not have enough data at specified byte.

Cause

Could not load file or assembly

Well, the cause is quite obvious by its description. Microsoft.SqlServer.ASTasks assembly is missing or some of its dependencies, although, the environment has been installed, configured and functioning correctly, i.e., everything was working properly with the exception of BAM deployment.

My first suspicion (which ultimately turned out to be right), and because, as I told before, SQL Server is remote was that not all the SQL Server Client Tools components were installed on the BizTalk Server machine.

This suspicion was confirmed when I open the SQL Server 2014 Management Studio console. Because the machine only had the “Management Tools – Basic” feature installed.

The “differences” between basic and complete are:

  • Management Tools – Basic: includes support for the Database Engine and SQL Server Express, SQL Server command-line utility (SQLCMD) and SQL Server PowerShell provider
  • Management Tools – Complete: as the name implies, you get it all. It adds support Reporting Services, Analysis Services, and Integration Services technologies.

Because support for Analysis Services is required in BizTalk Server machines while deploying the view definition, this error occurs.

Solution

To solve this problem, you must install also, on the BizTalk Server machine, the “Management Tools – Complete” shared feature. To do that you need:

  • Clicking on “Compatibility View” button that appears in the Address bar to display the site in Compatibility View.
  • Run SQL Server 2014 setup program.
  • On the SQL Server Installation Center, click Installation.
  • Click New Installation or Add Features to an Existing Installation.
  • Review the information on the Setup Support Rules screen, and then click OK.
  • On the Product Key screen, enter your product key and click Next.
  • On the License Terms screen, select I accept the license terms and then click Next.
  • On the Setup Support Files screen, click Install.
  • On the Feature Selection screen, select the following features, and then click Next.
    • Shared Features
      • Management Tools – Basic
      • Management Tools – Complete

Once “Management Tools – Complete” is installed, you will be able to deploy your BAM definition file.