Notifications

40 views

Symptoms


Integration with Microsoft SCCM 2016 plugin while querying  the database server, even though the database name and the service account have access to the SCCM database but while doing the import the following error occurs:

Data source: SCCM 2016 Network
Error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'TESTUSER\svc-sccm-snowtest'. ClientConnectionId:76194d006-988f-4814-aec1-366o28bfb62c
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
java.sql.DriverManager.getConnection(DriverManager.java:664)
java.sql.DriverManager.getConnection(DriverManager.java:208)
com.service_now.mid.connections.jdbc.JDBCConnection.establishConnection(JDBCConnection.java:102)
com.service_now.mid.connections.jdbc.JDBCConnection.connect(JDBCConnection.java:74)
com.service_now.mid.connections.jdbc.JDBCConnectionFactory.create(JDBCConnectionFactory.java:65)
com.service_now.mid.connections.ConnectionCachePool.getAvailableConnection(ConnectionCachePool.java:82)
com.service_now.mid.connections.ConnectionCache.get(ConnectionCache.java:94)

 

**NOTE: the user TESTUSER\svc-sccm-snowtest is just an example in this case.

Release


Any

Cause


The SQL database required 'Integrated Auth'. This means that the user must be logged in order to make the connection to the SQL DB. 

Resolution


 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. 

 

Additional Information


 In order to use this mid server for other integrations, you must connect with the target db with the exact account in the mid service or the other db must not require integrated auth. So if you have other SQL connections that require integrated auth and the user account is different, you must use a different mid server for that connection. It will be one mid server per account. 

Article Information

Last Updated:2018-11-30 02:30:40
Published:2018-11-30