SCCM integration with Servicenow using servicegraph

[Ankita34]

Hi All,

We are trying to integrate sccm with Servicenow using service graph connector but recieving below error. Telnet is working fine from mid server to SCCM DB host.

The TCP/IP connection to the host SCCMhost port 1433 has failed. Error: "null. 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.

[Saurav11]

Hello,

Please check the below post for the same:-

https://www.servicenow.com/community/itom-forum/sccm-integration-ports/m-p/917889

Please mark my answer as correct based on Impact.

[Richard Hine]

Ankita34,

You need to check with the database administrator for the SQL Server that SCCM is hosted on that the service is listening on port 1433.

From the MID server, you can also run a powershell command to verify the path to port 1433 on the target server is open:-

New-Object System.Net.Sockets.TcpClient("<sccmServerDNSName>", 1433)

If port 1433 is available, it should show Connected : True in the output.

Hope this helps,

Richard

[ersureshbe]

Hi, You should check the mid server configured with the local server access.

Check the connectivity credential with the help of SQL team.

Get the help from security team and check the firewall and port 1433 is opened to access the DB.

Where you are installing the mid server can you check the connectivity with server and DB.

If any one is failure,  you cant connect with Service Now -SCCM connection.