I will try to monitor this... I know that some reports return a lot of data.

Thank you for your advice.

Best regards,

Nicklas

Hi James

I cannot find anything in the iis log.

In the event log I found "Report Server faild to write to trace log.".

In the ReportServer log i found some info:

ERROR: Internal error:...

Thank you Jason for your reply!

It helped a lot…

BR,

Nicklas

Thanks for all answers... (I think we will be able to solve it now...)

Best regards,

Nicklas

Sorry for my insufficient description of my problem…

I will try to explain it a little...

Hi again...

The error has returned... I logged on to the server and the following error message appeared “IIS Worker process has...

We have now made the changes to tempdb and restarted the sql server and the report manager and the report server is working. Hopefully it will stay this way... (If...

Ok, thanks...

I will try to see which sp is not working well.

Do you know if tempdb is used by the rs? (I think so, but I am not sure.)

Because I...

Hi,

Thank you for your response...

Can I set a timeout for a connection or query in RS? Or will the query run as long as it has got enough memory?

I...

That explains why it does not work...

Thank you very much for the article...

/Nicklas 

Ok, I added a SQL login to one of the servers and configured the linked server to use that login for all users not in the login list. The report...