• EN
Solved

MS SQL Login Timeout Parameter?

  • 13 November 2023
  • 1 reply
  • 60 views
A
Badge

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

icon

Best answer by aarongeppert 2 January 2024, 16:36

View original

1 reply

A
Badge

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.

Reply


Community Stats

28,772
Posts
109,694
Replies
36,602
Members
Terms & ConditionsCookie settings
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.