SCCM Integration Ports

[SNowUser11]

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

[palanikumar]

Hi,

That is the only port required for SCCM integration.

ServiceNow connect to SCCM database via JDBC connection. Port 1433 is the port for database. No other port is required. Hope MID server has connectivity with ServiceNow via port 443.

Thank you,

Palani

[Harsh Vardhan]

Give a try , Ask your SCCM team to update the sccm credential password and then test it again. 

Also can you use the credentials in data source and then try to test by Loading 20 records"

[AshishKMishra · Accepted solution]

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

[SNowUser11]

I am getting exactly this error.

Also as you pointed out if any other port DB is accessible through how should I test the connection the Setup does not have port to be filled and run. Its only at data source where we can give port if I am not wrong Also No test connection only load 20 records.

Thanks