Abdul Gafoor M Abdul Gafoor M - 1 year ago 101
MySQL Question

Error connecting to MS SQL server

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.


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=, 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?

Answer Source

I think you should try to remove it in you web.config

<remove name="MySqlSiteMapProvider" />
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download