If using Ignition (or FactorySQL/PMI, for that matter) with SQL Server and you run into the following error in various places:
you need to turn off the “no count” option for the server. It appears that the different versions of SQL Server are inconsistent as to whether it is on by default.
To change it:
- Go into the SQL Server management console
- Right-click on the server and select “properties”.
- Select “connections”
- Under “Default Connection Options”, turn off “no count”.
The change will only take affect after the connections in Ignition’s pool are re-established. You could restart the Ignition server, or go into the database connection configuration, show advanced options, and set “max idle connections” to 0. After saving, you can go back in and set it back to the previous value. This process will cause the existing connections to be closed and new ones created.