Microsoft SQL Server Spatial (JDBC) Reader fails to read views

FME is able to use SQL Server DB Aliases (we are using them ourselves), so not sure why that won’t work in your setup. I am not familiar enough with DB aliases to be able to say anything about that, except that it should work with a simple Microsoft SQL Server (ADO)  DB Connection.

As far as views and underlying tables go, if the views and the tables have different owners, then the users need permissions on the tables. If the views and the tables have the same owner, permission chaining allows for skipping the permissions on the tables. See here.

Thanks, I’ll stick to the servername as it doesn’t work with the alias...

What exactly “doesn’t work”? Are you getting error messages? Just timeouts? Have you asked your IT department to check if applications are blocked from connecting to the database? Is there any logging done on the database? How is the network connection and any firewalls between FME and the database set up?

I find it a bit strange that you say that the JDBC-connection is apparently able to use the alias, but the ADO-connection isn’t. That also makes me wonder how you’ve set up your alias.

We might be able to help you solve this, but we’ll need a bit more information, since there could be a million things going wrong here.