Skip to main content
Solved

MS SQL Login Timeout Parameter?

  • November 13, 2023
  • 1 reply
  • 474 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

aarongeppert
Contributor
Forum|alt.badge.img+1
  • aarongeppertContributor
  • Author
  • Contributor
  • 1 reply
  • 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.

Community Stats

32,099
Posts
121,892
Replies
39,744
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.