Error below may occur when creating Item Database via Archive Shuttle Links page:
“An error occured while creating/updating the Database: INSTANCE_NAME (ArchiveShuttleItem_xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) Error: Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.”
There are two possible causes:
1. From the error message, we can see there is some missing component. The assembly in question – Microsoft.SqlServer.Manangement.Sdk.Sfc version 11 – is a component DLL for SMO assemblies and it is included in SQL Server 2012 Shared Management Objects.
2. It can also happen when “Enable 32-bit Applications” is set to “True” instead of “False” on the Application Pool in IIS.
You will need to install or reinstall Microsoft® System CLR Types for Microsoft® SQL Server® 2012 and Microsoft® SQL Server® 2012 Shared Management Objects
SQL 2012 Shared Management Objects has dependency on SQL System CLR types component, so you have to install SQL Server System CLR Types first.
SQL Server 2012 System CLR Types and SQL 2012 Shared Management Objects can be found in the middle of SQL 2012 Feature Pack web page http://www.microsoft.com/en-us/download/details.aspx?id=29065.
Go to Internet Information Services (IIS) Manager, and then to Application Pools.
Right click on ArchiveShuttleWSAppPool and then on “Advanced Settings”.
Change “Enable 32-bit Applications” from “True” to “False” and click OK.
Reset IIS, by running IISRESET from an elevated Command Prompt.