weird behavior when using 2 different connections - 1 for application 1 for reports

[TS]

I have 2 sql server databases on 2 different servers, a web app, and a
crystal reports interface. When the app uses 1 database and the reports
datasource points to a different database, both databases on different
servers, the application always comes up, but the report comes back saying
no data.

When i have both the app and reports pointing to the first server or both
pointing to the second server, the reports and application work fine. The
problem is when they don't use the same database. Since the reports work
fine for both databases when both app and report are pointing to same db, I
dont' think it can be the Crystal report since it does work well.

i was thinking it was something to do with either connection or identity or
some factor, maybe since they are on two different servers and some
connectivity issue or something. i'm going to test 2 diff databases on the
same server and see if the problem still persists.

If anyone has any idea, please give me your thoughts, Thanks

 

[Luke Zhang [MSFT]]

What is the relationship between the Crystal report and the web app? Do
they call each other or no relations at all? Did the Web app always work
well connecting to whatever database?

Luke Zhang

 

[TS]

thanks for your reply, but the issue has been resolved - it was tied to a
dependency on a session variable tied to the app used in all pieced of data
in database, thats why no reports came up.

thanks

 

[Luke Zhang [MSFT]]

Thank you for update. I am glad to hear the problem has been resolved.

Luke