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]

just for the testing ,

can you create a data source and mention the same credentials there and then try to click on load 20 records and see if it's giving you an error or not. 

[Developer3]

I created a data source, gave the credentials and clicked on load 20 records. I got the below error:

MID Server reported error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'CORP\Svcsqluser'. ClientConnectionId:f9165df3-b8bb-4da1-bf3d-fadf00753680
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

[Harsh Vardhan]

 Please following the steps below:

MID Server side:

- Go to your mid server machine and access Services. 
- Go to the Service for the Mid server. 
- Go to the Log On tab of the service. 
- Set the service to use the domain account: TESTUSER\svc-sccm-snowtest
- Enter the password. 
- Recycle the service. 

ServiceNow Side:

 - In ServiceNow, go to the Datasource and set the 'Use integrated authentication' to true and save the record. 

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

[Developer3]

Yes i have referred the HI article and tried these steps only. But still getting the error : This driver is not configured for integrated authentication