Issues with SCCM Integration

[Developer3]

I am working on SCCM integration. Below are the steps i have done:

1. SCCM Version is 1906. I installed 'Integration - Microsoft SCCM 2016' plugin in servicenow.

2. In SCCM Setup step, i have added all the database details (Here SCCM admin provided us a service account for DB)

3. I configured a mid server. It uses local user account (servicenow credentials). For SCCM, i have given the logon as Windows service account (mentioned in step 2 ) which has access to SQL server.

4. In data sources, i have enabled integration authentication 

I tested the connection and got this error:  Error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication

Below lines are added in ‘wrapper-override.conf’ file in mid server too. The error is still not resolved.

# Java Classpath (include wrapper.jar)

# Add class path elements as needed starting from 1

wrapper.java.classpath.1=lib/*.jar

wrapper.java.classpath.2=extlib/*.jar

# Java Library Path (location of Wrapper.DLL or libwrapper.so)

wrapper.java.library.path.1=lib

wrapper.java.library.path.2=lib/%SNC_JVM_ARCH%

Do i need to perform any other steps before testing the connection?

This is quite urgent. Please let me know if anyone has faced this issue earlier and what is the resolution for this issue.

[Harsh Vardhan]

adding one article here. 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0717141