Select to view content in your preferred language

Error install ESRI Maps for SharePoint_3_0 on SP2010: Microsoft.SqlServer.Types.dll

952
2
10-08-2013 12:49 AM
RégisBouméra
New Contributor
Hello,
I got an error when i try to install (first install) Esri_Maps_SharePoint_3_0_SP2010_en

The error is : "Error: Cannot add the specified assembly to the global assembly cache: Microsoft.SqlServer.Types.dll."

Microsoft.SqlServer.Types.dll v11.0.0.0 is already present on my GAC.

Configuration:
Virtual development machine, everything is on it:
- Windows Server 2008 R2 Enterprise
- SharePoint 2010 (Front & App)
- SQL Server 2012

Thanks
0 Kudos
2 Replies
KatherineDalton
Esri Regular Contributor
Hello Regis,

I hope you were able to resolve the installation problem, but if not, here is the fix:

When running the workflow to connect to external data, you may encounter the error message, "Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies." This error message occurs on systems with SQL Server 2008 which does not always provide version 11 of the Microsoft.SqlServer.Types assembly. This error message should only occur with SharePoint 2010. Follow the steps below to install version 11 of the Microsoft.SqlServer.Types assembly to the Global Assembly Cache (GAC) of the SharePoint server machine.

  1. Download the Microsoft SQL Server 2012 SP1 Feature Pack from http://www.microsoft.com/en-us/download/details.aspx?id=35580

  2. When prompted to choose the download, select "ENU\x86\SQLSysClrTypes.msi" or "ENU\x64\SQLSysClrTypes.msi", depending whether the server is 32-bit (x86) or 64-bit (x64).

  3. Save the file to the server machine and then run it.

  4. Restart IIS.

Hope that helps,
Katy
Katy Dalton | Technical Consultant
THE SCIENCE OF WHERE™
0 Kudos
RégisBouméra
New Contributor
Hello Katy,

And thanks for your reply.
I already fixed my problem, but your reply is good to know.

In fact, i tried to install ArcGIS for SharePoint on a development machine, where Visual Studio (and its SQL server module) were previously installed.

After uninstalling Visual Studio, i was able to install ArcGIS for SharePoint. Then, the installation Visual Studio worked fine too.

Thanks for your reply again.

Régis.
0 Kudos