i have gotten my answer from MS SQL forums based on this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/edfcf96b-5055-4943-847a-d43645c06ea8/

Basically, the number of processor license required depends on the number of CPU which the operating system...

Thanks Grant for your insight.

I am almost 100% sure that the long running query is causing the application connection (JDBC, ReportServer) to be disconnected.

Sure, i would go about to modify...

did you installed the security update for report viewer 2008 sp1 GDIPLUS.DLL? (KB971119)

I would suggest you to read this 2 articles which might be useful.

Reporting Services and the MS09-062 GDR (GDI+)

http://blogs.msdn.com/psssql/archive/2009/10/15/reporting-services-and-the-ms09-062-gdr-gdi.aspx

Brian Hartman's Report Viewer Blog: GDI+ Updated again

http://blogs.msdn.com/brianhartman/archive/2009/10/13/gdi-updated-again.aspx

I finally got it working. The problem lies at exchange server side, indeed, our exchange server was blocking my test's server mail, and so i had to register the server...

Still unable to get this working..I am guessing it is because of the restored master and msdb Database that is causing this problem. I tried Rudy's suggestions but i don't...

Thank you for your reply HTH.

I am not too sure what did you mean by mail is not working. I have tried reconfiguring it but the problem still exist. By...