I'm seeing following error in ServiceNow data source import set execution log. Data source is using JDBC connection through MID server. MID server is up and running. I'm not sure if this is a credentials issue and if where I need to change the service account that this data source (JDBC via MID) is using. could anyone please help. Thank you
MID Server reported error: SQLState: S0005
com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'XYZ', database 'ABC', schema '123'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(0.........and so on
