Skip to main content
Solved

MS SQL Login Timeout Parameter?

  • November 13, 2023
  • 1 reply
  • 362 views

aarongeppert
Contributor
Forum|alt.badge.img+1

QUESTION: Is there anyway to adjust the login timeout for MS SQL connections?

 

Periodically, I've been logging an error from the SQLExecutor transformer which appears to be related to timeout issues when connecting to a MS SQL database. The error below seems to occur at random and is hard to replicate on demand.

 

'Provider error (-247467259) Unable to complete login process due to delay in opening server connection'

 

I suspect that the connection, periodically, is talking longer then the timeout configured in FME. I know of the 'Command Timeout' parameter but as I understand it this is only applicable to the query length timeout, not the login connection timeout

Best answer by aarongeppert

UPDATE: the timeout the error was alluding to was not within FME's configuration, but rather within MS SQL's. Bumping the "Remote Login Timeout" in the Server Properties within Microsoft SQL Server Management Studio from 15sec to 30sec resolved the issue.

View original
Did this help you find an answer to your question?

1 reply

aarongeppert
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • Best Answer
  • January 2, 2024

UPDATE: the timeout the error was alluding to was not within FME's configuration, but rather within MS SQL's. Bumping the "Remote Login Timeout" in the Server Properties within Microsoft SQL Server Management Studio from 15sec to 30sec resolved the issue.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings