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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: