When utilizing a JDBC node within Analyze, the corresponding database user will require a minimum of "read" permissions to the object(s) in question ( "write" permissions required for "INSERT" / "UPDATE" queries ).
If the team is connecting to MSSQL Server with
integratedSecurity=true within the connection string, the user will be the one running the analyze service. By default, this will be a local system user. This results in a needed user change from the aforementioned default to a service account that has database access.
The user is controlled as a setting within the Windows service, followed by a required restart.