Showing posts with label Connection Timeout Error. Show all posts
Showing posts with label Connection Timeout Error. Show all posts

Tuesday, August 7, 2012

ConnectionTimeout Error for a Web site is set to a non-default value

An error appears if the connection time-out for a Web site is not the default value. This value determines the length of time in seconds before the server disconnects an inactive user. The default value is 120 seconds for the default Web site and the SharePoint Central Administration Web site. The default value is 3600 seconds (1 hour) for the Web sites on which Team Foundation Server and Team Foundation Server Proxy rely.
To resolve this issue, change the connection time-out to the default value that the error message specifies for the affected Web site.

Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the server to which the error message refers.

To change the connection time-out for a Web site in IIS 6.0
  1. Log on to the server to which the error message refers.
  2. Open the Start menu, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
  3. In the tree pane, expand the local computer, and then expand Web Sites.
  4. Right-click the Web site that the error specifies, and click Properties.
  5. On the Web Site tab, in the Connection timeout box, type the default value that the error specifies.
  6. Click OK.
To change the connection time-out for a Web site in IIS 7.0
  1. Log on to the server to which the error message refers.
  2. Open the Start menu, point to Administrative Tools, right-click Internet Information Services (IIS) Manager, and then click Run as administrator.
  3. In the Connections pane, expand the local computer, and then expand Sites.
  4. Click the Web site that the error specifies.
  5. In the Manage Web Site area, click Limits.
  6. In the Connection timeout box, type the default value that the error specifies.
  7. Click OK.

How To Increase Time Before Connection Timeout Between SQL and SharePoint


We have run into an issue with a couple of clients where a Connection Timeout Error occurs on either very large SSRS reports or in some custom web parts pulling data from SQL.   

By default, the connection between SharePoint and your SQL servers will timeout after 120 seconds.  My current client just had me create a report that takes about 5 minutes to complete rendering...  oops, error!

This is how you fix the timeout issue:

1)  Go to the virtual directory for the site that is timing out.
         C:\inetpub\wwwroot\wss\VirtualDirectories\yourSite
2)  Make a backup of the web.config file.
3)  Edit the web.config file and add an httpRuntime property called "executionTimeout"

In the example below, my connection will now timeout after 5 minutes (300 seconds).