Step by Step Guide of BI Case Study of MYSQL via Visual Studio Code-SharePoint 2016

February 28, 2019

Step 1: Install MySQL environment
Go to following link:
https://dev.mysql.com/downloads/mysql/5.6.html
Download MSI package, and install MySQL Server by following default steps.
After MySQL Installation, SharePoint 2016, Central administration and all sites collection, stop working.

Investigating error in ULS logs show following error:

Application error when access /default.aspx, Error=The connection string name is missing for the MySqlSiteMapProvider

at MySql.Web.SiteMap.MySqlSiteMapProvider.Initialize(String name, NameValueCollection config)

at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)

Solution:

Central administration, has web site in IIS. Suppose your central administration pot is 39805, then your web site will be located at following location.
C:\inetpub\wwwroot\wss\VirtualDirectories\39805

You have to add the following code to the web.config file :

<system.web>

<siteMap

<providers>

<remove name=”MySqlSiteMapProvider” />

</providers>

</siteMap>

</system.web>

Similarly, for all web applications, in SharePoint, see the port of web application. For each web application, see the virtual directory as below.

C:\inetpub\wwwroot\wss\VirtualDirectories\XXX

Where XXX, is the port of web application of SharePoint environment.

After these web.config changes, Central administration and all site collection, starts working properly.

For details about POC , see the attached PDF. Step by Step Guide of BI Case Study of MYSQL via Visual Studio Code

Advertisements