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?
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.