Service Graph Connector for Microsoft SCCM - Completing successfully but there is a database error

[stacybentley]

We have the Service Graph Connector for Microsoft SCCM running successfully (all import jobs complete successfully in transform history) and the SCCM JDBC Connection Credentials test successfully but on the database server there are "Logon error for user errors..." everytime we run the data imports.

The password is correct.

I cannot find a log that tells me what functionality is try to run or credential record is being used and causing the error.

Anything you can suggest would be greatly appreciated.

[Ashok Sasidhara]

Check whether the information in the following URLs are helpful:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719341

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0748820

[AJ-TechTrek]

Hi @stacybentley ,

There could be several reasons why this login attempt failed:

1. Incorrect credentials: Ensure that the username and password used to connect to the SQL database are correct. Double-check that you have entered the correct credentials for the user.

2. Permission issues: The user may not have the necessary permissions to connect to the SQL database. Check that this user has the appropriate permissions in the SCCM SQL database to connect and retrieve data.

3. Firewall or network issues: The connection may be blocked by a firewall or other network issue. Make sure that the necessary ports are open and that the network is functioning correctly.

4. SQL server instance name issue: Ensure that you have correctly specified the SQL server instance name and that it is accessible from the ServiceNow MID Server.

You can try the following steps to troubleshoot this issue:

1. Check the username and password for correctness and make sure they have the necessary permissions.

2. Check if the SQL Server is running and the correct instance is specified.

3. Check if the firewall is blocking the connection.

4. Try connecting to the SQL database using a different tool or method to validate the credentials and connection.

Also you can refer the below.

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

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[stacybentley]

1. Check the username and password for correctness and make sure they have the necessary permissions. Done and all is correct

2. Check if the SQL Server is running and the correct instance is specified. Done and all is correct

3. Check if the firewall is blocking the connection. Done and there are no blocks

4. Try connecting to the SQL database using a different tool or method to validate the credentials and connection. Done and the test connection passed

Everything works without error until the Service Graph Connector for Microsoft SCCM imports run.

Thank you for the suggestions.

[maroon_byte]

Please clarify when you say error on database server... Do you mean there is no issue on ServiceNow end but on the SQL end, the SQL logs indicate error?

If so, then its probably a Microsoft SQL question and not ServiceNow related.

Regards,

Sharad