MDT 2010 on Windows 2008 R2 x64 - Datacenter

Apr 20, 2010 at 11:50 PM

I have already installed MDTFrontEnd into a Enterprise edition.

Right now I am trying to do a new fresh installation following the exact same guide and I got:

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: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.BadImageFormatException: 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.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Assembly Load Trace: The following information can be helpful to determine why the assembly 'microsoft.sqlserver.batchparser' could not be loaded.


WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

 

Searching the internet I found this solution:

http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/861b57bc-aa21-4b03-bd01-5c164e2bac4e/

That is: Install SQL Server 2005 Feature Pack on IIS server.

Is that feasible?

Any considerations?

Regards

Bruno

Coordinator
Apr 21, 2010 at 7:20 AM

Did you use the 64 Bit download? Actually the only difference between the 32 and 64 Bit version is this particular dll.

Make sure that you don't have the mentioned SQL Server 2005 Feature pack installed as the FrontEnd is using the SQL 2008 dlls so they might interfere. If you want to install the complete Feature packs, use the ones for SQL2008 (http://www.microsoft.com/downloads/details.aspx?familyid=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en). You would need at least the Microsoft SQL Server System CLR Types and the Microsoft SQL Server 2008 Management Objects.

But all necessary dlls should be included in the downloads.

 

May 10, 2010 at 6:01 PM

Thanks Maik

I did a new fresh install and everything is working now..(with 64-bits version)

Thanks!

Bruno

Aug 24, 2010 at 8:25 PM

I am having the same issue on Windows 2008 R2 Enterprise addition.  I have download the 2008 clr and Management objects and installed them but that didnt fix the problem.  I have followed the installation instructions and reviewed them a few times but I dont see anything I missed. 

Checking the bin folder under the root folder of the web app I can see the dll. 

 

Any ideas what else I should look at to fix this?

 

Coordinator
Aug 28, 2010 at 11:14 AM

If you install the SQL feature packs locally on the server you should remove the Microsoft.sqlserver.* dlls from the bin directory of the web frontend so they don't interfere with the ones installed. This is often either a mismatch between sql 2005 and 2008 libraries or the 32 and 64 Bit versions.

Regards

Maik