The underlying provider failed on Open

Mukesh Kumar Tiwari

backend -> MySql

Web Admin Panel -> MVC + Entity Framwork

I have Two System A and B.

B is my development pc and A is server pc . my database on A(at server pc). when i work(development) in B then the db connection os working good, i can not facing any issue . but when i publish at host that on A, then the "The underlying provider failed on Open" issue is coming. So i am not getting that why this issue is coming .

i googled a lot. and try all the way which i found during searching. but i could get success to fix this issue .. so please let me suggest of anybody have idea about this .. pls

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruchi Sharavat8y ago
Is connectionstring same for server as well?

While on development you might be using IP address or url to connect with server database but while hosting on server you must use localhost instead of IP.

localhost;initial catalog=yourdbname;user id=yourusername;password=yourpassword;multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient" />
Jenith Thakkar8y ago
Step 1:
Open Internet Information Service Manager on Server (On A)
Step 2:
Click on Application Pools in left navigation tree.
Step 3:
Select your version Pool. In my case, I am using ASP .Net v4.0. If you dont have this version, select DefaultAppPool.
Step 4:
Right click on step 3, and select advanced settings.
Step 5:
Select Identity in properties window and click the button to change the value.
Step 6:
Select Local System in Built-in accounts combo box and click ok.
That's it. Now run your application.

Check this