The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Specific Role/permission required for MS SQL Database Instance

Go to solution
Nisha30
Kilo Sage

2 weeks ago

Hi ,

Can anyone assist what exact role is needed to discover SQL DB Instance. We have permissions at Windows server level, but to discover SQL DB at catalog level not sure if that term is correct, what permissions are required.

Thanks

0 Helpfuls
  • 443 Views
1 ACCEPTED SOLUTION

Go to solution
Bhuvan
Kilo Patron
In response to Nisha30

2 weeks ago

@Nisha30 

 

Database catalog is similar to schema map and is a meta data repository for the database. You can lookup in google for simple explanation with example.

 

https://www.servicenow.com/docs/bundle/zurich-it-operations-management/page/product/discovery/concep...

 

Check with your DBA if SQL servers use Windows Authentication or SQL Authentication to be used for discovery. Refer below link to setup Windows credential and Application credential based on the authentication type.

 

https://www.servicenow.com/docs/bundle/zurich-it-operations-management/page/product/discovery/refere...

 

Check the pre-requisites mentioned for discovery as it uses WMI & MS SQL Server table permissions to collect the data. Below is the key section for MS SQL DB discovery,

Bhuvan_0-1756921559178.png

Once pre-requisites are met, you should be able to discover Server and Database CIs using MID Server and populate it in CMDB.

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

View solution in original post

5 REPLIES 5

Go to solution
Nisha30
Kilo Sage
In response to Bhuvan

2 weeks ago

Hi @Bhuvan  Thanks for sharing link but there is no clarity what exact permissions are required to Discover at DB Instance Level. It just says catalog discovery but to discover catalog what permissions must be given .

 

It is confusing from the documents might be I am not awre but if anyone can assist what permissions have to be given to the account so that it can discover the instance level?

 

so the main concern is what role should be provided so that ServiceNow discovery works and populates the relevant DB instance stuffs

 

THanks

0 Helpfuls

Go to solution
Bhuvan
Kilo Patron
In response to Nisha30

2 weeks ago

@Nisha30 

 

Database catalog is similar to schema map and is a meta data repository for the database. You can lookup in google for simple explanation with example.

 

https://www.servicenow.com/docs/bundle/zurich-it-operations-management/page/product/discovery/concep...

 

Check with your DBA if SQL servers use Windows Authentication or SQL Authentication to be used for discovery. Refer below link to setup Windows credential and Application credential based on the authentication type.

 

https://www.servicenow.com/docs/bundle/zurich-it-operations-management/page/product/discovery/refere...

 

Check the pre-requisites mentioned for discovery as it uses WMI & MS SQL Server table permissions to collect the data. Below is the key section for MS SQL DB discovery,

Bhuvan_0-1756921559178.png

Once pre-requisites are met, you should be able to discover Server and Database CIs using MID Server and populate it in CMDB.

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

Go to solution
Bhuvan
Kilo Patron
In response to Bhuvan

2 weeks ago

@Nisha30 

 

Check below article that could help you with MS SQL Discovery pre-requisites and troubleshooting,

 

https://www.servicenow.com/community/itom-articles/servicenow-sql-server-discovery-troubleshooting-t...

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan