Skip to content

Mr SQL's Blog

Musings on Microsoft SQL Server

Tag Archives: sp_configure

The following error is sometimes displayed if a connection to SQL Server cannot be established:-

SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection

The reason for the error is due to a timeout issue. Extending the timeout period therefore resolves the problem. The timeout can be applied within SQL Server Configuration Manager, but this requires a restart. To apply without restarting, issue the following SQL command:-

EXEC sys.sp_configure N'remote login timeout (s)', N'60'

Tags: , , , ,

%d bloggers like this: