SqlException, Timeout expired. The timeout period elapsed prior to completion ... where do I increase this timeout period?

I keep getting this timeout error in a rather larger report generation using LINQ to SQL.

w3wp.exe, NT AUTHORITY\NETWORK SERVICE, SqlException, Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ... NT AUTHORITY\NETWORK SERVICE, 7, NT AUTHORITY\NETWORK SERVICE, False,

at System.Data.SqlClient.Sq开发者_运维知识库lConnection.OnError(SqlException exception, Boolean breakConnection)

In web.config I have added Connect Timeout = 3600 to the connection string but it happened again, is that the right way to increase this timeout?

Is it done through web.config or maybe IIS? Need to increase it in the meantime while I work on optimizing this thing.

---

You may need to set the CommandTimeout on your DataContext.