Database Security Issue

Ignition
1

Hello,

We are using Ignition 8.1.28 version and Microsoft SQL Server 2022.
We use the user source type as "Database" once every thing was communicating we test the login using testing login.

But realise we need to modify the table name to match the client standard.

Now once we modify the table name in SQL and update the "Tablename Prefix" in Gateway setting .(Note : Mode is Automatic)

But we are not able to validate the login.

  • We tried restarted both ignition and SQL services.
  • We found some longest recent queries under Status > Connection > Database.
    - Upon see them found the queries are using the new prefix.
    - We also copy those queries to SQL and found no issue in execution.
  • Using Ignition Designer "Database Query Browser" we can still see the old table under schema and also found the new table both have same data.
  • we recreate the user source.

When we revert back to the old name we are able to validate the login,

Question:

  1. Do we need to run any queries in "Database Query Browser" to update the table name once we modify the table name in MSSQL?
  2. Any think we can do to troubleshoot the main cause of the issue on table name is modify? since nothing popup in logger.
    3.Where can we find detail documentation on the this topic which explain all instruction for the configuration ? ( Note: Details are missing from manual )

Appreciate your help to resolve this issue.

Thanks,