I am in the process of moving from FPMI/FSQL to another server with Ignition. The server is:
Windows Server 2008
MSSQL Server 2008 R2
I can access a table with the dbo schema but not with the legacy factoryPMI schema that was created using FSQL.
In my connections I am using integrated security. I can access all tables using the SQL management studio.
If I use the ALTER SCHEMA statement to change the table to the dbo schema it will work.