Skip to main content
Solved

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

  • December 4, 2020
  • 2 replies
  • 295 views
joshuajames1979
Contributor
Forum|alt.badge.img+7

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

Best answer by joshuajames1979

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

View original
Did this help you find an answer to your question?

2 replies

joshuajames1979
Contributor
Forum|alt.badge.img+7
  • joshuajames1979Contributor
  • Author
  • Contributor
  • Best Answer
  • December 5, 2020

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

V
  • vtanrgis
  • December 13, 2022

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


Helpful Members This Week

Community Stats

31,105
Posts
117,929
Replies
38,858
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.