Skip to main content
Question

MS SQL Server Connection OLE DB : The wait operation timed out

  • November 8, 2022
  • 2 replies
  • 896 views
A

We are in change our FME-Desktops to a new machine. Same WindowsUser, same Version -> our SQL Server Database Connection is not working on the new Server.

By defining a database connection (Windows authentication) the Error below appears.

 

Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...

Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259) TCP Provider: The wait operation timed out.'. Connection string 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=XXXX\\sql1;Initial Catalog=XXXX;Integrated Security=SSPI'

Failed to open reader

UniversalReader -- readSchema resulted in 0 schema features being returned

 

    2 replies

    nampreetatsafe
    Safer
    Forum|alt.badge.img+13

    Hi @atoki12​,  please check out this article for some suggested first steps and let us know if you have any luck with the provided suggestions:

    https://community.safe.com/s/article/failed-to-connect-using-sql-server-2012-native-cli

    lifalin2016
    Contributor
    Forum|alt.badge.img+29
    • lifalin2016Contributor
    • Contributor
    • November 11, 2022

    A timeout suggests that something is blocking the connection. You probably need to look at the firewalls.

    It might theoretically also be that the query is too slow. In that case increase the timeout value.

    -- Cheers, Lars I.

    Reply


    Helpful Members This Week

    Community Stats

    31,223
    Posts
    118,404
    Replies
    38,824
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    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.