<div>
I went there and changed it to 600 seconds, and the timeout still happens after 30 seconds.<br />
<br />
Also, are you saying there would be no way to set the timeout to &quot;normal&quot; and override it when needed?
</div>


I went there and changed it to 600 seconds, and the timeout still happens after 30 seconds.

Also, are you saying there would be no way to set the timeout to "normal" and override it when needed?

<div>
What is the exact timeout message?
</div>


<div>
<div class="content wysiwyg-content">
I am running SQL Server 2005. &nbsp;As far as I can tell the remote query timout for the server (all databases) is 600 seconds.<br />
<br />
I am running an Access front-end with the following connection string:<br />
Provider=sqloledb;Data Source=n.n.n.n;Initial Catalog=DBName;Connection Timeout=600;UID=myuserid;P<wbr />WD=mypwd<br />
<br />
When I run a stored procedure that will take at least 1 minute, it always times out after 30 seconds. &nbsp;What am I missing?<br />

</div>
</div>


I am running SQL Server 2005.  As far as I can tell the remote query timout for the server (all databases) is 600 seconds.

I am running an Access front-end with the following connection string:
Provider=sqloledb;Data Source=n.n.n.n;Initial Catalog=DBName;Connection Timeout=600;UID=myuserid;PWD=mypwd

When I run a stored procedure that will take at least 1 minute, it always times out after 30 seconds.  What am I missing?


Timeout while running SQL Stored Procedure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.