CODEWITHSUNDEEP
asp.netsql-server
Nicolas Cadilhac
Nicolas Cadilhac

Reputation: 4745

Can't find microsoft.sqlserver.batchparser.dll

I wrote an asp.net web app which uses SMO against SQL Server 2008 to be able to run some DB scripts. It references these assemblies (in the C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies folder):

Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo

The microsoft.sqlserver.batchparser.dll is not in this folder. Locally (32 bits machine, IIS7) I have no issue.

When I publish the app to my hosting provider (discountasp.net, SQL Server 2008, IIS7, 32bits too), I get this error:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

I searched my local machine and I can't find this assembly. However it works well on this machine.

The "Microsoft SQL Server 2008 Setup Discovery Report" tool reports I have v10.1.2531.0 installed locally.

Upvotes: 19

Views: 48479

Answers (10)

jo0ls
jo0ls

Reputation: 389

Install the 'Microsoft Visual C++ 2013 Redistributable (x86)' if it is not showing up in add/remove programs.

Upvotes: 0

Jonathan Queipo
Jonathan Queipo

Reputation: 66

This happened to me today. Running as administrator did the trick for me, I'm not sure why.

It's not ideal for production, but might work just fin for development environments.

Upvotes: 0

Andrew
Andrew

Reputation: 876

 <startup useLegacyV2RuntimeActivationPolicy="true"> in App.config

Upvotes: 0

Naeem Ahmed
Naeem Ahmed

Reputation: 276

I resolve this only Just Right Click on Project navigate to Properties and Change Platform Target from 'Any' to 'x86'

failed to load microsoft.sqlserver.batchparser

Upvotes: 2

Der_Meister
Der_Meister

Reputation: 5027

I had SMO x64 installed, but SMO x86 was required on build server.

Upvotes: 0

Ernest Correale
Ernest Correale

Reputation: 516

You could install the SQL Client Connection feature from the SQL Server DVD as well. I installed that as well as the SDK components to resolve this issue while installing SolarWinds.

Upvotes: 0

evilom
evilom

Reputation: 583

First you need to enable browsing of GAC folder:

1. go to Registry Editor (RUN > regedit)
2. go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion
3. Right click Fusion > NEW > DWORD
4. Type DisableCacheViewer
5. Double click DisableCacheViewer
6. Set value to 1

then you can find it here
C:\Windows\assembly\GAC_32\Microsoft.SqlServer.BatchParser\10.0.0.0__89845dcd8080cc91

Upvotes: 7

adrianbanks
adrianbanks

Reputation: 83004

To get this dll, you will need to install the Microsoft SQL Server 2008 Management Objects (available from here). That particular dll gets installed into the GAC, which is why you probably cannot find it using a search.

As you are using a hosting provider, it would appear that they do not have this installed. Your choices are to get it installed by them (which is probably unlikely), or deploy the dll manually (which may be on dodgy licencing ground).

Upvotes: 12

Alvis
Alvis

Reputation: 3773

I had a similar issue, but with R2. For me it worked by installing Microsoft® SQL Server® 2008 R2 Shared Management Objects and dependant Microsoft® System CLR Types for SQL Server® 2008 R2.

Find them here http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978

Upvotes: 2

Joe Stefanelli
Joe Stefanelli

Reputation: 135858

You need to have the SMO components installed on your hosting provider as well. You can download them here.

Upvotes: 2

Related Questions