Error connecting to MS SQL server

Question

I have the following connection string in a web.config file to connect to MS Sql database.

<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Server=developer\SqlExpress;Integrated Security=True;Database=mydb" providerName="System.Data.SqlClient"/>

I have MS SQL server and MySQL server on the same machine. When I try to run the application I get the following error in the line 285 in the machine.config file.

Error:

Parser Error Message: Authentication to host '' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'localhost' (using password: NO)

<add name="MySqlSiteMapProvider"  type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />

The error is related to mySQL but I am trying to connect MS SQL.

How can I solve the problem?

Are you using SQL Server authentication mode or windows authentication mode? — temUser, Oct 05 '15 at 08:10
Paste the C# code where you connect to SQL. I suspect you use the wrong connectionName — Max, Oct 05 '15 at 09:10

score 10 · Answer 1 · answered Jan 17 '19 at 12:24

This problem occurs when you install Mysql with MySql Connector Net. When Mysql Connector Net installed your computer, it configures your "machine.config" according to your .net version.

There are couple of ways to solve it.

1) You can add <clear /> tag in your provider. "Machine.config" overrides your custom provider, so to disable this we add <clear /> tag in your project web.config.

 <siteMap defaultProvider="SitefinitySiteMap">
  <providers>
    <!-- This line added. -->
    <clear />
    <add name="SitefinitySiteMap" type="Telerik.Sitefinity.Web.SitefinitySiteMap, Telerik.Sitefinity" />
  </providers>
</siteMap>

2) Second way is little bit tricky and if you use Mysql with .net, this might cause error on your projects.

Firstly, you need to find location of "machine.config". You can get more information here: https://stackoverflow.com/a/2325492/3801977

In my case, location is:

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

Open your "machine.config", and find following line and remove it:

<siteMap>
  <providers>
    <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=8.0.13.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
  </providers>
</siteMap>

score 8 · Accepted Answer · edited Oct 05 '22 at 02:36

8

"Remove" the MySqlSiteMapProvider provider in your web.config like this:

<siteMap>
  <providers>
    <remove name="MySqlSiteMapProvider" /> <!-- add this line -->
  </providers>
</siteMap>

edited Oct 05 '22 at 02:36

Taylor Brown

1,689
2
17
33

answered Oct 05 '15 at 08:37

Sam Zakhezin

366
1
8

Thanks, I was trying to run sharepoint server 2019 admin page after install and i got this error, i have multiple sites hosted on the same server and some are PHP based and requires mysql so on the same server i have Microsoft SQL Server 2019 and Mysql, looks like ASP.NET based websites from MS doesn't like mysql ;) i'm still learning IIS and this answer helped me a lot ! Note: the tag was added to the config already and it didn't solve the problem, only that answer worked for me. – jiciftw Jan 29 '21 at 20:10

JotaBe · Answer 3 · 2016-09-05T15:53:24.893

1

The problem is not with connecting to SQL Server. The problem is that your configuration file finds an entry with the name MySqlSiteMapProvider that tries to connect to my SQL Server, and it fails. I don't know what this provider is used for, but you must remove it, and its usages from your appilcation code, or update it, so that it uses SQL Server instead of the missing or misconfigured mySql.

edited Sep 05 '16 at 15:53

answered Oct 05 '15 at 09:15

JotaBe

38,030
8
98
117

Just had the same problem, not to sure where it can from :-(, I removed it in the web.config – MikeAinOz Sep 01 '16 at 21:30

score 1 · Answer 4 · answered Aug 22 '18 at 15:21

1

MySql Connector is creating problem. You can change it by going to Control Panel->Programs->Programs and Features and right click MySql Connector Net [version] where [version] is the version number of the installed MySql Connector for .Net and then click change. Then click Next->Change , then click the drop down before web providers and select 'entire feature will be unavailable'. Then click and finish. And You are done.

answered Aug 22 '18 at 15:21

Muhammad Sadeeq

11
2

Welcome to Stack Overflow! Please note you are answering a very old and already answered question. Here is a guide on [How to Answer](http://stackoverflow.com/help/how-to-answer). – help-info.de Aug 22 '18 at 15:47

score 1 · Answer 5 · answered Nov 27 '20 at 12:20

You can just comment out the provider as shown below instead of deleting the line. It will also work.

<!-- <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=8.0.21.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/"/> -->

score 1 · Answer 6 · answered May 16 '22 at 15:28

1

Add the following to web.config

<system.web>
    <siteMap enabled="true">
        <providers>
            <remove name="MySqlSiteMapProvider" />        
        </providers>
    </siteMap>
</system.web>

answered May 16 '22 at 15:28

Ibrahim Sayed Ahmad

51
4

the accepted answer doesn't have the full path. Your answer helped me as I didn't know where to put it. – Souza Jan 02 '23 at 14:17

score 0 · Answer 7 · answered Jan 10 '18 at 10:22

0

I had this problem

if you use a websitepanel ,go to panel > "websites" > select website and check the "Enable Write Permissions" in home "folder tab"

answered Jan 10 '18 at 10:22

Mahdi Jafari

11
3

How does changing permissions on any folder influence the database connection? – Nico Haase Jan 10 '18 at 10:43

Chiran Wettewa · Answer 8 · 2021-09-06T08:23:36.937

0

Find the machine.config configuration file in the C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config path and comment the below tag.

<add name="MySqlSiteMapProvider"  type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />

edited Sep 06 '21 at 08:23

answered Sep 06 '21 at 08:10

Chiran Wettewa

1
1

Error connecting to MS SQL server

8 Answers8