MS SQL discovery cerdentials

[Nisha30]

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

[Steven Coda · Accepted solution]

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

[Nisha30]

Thanks All,

Yeah we are going for Windows Service Account and giving it permission at relevant area as well.

[Steven Coda]

@Nisha30 - Best of luck with the SQL Discovery!  I would recommend reviewing @Harish Bainsla  posted video, it was very informative and insightful.  I learned a lot I never knew about SQL after listening to it

[Harish Bainsla]

Hi @Nisha30  already @Steven Coda  answer and second way you can use applicative credential. for more watch below video 

https://youtu.be/anyXEd0MUUU?si=3hnLCamMPk0JT-TV

if my answer helps you mark helpful and accept solution