SCCM Integration - SQL DB Windows Authentication

[jonfung]

Hello ServiceNow World,

Looking for a hand here. We are implementing SCCM Integration to the CMDB for our Desktop Enterprise and have hit a little roadblock.

Current Status is as follows:
-SCCM 3.0 Plugin - Check
-MID Server Configured and Online - Check

The question I have is around the SQL Database access required. The way our SCCM database is configured is for Windows Authentication only and not Mixed Mode which is apparently out of box for SCCM. We have AD credentials and access to the SCCM DB however our DBA has said that ServiceNow is attempting to authenticate via SQL authentication.

Can ServiceNow be configured to authenticate using Windows credentials or does it have to be SQL authentication?

See error below from connection test.

Data source: SCCM Disk
Error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxxxxx'.
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.service_now.mid.connections.jdbc.JDBCConnection.connect(JDBCConnection.java:70)
com.service_now.mid.connections.jdbc.JDBCConnectionFactory.create(JDBCConnectionFactory.java:37)
com.service_now.mid.connections.ConnectionCachePool.getAvailableConnection(ConnectionCachePool.java:61)
com.service_now.mid.connections.ConnectionCache.get(ConnectionCache.java:88)
com.service_now.mid.probe.JDBCProbe.getJDBCConnection(JDBCProbe.java:613)
com.service_now.mid.probe.JDBCProbe.setConnectionStringFromDataSource(JDBCProbe.java:552)
com.service_now.mid.probe.JDBCProbe.init(JDBCProbe.java:480)
com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:83)
com.service_now.mid.probe.AProbe.process(AProbe.java:43)
com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:95)
com.service_now.mid.queue_worker.AManagedThread.run(AManagedThread.java:34)

com.service_now.mid.probe.JDBCProbe.getJDBCConnection(JDBCProbe.java:617)
com.service_now.mid.probe.JDBCProbe.setConnectionStringFromDataSource(JDBCProbe.java:552)
com.service_now.mid.probe.JDBCProbe.init(JDBCProbe.java:480)
com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:83)
com.service_now.mid.probe.AProbe.process(AProbe.java:43)
com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:95)
com.service_now.mid.queue_worker.AManagedThread.run(AManagedThread.java:34)

[jpro]

Go to your Data sources, if the form does not show "Use Integrated Authentication", personalize to add this field. Checking this field will use the service account you setup to run the mid server service.

Jim

[Pritam6]

Jonfung, did Jim's suggestion fix this issue for you?

I'm experiencing the same login failure and when I select the "Use Integrated Authentication" it also fails.

Am I correct in assuming when this checkbox is selected the MID Server service account will also require access permissions to the SQL table / SCCM server?

[sneha63]

Hi Jonfung,

I'm also facing the same problem. Do we have to use User Id and Password of SQL authentication not windows authentication.

[pratiksha5]

Does the mid server needs be on the same machine or it can be on any other machine. 

In my present situation : mid server is configured on machine A ( service account is local user)

The SCCM database is on machine B.. 

A can discover B but the database connection failed. 

Now we created a database user and its an ad accont. 

We unchcked the use integrated authentication and tried to test connection. Getting authentication failed. 

Please help