Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to avoid MySql connectivity issue via remote db for the hosted webservice via remote db?
I have hosted my webservice in IIS 7.0 which is used to fetch data from MySql Db. But on Invoking the web service no data is coming in the Xml Output Tag.
Privilege is given for all hosts(Limit to Host Matching is set as %)
SQL
Error on connecting to MySql is as follows:
Access is denied using sql_native_password{USING PASSWORD YES}

When the same is run via local machine server there is no such error. 

Connection String is set as follows:
<add name="ConnectionString" connectionstring="server=nestit-353vm1;uid=internal;pwd=password2.;database=nest_internal;" />
Posted
Updated 26-Oct-14 20:59pm
v2
Comments
ZurdoDev 27-Oct-14 9:05am    
Access is denied.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900