Everyone -
SINCERE THANKS!
Okay the first thing:
We have already evaluated every SQL statement we are using within MS Reporting Services and there is NOT 1 that does not ececute in less than 4 seconds - and 4 seconds is the longest our of over 400 Stored Procedures. Most are lightning! We have reviewed all execution plans, etc.
This includes MDX going against Analysis Services to display within MS Reporting Services data from Cubes within AS as well as pre-defined AS Reports. We are using MS Reporting Services in a pretty advanced way (?) to provide the capability of a THin WEB OLAP via MS Reporting Services without OWC and the other junk you need on a deskop. This is purely a server side application.
Within DNN we only call via a URL a MS REporting Services report based upon a menu function within DNN.
But - I call
http://localhost/dnn virtual director /default.aspx or I call
http://Server name/dnn virtual directory/default.aspx and everything comes to a grindng halt.
J7Mitch - I can send the DNN data base - but I could never send the hospital data base!
In my heart of hearts - there is something left over in the upgrade from 2.X to 3.X that is lingering somewhere - I am sure that is the problem.
Any help is sincerely appreciated.
Best Regards,
Joe Harris