SCCM Integration Ports

SNowUser11 · ‎08-20-2020

Hi,

We are doing SCCM integration with ServiceNow . While Testing connection it gave 1433 port connection error.

What ports do we need to open is it only 1433 or there are more for SCCM integration we need to open?

Thanks

AshishKM · ‎08-20-2020

Hi,

If you are getting 1433 port error, then check if database is accessible from any other external client.

In ServiceNow SCCM Setup, you don't need to give any port details, it's through MID server.

It looks MID server unable to connect database at host machine.

You can also try telnet [DB Host Name ] [ data source port]

Example Error :

MID Server reported error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException:Failed to establish TCP / IP connection to the host <HOTNAME>', port 1433 Error: 'null. Check the connection properties. Make sure that a SQL Server instance is running on the host and accepted on port TCP / IP connections. Make sure that the port no TCP connections are blocked by a firewall. '.

Thanks,
Ashish

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

AshishKM · ‎11-12-2021

Check the Error : Connection refused: connect. Verify the connection properties

The MID has to access over the HOST on which SCCM Database Installed.

Logic : When ServiceNow trigger the SCCM job and try to connect SCCM Database via MID .. MID must have access over SCCM Database Host.

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution