2

I have been using Ola Hallengreen maintenance plan . It has been working great for longtime . Recently one of my nightly backup job failed repeatedly with an error:

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unable to complete login process due to delay in opening server connection

I then execute the job manually by right clicking on it and start at step... and it runs fine. No problem.

The server is SQL Server 2008R2.

Does any one know why the job failed?

closed as off-topic by LowlyDBA, RDFozz, Michael Green, McNets, hot2use Mar 29 '18 at 12:47

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – LowlyDBA, RDFozz, Michael Green, McNets, hot2use
If this question can be reworded to fit the rules in the help center, please edit the question.

  • staring recently one of the database refreshed from prod server at the same time. I changed job schedule time. Now it works fine – SQL_DBA_Bini Jan 20 '16 at 16:43
  • Thanks for letting us know that it was a scheduling issue that was causing the problem. – RLF Jan 20 '16 at 19:10
1

You can try to address the problem by increasing the timeout periods.

Increase the standard settings on your server for remote login timeout (s) and remote query timeout (s).

Or in your connection string you could include "Connect Timeout=120;General Timeout=120;" to increase the time allowed for the connections.

0

Unable to complete login process due to delay in opening server connection

The error above happened when you try to do something that take time higher than the original timeout. you can try -l option to increase the timeout for the command. example:

sqlcmd.exe -U myuser -P mydb -l200 \\fill other needed info

Not the answer you're looking for? Browse other questions tagged or ask your own question.