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