SCCM integration failing

[pratiksha5]

Does the mid server needs be on the same machine or it can be on any other machine. 

In my present situation, : mid server is configured on machine A ( service account is local user)

The SCCM database is on machine B.. 

A can discover B but the database connection failed. 

Now we have created a database user, and its an ad account. 

We unchcked the use integrated authentication and tried to test connection. Getting authentication failed. 

java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host serverA.dmain.com, named instance SCCM failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host

Telnet from mid server to sql server failing : tried telnet ip address 1433

Question one 1) the User created on sql needs be local or ad is needed?

2) I can discover windows server from same mid server why it's not able to connect?

Please help

[pratiksha5 · Accepted solution]

Everything else was right, I changed service user for local to domain and it worked. 

https://www.servicenow.com/community/cmdb-blog/configure-service-graph-connector-for-microsoft-sccm-...