Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Hi there, I have been using FME Desktop 2020 on both my laptop and desktop for work without trouble. I have installed the same version and used the same license on our GIS Server, but the reader won't connect to SQL Server Spatial. Below is the erro

Failed to open reader

Failed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' reader

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' reader

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' reader

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

Failed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' reader

Sorry I realised it was using SQL Server Authentication. I changed it to Windows Authentication and it works. Apologies.

I'm having this same issue on a remote server that has access to our SQL Server through port 1433. Other applications such as ArcGIS are able to access the server and database, but I get the same exact error above using FME when trying to set up a reader for both spatial and non-spatial SQL. ALSO, I'm able to access the database using the SQL Non-Spatial (JDBC) reader.

 

I'm assuming there's an issue with the MSSQL_ADO connector. I've reinstalled SQL Native Client 2012 and even repaired the installation of FME... We are using the Data Interoperability Extension for GIS, if that perhaps is any indication.

 

Since the installation is not on the same domain, windows login is not possible. SQL Server authentication should work.

 

Any thoughts? Thanks...

Reply


Community Stats

30,162
Posts
114,504
Replies
37,817
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.