Getting an error while connecting MySql : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

[Vrushali_Gave]

Hello Community members,

Here I’m getting this error : : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

Thanks in advance!

Best Regards,
Vrushali

[J0ska]

The subject states “error while connecting to MySql” but data source in connection propprties states “Microsoft SQL”

I think this is the problem.

Cheers

[J0ska]

And here is a tutorial for connection of MySql

Tutorial on MYSQL connection on Localhost or remote VM

Hi All, I have been trying out to connect to MySql db which is in localhost and which can be in a VM so Finally i found out how to do this so though of sharing this Knowledge which might help developer who wants to do this. Prerequisites : Mysql DB setup in either local machine or in VM MYSQL-SOFTWARE MySql ODBC connector to connect UiPath to DB MySql-Connector install 32bit version since it works without any issue when i tried. Once both are installed firstly create a db which you needs …

Cheers