How to test MSSQL credential for Discovery

Nisha30
Kilo Sage

5 hours 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
  • 68 Views
1 REPLY 1

sivasankari
Tera Guru

4 hours 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