Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Unable to connect to any specified MySQL hosts

Unable to connect to any specified MySQL hosts

Overview

The following error message is received in the SolarWinds website:

 

Unable to connect to any specified MySQL hosts

(C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 2XX)

Environment

Orion 

Cause 

This is due to an error in the Mysql connector installation and is non-SolarWinds related. 

Resolution

 

DISCLAIMER: Please note this is not an issue regarding the SolarWinds software but is an issue caused by the MySQL connector on the server. You can uninstall the MySQL connector from the server and it will resolve the issue. If you cannot do so then you may attempt to do the steps below which several of our customers have used in the past from sites like TechNet and Stackoverflow but it is at your own risk. 

 

  1. Stop all SolarWinds Services.
  2. Go to:
    1. C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
    2. C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
  3. Open the machine.config file in any text editor.
  4. Comment out the config in machine.config file. The following lines:

 

    Line 2XX:    <!-- <siteMap>

    Line 2XX:      <providers>

    Line 2XX:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />

    Line 2XX:      </providers>

    Line 2XX:    </siteMap> -->

 

    5.  Restart all SolarWinds Services.

 

 

Last modified

Tags

Classifications

Public