A blog on Sitecore, SharePoint, Security, ASP.Net and more…

Menu

SharePoint 2013 geolocation column: a component is not installed

Today I was playing with the new geo location column. I added the Bing maps key, created a custom list and added the geo location column via code to that list. Upon submitting a new listitem, I received an error, mentioning that a component was not installed, to be able to use geolocation. This is a strange error, because I was able to add the column programmatically, while adding content to the list, is not possible. After checking the Diagnostic log, I noticed the following error:

A required component for using a geolocation field is not installed: Microsoft SQL Server System CLR Types

This remembered me that I had read somewhere(this means: It’s not in the geo location MSDN documentation.It’s written in the documenation on mobile apps and geolocation) that the Sql Server System CLR Types needed to be installed on the Web Front End servers. The package that needs to be installed is called “SqlSysClrTypes.msi”, and depending on the version of SQL that is used, one of the following feature pack needs to be installed:

2 thoughts on “SharePoint 2013 geolocation column: a component is not installed”

Hello,
I’m trying to implement same thing on share point 2013 and have SQL server 2017 installed. I wanted to know whether this worked for you or not? Secondly I’ve tried many ways to implement maps on SharePoint online on-premise site but still not able to implement it properly. It will be great if you can help me.
Thanks.