Skip to main content
  • EN

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

 

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

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.

Reply


Community Stats

30,352
Posts
115,344
Replies
38,087
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.