I've created a ASP.NET MVC Web project with Visual Studio and worked with a local Database. After uploading it to my Windows Server I can't figure out how to setup the connection to its MySQL Database. I already tried nearly every solution posted here but none fit my Problem. I think the big problem is the connection string.
The server runs with Plesk installed if this information matters.
Finally solved it: I took a look at the Server Manager on my Windows Server then went to Local Server, Events and there were some Error messages. The problem was fixed by changing the application pool identity and pasting the connection string, that was made by the MSSMS (Microsoft SQL Server Management Studio), into my Visual Studio Web Deploy Profile