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 |
|
Jinglee
Starting Member
2 Posts |
 Posted - 2009-06-05 : 04:56:57
|
| Hello, I am working on a .Net application and I am trying to connect to the SQL Server 2005 server from my code. The application retrieves and stores information well when run on my local machine.But when I port my application to a remote server and try to run the same it gives me SqlException :Timeout exception at the line where I am trying to open the connection to the database. Can someone help me in figuring out how to fix this issue. Actually the application that I am talking about is a windows service. It is an urgent issue and your support will be of great help. |
|
|
arkhon13
Starting Member
2 Posts |
Posted - 2009-06-05 : 09:50:01
|
| have you tried to increase command.CommandTimeout? |
 |
|
|
Jinglee
Starting Member
2 Posts |
Posted - 2009-06-07 : 23:32:15
|
| yeah..i have tried that option too..but the status is the same. |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-06-08 : 09:58:21
|
| execute this commandEXEC sp_configure N'remote query timeout (s)'check for config_value if the value is 0 then no timeout r else run below commandEXEC sp_configure N'remote query timeout (s)', N'0'GORECONFIGURE WITH OVERRIDEGO |
|
|
|
|
|
|
SQLException:Timeout exception