戻る
-
タイトル
Backup Error: "Microsoft OLE DB Provider for SQL Server" Description: "Timeout expired" -
説明
Backup or Maintenance Plan fails sporadically with the error messages:
"Microsoft OLE DB Provider for SQL Server" Description: "Timeout expired"
ERROR Message: Failed to login to SQL Server
Error: 12303, Msg: Failed to login to SQL Server -
原因
SQL Server connection is timing out -
対策
RESOLUTION:To work around this, you can reconfigure the timeout setting.
Based on which type of error you encounter, you can reconfigure the timeout setting as follows:- Set the remote login timeout to 30 seconds, by using this code:
sp_configure 'remote login timeout', 30 go reconfigure with override go - Set the remote query timeout to 0 (infinite wait), by using this code:
sp_configure 'remote query timeout', 0 go reconfigure with override go
Additionally, the LiteSpeedSettings.ini can be modified to add the following two lines under the logpath entry:[litespeed] installpath = C:\Program Files\Quest Software\LiteSpeed\SQL Server logpath = C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs ConnectTimeout= 60 ConnectRetries= 5This will increase the connection timeout to 60 seconds (default is 15), and connection retries to 5.The LiteSpeedSettings.ini file should be in the following location: C:\ProgramData\Quest Software\LiteSpeed\SQL Server - Set the remote login timeout to 30 seconds, by using this code: