Active8 months ago
Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies. An attempt was made to load a program with an incorrect format.(description) ASPNETCOMPILER(file), myWebDeploy (project).
- SQL Server Troubleshooting: Could not load file or assembly 'Microsoft.SqlServer.BatchParser'. History SQL Server Troubleshooting: Could not load file or assembly 'Microsoft.SqlServer.BatchParser' Table of Contents. Introduction; Solution; Introduction We have encountered an issue with a third-party backup application (Commvault).
- Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0 I have tried to install Microsoft SQL Server 2008 R2 Shared Management Objects from here but no joy.net visual-studio sql-server-2008-r2 entity-framework-5.
- May 22, 2014 Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.
I have installed MS SQL Server 2008 R2 and when I try to update model from database under EDMX file I am facing that error.
Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
I have tried to install Microsoft SQL Server 2008 R2 Shared Management Objects from here but no joy.
abatishchev72.1k70 gold badges269 silver badges404 bronze badges
DeveloperDeveloper18.5k61 gold badges241 silver badges410 bronze badges
12 Answers
Problem: (Sql server 2014) This issue happens when assembly
Microsoft.SqlServer.management.sdk.sfc version 12.0.0.0
not found by visual studio.Solution: just go to http://www.microsoft.com/en-us/download/details.aspx?id=42295 and download:
ENUx64SharedManagementObjects.msi
for X64 OS orENUx86SharedManagementObjects.msi
for X86 OS,
then install it, and restart visual studio.
PS: You may need install
Problem: (Sql server 2012) This issue happens when assembly DB2OLEDBV5_x64.msi
or DB2OLEDBV5_x86.msi
too.Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
not found by visual studio.Solution: just go to http://www.microsoft.com/en-us/download/details.aspx?id=35580 and download:
ENUx64SharedManagementObjects.msi
for X64 OS orENUx86SharedManagementObjects.msi
for X86 OS,
then install it, and restart visual studio.
Problem: (Sql server 2008) This issue happens when assembly Microsoft.SqlServer.management.sdk.sfc version 10.0.0.0
not found by visual studio.Solution: just go to http://www.microsoft.com/en-us/download/details.aspx?id=26728 and download:
Canon iR-ADV C5235 Driver Download – Canon iR-ADV C5235 Driver is the computer software application required to use Canon iR-ADV C5235 printer on suitable Operating system. Canon iR-ADV C5235 Driver is obtainable for totally free get right here at the bottom level table on this web page article. The imageRUNNER ADVANCE C5200 Series transforms workflow from a series of individual processes to an integrated flow of shared information. A beautifully compact communications hub, this Series can drive your organization to new levels of performance and productivity. Canon imageRUNNER ADVANCE C5235 Drivers Download (Windows, Mac OS) Windows Vista/XP, Windows 2000. ImageRUNNER ADVANCE C5235 – C5200 Series print easy-fast advanced printing machines, lined with the touch of a button it is smart “user interface” provides access to scan, or print directly from the cloud, even layered solution to protect confidential information ensures security. Driver canon ir advance c5235. Available Drivers (0) For certain products, a driver is necessary to enable the connection between your product and a computer. On this tab, you will find the applicable drivers for your product or in the absence of any drivers, an explanation of your product's compatibility with each operating system. Disclaimer canon u.s.a.,inc. Makes no guarantees of any kind with regard to any programs, files, drivers or any other materials contained on or downloaded from this, or any other, canon software site.
1033x64SharedManagementObjects.msi
for X64 OS or1033x86SharedManagementObjects.msi
for X86 OS,
(In most cases downloading this is better http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409)
then install it, and restart visual studio.
Problem: I recently got similar problem after installing SharedManagementObjects. assembly ![Could Not Load File Or Assembly Microsoft Sqlserver Batchparser Version Could Not Load File Or Assembly Microsoft Sqlserver Batchparser Version](/uploads/1/2/6/1/126163132/950855675.png)
Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0
not found by visual studio. The problem was Visual C++ Redistributable Packages for Visual Studio was not installed yet.Solution: for Visual Studio 2013 just go to http://www.microsoft.com/en-us/download/details.aspx?id=40784 and download:
vcredist_x64.exe
for X64 OS orvcredist_x86.exe
for X86 OS,
then install it, and restart visual studio.
PS: You can find Visual C++ Redistributable Packages for Visual Studio 20XX for other versions of Visual Studio easily by googling it.
Iman MahmoudinasabIman Mahmoudinasab5,3193 gold badges30 silver badges57 bronze badges
Just want to share my experience on this.
I, too, encountered this error. I'm using MS Visual Studio 2013 and I have an MS SQL Server 2008, though I have had MS SQL Server 2012 Installed before.
I was banging my head on this error for a day. I tried installing SharedManagementObject, SQLSysClrTypes and Native Client, but it didn't work. Why? Well I finally figured that I was installing 2008 or 2012 version of the said files, while I'm using Visual Studio 2013!! My idea is since it is a database issue, the version of the files should be the same with the MS SQL Server installed on the laptop, but apparently, I should have installed the 2013 version because the error is from the Visual Studio and not from the SQL Server.
Gellie AnnGellie Ann
I am using Visual Studio 2013 & SQL Server 2014. I got the below error
Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
not found by visual studio.I was actually expecting
Microsoft.SqlServer.management.sdk.sfc version 12.0.0.0
error because I am using SQL Server 2014. To fix the issue, I had to install SQL Server 2012's
SharedManagementObject.msi
from the below site.Note: You can use https://stackoverflow.com/a/19246011/1030460 answer but focus on the error version to select the download instead of focusing on SQL Server version.
Community♦
Sundeep![Assembly Assembly](/uploads/1/2/6/1/126163132/621657976.jpg)
1,2142 gold badges16 silver badges33 bronze badges
I am running VS 2012, and SQL Server 2008 R2 SP2, Developer Edition. I ended up having to install items from the Microsoft® SQL Server® 2012 Feature Pack. I think that the install instructions noted that these items work for SQL Server 2005 through 2012. I don't know what the exact requirements are to fix this error, but I installed the three items, and the error stopped appearing.
Microsoft® SQL Server® 2012 Feature Pack Items
- Microsoft® SQL Server® 2012 Shared Management Objects : x86 , x64
- Microsoft® System CLR Types for Microsoft® SQL Server® 2012 : x86 , x64
- Microsoft® SQL Server® 2012 Native Client : x86 , x64
Based on threads elsewhere, you may not end up needing the last item or two. Good luck!
Will EdigerWill Ediger
For SQL Server 2014:
Select SharedManagementObjects.msi for your architectur
Could Not Load File Or Assembly Microsoft Sql Server Batchparser Version
erbakererbaker6261 gold badge8 silver badges17 bronze badges
For those who are running into a slight variation of this problem, I just found a solution.
Pre-requisites:using VS 2015 and SQL Server 2012.
Symptom: can't load this subsystem:Microsoft.SqlServer.management.sdk.sfc version 12.0.0.0
At this point you might be like me and confused that you are using SQL Server 2012 but VS 2015 is trying to use version 12.0.0.0, which comes from SQL Server 2014.It turns out that when you install SQL Server 2012, it installs a couple of components from SQL Server 2014. At one point I removed all traces of SQL Server from my machine (using the Add Programs control panel). When I re-installed SQL Server 2012, it either didn't re-install the 2014 components or I deleted them again thinking I missed them the first time around.
The result was that I didn't have the necessary 2014 libraries on my system. I also tried to install the 2014 Shared Management Objects as pointed out above, but that didn't work because I didn't have the CLR runtime from 2014. Canon hf g10 firmware hack. So in order to get a VS 2015 system working with a SQL Server 2012, you have to make sure that these two 2014 packages are installed:
- ENUx64SQLSysClrTypes.msi
- ENUx64SharedManagementObjects.msi
from SQL Server 2014 Feature Pack. Pick the 32 bit versions if you need to.
Here is the site that helped me figure this out.
Greg VeresGreg Veres
Just use MS Web platform Installer 4.5 to install all stuff for MS SQL Server 2008 R2.
And don't forget to reload machine.
:)
DeveloperDeveloper18.5k61 gold badges241 silver badges410 bronze badges
I downloaded 'Microsoft® System CLR Types for Microsoft® SQL Server® 2012' and 'Microsoft® SQL Server® 2012 Shared Management Objects' from @ImanMahmoudinasab mentioned link, but Shared Management Objects had problem while installing and it showed some dependencies message and at the end installation Failed!
Finally I solved the problem with Power Shell. I run PS as administrator with the below command:
AlexAlex
for version 11 download the Microsoft SQL Server 2012 Feature Packhttps://www.microsoft.com/en-us/download/confirmation.aspx?id=43339
- ENUx64SQLSysClrTypes.msi
- ENUx64SharedManagementObjects.msi
for version 12 download the Microsoft SQL Server 2014 SP2 Feature Packhttps://www.microsoft.com/en-us/download/details.aspx?id=42295
- ENUx64SQLSysClrTypes.msi
- ENUx64SharedManagementObjects.msi
Hamid JolanyHamid Jolany
I am using Visual Studio 2013 & SQL Server 2014. I got the below error Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0 not found by visual studio.I have tried all the things like installing
- ENUx64SharedManagementObjects.msi for X64 OS or
- ENUx86SharedManagementObjects.msi for X86 OS
- ENUx64SQLSysClrTypes.msi
- Reinstalling Sql Server 2014
What actually solved my problem is to repair the visual studio 2013(or any other version you are using) now the problem is removed . What i think it is problem of Visual Studio not Sql Server as i was able to access and use the Sql Server tool.
PRATEEK GHOSHPRATEEK GHOSH
I got this error when using
Visual Studio 2013
with Microsoft SQL Server Management Studio 2016
trying to update database with Entity Framework migrations
The fix was to install
Microsoft SQL Server Management Studio 2012 SP1
as Visual Studio 2013 was missing the necessary libraries to connect to the SQL Server database.I put together this detailed page with all the steps I took.
Radu BartanRadu Bartan
Supplement to Iman Mahmoudinasab's answer
For SQL Server 2016, this is where to find the files:
Note that the files are in the list but you may need to scroll down to see/select it.
From SQL Server 2017 onwards, things change:
'Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO.'
Source: https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-2017
macnerdmacnerd
protected by Community♦Nov 2 '14 at 12:49
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged .netvisual-studiosql-server-2008-r2entity-framework-5 or ask your own question.
In a recent R&D operation, I was trying to use some SQLCLR assembly as part of the installation process. It was not easy but it got me into a mess that I thought was worth debugging. One of the interesting issues which I faced recently was to deploy a .net assembly which was failing with an error. I thought the third party .msi and the .dlls they shared must have gone wrong. I wanted to understand what was going wrong here to get a better feeler. The Error mentioned as part of the stack was:
Error: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.SqlServer.BatchParserClient, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
File name: ‘Microsoft.SqlServer.BatchParserClient, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
File name: ‘Microsoft.SqlServer.BatchParserClient, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Whenever there are such errors, we need to look at a few things.
- What is the error?
- What is assembly name?
- What is the version of the assembly?
Here is what we have in error message. I have highlighted them as well.
- IO.FileNotFoundException: Could not load file or assembly
- SqlServer.BatchParserClient
- Version=12.0.0.0
The assemblies are stored in C:WindowsAssembly folder and they are shown as below
Two things to be noted in the screenshot. Version and Processor Architecture. The screenshot is NOT from the same machine where we received the error. On the problem machine, we were not seeing the needed assembly.
I have downloaded and installed “Microsoft® SQL Server® 2014 Shared Management Objects” (SMO) from https://www.microsoft.com/en-us/download/details.aspx?id=42295 and after that I was able to get the assembly and the code worked. Microsoft SQL Server Management Objects require – Microsoft SQL Server System CLR Types, that was also available on the same page.
I am sure most of us sometimes don’t get on this path of exploration, but I felt this was a great learning for me to explore. Do let me know if you did debug anything on these lines at your environments via the comments.
Reference: Pinal Dave (https://blog.sqlauthority.com)