Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-10-25 : 06:37:15
|
| Hi, Is there a quick way of increasing the connection timeout property in sql server and NOT the front end code?I remember seeing a property for this somewhere once but can not find it in sql server 2008 R2Can the default be increased?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-25 : 06:55:23
|
Did you try to right click the server in object explorer and choose the properties?Maybe you have to restart after changing the value but I'm not sure.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-25 : 07:02:41
|
| I would like to change the following property:server property, connections, you see view connection properties, there is connection timeout which is set to 15 and can ot be changed. Is there a way to change this?Thanks |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-25 : 07:57:02
|
I see now.These values are given by the client while connecting - they do not come from the server hence you can't change in sql server.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-25 : 08:03:29
|
| One of my queries when I run in query analyser says connection timed out.I thought may be the timeout can be increased when running the query in QA.Thanks |
|
|
|
|
|
|
increase connection timeout