We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to test MSSQL credential for Discovery

Nisha30
Kilo Sage

3 weeks ago

Hello Everyone,

ITOM Discovery:

We have WMI credentials for windows and they are validated okay with credentials.

Our SQL team have given access to SQLDB , but there is no way to test if credential is working for DB.

How to test if the credential is working for SQL DB , since we are able to discover windows machines but not the SQL instance / DB

Thanks

0 Helpfuls
  • 272 Views
2 REPLIES 2

sivasankaris
Tera Guru

3 weeks ago

Hi @Nisha30 ,

In ServiceNow ITOM, SQL credentials cannot be validated directly like WMI/SSH credentials. There is no “Validate” option for DB credentials.

SQL credentials are tested only during an actual Discovery run, after:

  1. The Windows server is discovered via WMI

  2. Discovery detects SQL Server

  3. Discovery then attempts to connect to SQL using the DB credential

How to test SQL credentials:

  • Run a Quick / Targeted Discovery on the SQL server IP

  • Check Discovery Status → Logs / ECC Queue

  • Look for SQL probes (SQLServerProbe, JDBCProbe) and related errors

If this works, please mark it as helpful and please Accept my solution...

Best Regards

SIVASANKARI S

0 Helpfuls