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

SNowUser11 · ‎08-20-2020

Hello Everyone

Thanks for all inputs. The issue is sorted out now. What we saw is the port was different than 1433. So we could not give the port in 'Setup' but in one of the Data source we tried Loading 20 records with that port and it got imported in the staging table. So the connection is working in that way.

Thanks

Harsh Vardhan · ‎08-20-2020

glad you solved it. kindly select the correct answer and close this thread.

Sagar29 · ‎11-12-2021

What is requirement of setup mid server. What we need install mid server to connect the SCCM database

AshishKM · ‎11-12-2021

Hi Sagar,

MID servers are used to established network tunnel between ServiceNow Instance and Organization network.

It's 1:1 mapping means 1 MID can be connect to specific ServiceNow instance.

What you need :

A host machine in your organization network ( either Windows, Linux, Unix ) and you have to download the MID server Utility ( installer or zip format ) from ServiceNow Instance to host and Install( or unzip ). There is installer file inside the agent folder.

LoginId and Password : create a service account (userId : midserver ) and grant the mid_server role. This login credential required during the installation.

For more details : Refer

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/mid-server/concept/mid-server-landing.html

Thanks,

Ashish

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

Sagar29 · ‎11-12-2021

Hello Ashish,

We have received below error while connection

"java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host hgwsnowmiddev01.kingshawaiian.local, 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".

So do need to install sql server on mid server or do we need anything install on mid server to connect successfully.

Appreciate your help !