There are some tools for you to check DLL dependencies such as Dependency Walker 2.2, but i didn't use them before. You may have a try.

Please post your SQL Server error log first

make sure your smtp server doesnt require any kind of extra authentication and the account you used has the permission to send email.

use following script to query space used by objects, then figure out what happened.

----the tempdb space used by user and by internal objects

Select

SUM (user_object_reserved_page_count)*8 as...

use sys.dm_exec_requests to check whether the job still running or stucked.

And you could also check SQL Server errorlog whether any errors.

Did u install the SQL Server with local administrator?

saw following information from setup log:

-- Error 1402. Could not open key: UNKNOWN\Components\1FA18F7974E099CD0AF18C3B9B1A1EE8\607E70BC7DD53904381A41035D6BAF57. System error 5Verify that you have sufficient access...

Can u connect successfully from local? Can you telnet port 1433?

You may need do a fully testing to make these ExtendedStoredProcedure.

Could post Windows event log and SQL Errorl log?

Have u ever checked windows event log and SQL Server error log? Found anything related?

Add more infomation:

web config file line 25 <identity impersonate="true" />

I think you may need data warehouse not single reporting and you could only ETL these objects you needed in report not everything. After that, you could optimize your DW...

Open "Reporting Services Configuration" and check the database status.

Thanks Gail. I already implemented option 1.

Thanks Gail. I think it is better for us to modify max file size, so it could keep more information. And it shouldn't impact performance.