SG-SCCM Import Error

[SN Arch Guy]

Receiving errors when running SCCM Service Graph Connector Import.

Errors in Progress Workers (sys_progress_worker) table:

JDBCLoader

access denied ("java.lang.RuntimePermission" "loadLibrary.sqljdbc_auth.dll")

Errors in Log (syslog) table:

com.glide.db.impex.JDBCLoader: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "loadLibrary.sqljdbc_auth.dll"): java.base/java.security.AccessControlContext.checkPermission(AccessControlContext.java:488)
checkPermission() in AccessController.java:1071
checkPermission() in SecurityManager.java:411
checkLink() in SecurityManager.java:689
checkLink() in SQLServerConnection.java:3652
doSecurityCheck() in FailOverInfo.java:146
<init>() in FailOverInfo.java:135
primaryPermissionCheck() in SQLServerConnection.java:1258
login() in SQLServerConnection.java:972
connect() in SQLServerConnection.java:827
connect() in SQLServerDriver.java:1012
getConnection() in DriverManager.java:683
getConnection() in DriverManager.java:191
driverManagerGetConnection() in JDBCLoader.java:804
preLoad() in JDBCLoader.java:285
createColumnAttributes() in AbstractLoader.java:585
createTableAndMap() in AbstractLoader.java:327
createTableForImport() in AbstractLoader.java:299
load() in AbstractLoader.java:187
startWork() in AbstractLoader.java:169
startAndWait() in AbstractProgressWorker.java:135
startAndWait() in HierarchicalProgressWorker.java:26
start() in AbstractProgressWorker.java:106
startWorker() in ImportSetLoader.java:141
startLoader() in ImportSetLoader.java:130
loadImportSetTable() in ImportSetLoader.java:114
doConcurrentImport() in ScheduledImportSetJob.java:290
runImport() in ScheduledImportSetJob.java:111
runNextImport() in ScheduledImportSetJob.java:86
completeProcess() in ImportSetTransformerJob.java:212
execute() in ImportSetTransformerJob.java:112
lambda$executeJob$1() in JobExecutor.java:216
runInOriginatorContext() in DataReplicationAdvisors.java:74
lambda$inDataReplicationContext$3() in JobExecutor.java:246
executeJob() in JobExecutor.java:219
execute() in JobExecutor.java:195
execute() in JobExecutor.java:184
executeJob() in SchedulerWorkerThread.java:627
lambda$process$3() in SchedulerWorkerThread.java:413
executeInTransaction() in TransactionProcessor.java:38
executeInTransaction() in TransactionalWorkerThread.java:38
process() in SchedulerWorkerThread.java:413
run() in SchedulerWorkerThread.java:184

[SN Arch Guy · Accepted solution]

These errors were caused when the MID server used by SG-SCCM was removed and re-created. We had updated the MID server on the SCCM JDBC_connection (jdbc_connection) record, but the MID Server must also be updated on the Instance (sn_sccm_integrate_instance) record.