increase connection timeout

[tester321]

Hi i need adjust the connection properties in sql2005, i'm logged in as sa, but i cannot change the connection timeout, all is greyed out, any idea on how to change it?

 

[tester321]

just for clarification, right click db>>properties>>click on view connection properties (hyperlink, lower left)

the execution timeout is what i would like to increase, any ideas how?

 

[gmmastros]

Do you see the little 'help button' at the lower right corner of the screen. If you click it, you can read what it says about the connection properties.

Connection Timeout
The amount of time is seconds to wait when connecting to SQL Server before timing out and returning a failure to connect error to the user. [!]To change this, connect again with the desired connection properties.[/!]

When you load up the Management Studio, the login form has a button named 'Options >>'. Clicking this button allows you to modify the connection options, one of which is the connection timeout.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[tester321]

Thanks George, I thought that this value would change the execution time for an application connection, seems that it just changes for enterprise manager. any thoughts on how to change timeout so script can run longer? THnaks

 

[gmmastros]

That depends on how you connect to the database. If you are using ADO, then there is a property for the connection timeout and anohter one for the command time out. If you are not using ADO, then you may find a connection string parameter to do this.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom