Hi all,
I hope all is well! I am very new to FME and data products.
We use FME 2022.2 but we thought it will be time to upgrade to the latest version to benefit from the updates.
I have installed 2025.1 and the first thing that I can see is the reader format has changed
I would use “Microsoft SQL Server Spatial” in 2022 but in 2025 it is “Microsoft SQL Server (MSSQL)”
I would assume they have aggregated both non-spatial and spatial into one reader format.
I go to add the connection that we normally use - in this case it is called GisAzureView which is a hosted server for us. I would then need to select which tables I would like to read from but I get this error:
“Failed to obtain any schemas from reader 'SQLSERVER' 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” - is the error that comes up - so it is failing to open the reader
Let’s try 2022.2 again to make sure it is not just my laptop:
So it looks to be working fine in 2022.2 - I can add tables and run them in 2022.2
Let me go to the database connections to see what is going on in there:
Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2147467259) SSL Provider: The target principal name is incorrect.'. Connection string 'Provider=MSOLEDBSQL19;DataTypeCompatibility=80;Data Source=*********************.com;Initial Catalog=*******;Use Encryption for Data=false;User ID=********;Password=**************************'
The “*” is where the details needing to connect are - I have just wrote over it
I am completely stuck, any help will be much appreciated!
Thanks,
ieuan
