MS SQL discovery cerdentials

Nisha30
Kilo Sage

12 hours ago

Hi Team,

 

Can anyone tell what credentials to be setup for discovering MS SQL DB instances . 

 

The DB Account are Windows Authenticated based . We have Windows Service Account .

 

So what has to be set up specifically for MS SQL piece ? or do we not need to set up any as they are WIN authentication based.

 

Thanks

0 Helpfuls
  • 96 Views
1 REPLY 1

Steven Coda
Tera Contributor

9 hours ago

Hello Nisha30, 

 

In my experience, when we set up Discovery for MS SQL years ago, we worked closely with our Windows and Database Admin teams to confirm that the Windows credential had sufficient permissions on both the server host and the SQL instance. We used a domain-level Windows Service Account.

We also reviewed the ServiceNow documentation on Microsoft SQL Server and Cluster Discovery:: Microsoft SQL Server and Cluster discovery.  For our environment, we didn’t need an additional SQL-specific credential because Windows Authentication handled access.

If you’re having issues, check your discovery logs to identify where it fails and engage your SQL Admin team. You should still be able to discover basic SQL instance details without enabling DBA reporting: Database Administrator (DBA) report discovery.

 

Hope this helps

0 Helpfuls