Timeout expired SQL Execution error

2018-06-20 03:41:20

SQL Execution error!

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

How to solve the timeout expired issue?

just change Connection string to increase time out:

Data Source=YourDBServer;Initial Catalog=YourDB;Provider=SQLNCLI10.1;
Integrated Security=SSPI;Auto Translate=False;Connect Timeout=60;

Hope this helps you out <3

In properties of the instance you can leave it with value 0, which will allow the maximum possible.

To do this right-click on the sql instance and then properties, then connections.

Change the timeout for remote connection.

链接地址: http://www.djcxy.com/p/56688.html