Database: Login failed, CrystalReport for Visual Studio 2010 error solution
Two, I have decided to upgrade the Crystal Report of my web application to the new version which was released before 10 days (last version of
Crystal Report for Visual Studio 2010) , because whenever I open my Visual Studio 2010 web application it keeps asking me if I want to upgrade to the new version or not of the Crystal Report and he just said "you are using old version which is "10.0..." ", so each time he asks me I ignored and tell hem keep the current version.
So, I decided to upgraded today and say "Yes" I want to upgrade.
Anyhow, I have finished everything (compiling, and deploying the web site to the server), The development PC "Which is my PC 'Windows XP' " was the crystal Report working fine.
So I test to run the one that I have uploaded in the Production Server in a separate Virtual Directory because I don't' want to touch the live one, then whenever I tried to see the report of the crystal report but It failed and gave me message "Database Login failed".
The solution for that as below:
This problem is the same problem of running two version of asp.net framework, so it's solution will be like the old one which is to put each version of the crystal report of your web site in a separate Application Pool of the IIS.
Hope this solved problem of many users facing this problem.