MID server to read MS SCCM DBs

[JK1]

Hello experts,

I am encountering an issue with SCCM v.2 setup. The MID server is deployed on Win Server 2012 R2. It seems to work quite well. But as soon as I try to setup the SCCM integration, I get errors with the JDBC driver. The ports and FW rules are configured to pass the traffic. Same applies for the ports on the MSSQL server. Not sure if there is difference, if its standalone server or balancer.

Error I get is :

Test results:

** The MID server did not respond within 300 seconds** The MID server did not respond within 300 seconds Data source: IMP-SCCM (01) Server Identity

  Error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SOF-SCCMDB-01.corp.paysafe.com, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)

com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)

com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)

com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)

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:52)

com.service_now.mid.connections.ConnectionCachePool.getAvailableConnection(ConnectionCachePool.java:82)

com.service_now.mid.connections.ConnectionCache.get(ConnectionCache.java:94)

com.service_now.mid.probe.JDBCProbe.getJDBCConnection(JDBCProbe.java:710)

com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:107)

com.service_now.mid.probe.AProbe.process(AProbe.java:81)

com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:123)

com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)

java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

java.lang.Thread.run(Thread.java:745)

Thanks in advance!

Joro

[dravvyramlochun]

Hello Georgi,

A quick way to tell would be to log into the mid server machine and type the following in a command prompt:

telnet [DB Host] [port you specified in the data source]

Let me know what response you get.

It is most likely to be an infrastructure issue rather than a configuration issue. Check whether your Firewall is allowing this traffic and that the port is whitelisted.

Thanks,

Dravvy

Please Hit like, Helpful or Correct depending on the impact of the response

[JK1 · Accepted solution]

Hello,

it turned out to be issue with local admin rights. After the user was made local admin (not domain) the MID server started to connect fine to the JDBC .

Cheers,

Joro