Increase Sql timeout in .net

Question

I am gettting SQL time out error in my .net service.

As the service is already installed on the production, is there any way I can increase the timeout for the service from App.Config file.

At present, I am getting this exception after one minute, I have to make it to around 10 hours because the stored procedure we are using takes 2-2 hours to execute.

Answer 1

You can set the timeout in your connection string with "connect Timeout = 100000000;" or whatever you want your timeout to be

Answer 2

You could try setting the CommandTimeout property on your SqlCommand. I hope you are not doing this in an ASP.NET application.

Answer 3

The time out setting is up to database server.

In SQL Server Manager open the SQL Server Properties and pick the connection tab and set time out as big as You need.

Ps.

zero goes for no timeout.