We are migrating our asp.net 2.0 applications from SQL authentication to windows authentication.
After enable the impersonation under the web.config, most of the crystal reports are working fine, except a few.
We get the below error. The same source code is working for other reports but failed only on certain reports.
CrystalDecisions.CrystalReports.Engine.InternalException:
Failed to open a rowset. Details: 08003:[Microsoft][ODBC Driver Manager]
Connection not open Failed to open a rowset. Error in File
C:\WINDOWS\TEMP\xxxxxx
{C5DFA62D-70AE-4DAB-B84C-26807F98C10B}.rpt: Failed to open a rowset. --->
System.Runtime.InteropServices.COMException (0x800002D3): Failed to open a
rowset. Details: 08003:[Microsoft][ODBC Driver Manager] Connection not open
Failed to open a rowset. Error in File
C:\WINDOWS\TEMP\xxxxxx
{C5DFA62D-70AE-4DAB-B84C-26807F98C10B}.rpt: ...
Go to the complete details ...