MSSQL Database Discovery

Chavan AP
Kilo Sage

‎06-24-2020 01:41 PM

Hi Guys,

I am discovering mssql database running on windows server xyz.

so there are more the 20+ database running on the xyz.

but when I run individual discovery on server Xyz it only gives me database instance name as MSFT SQL Instance

instead of all the databases running on the same.

 

I have also given sysadmin access on the database to service account still it didn't help.

 

Please help me understand and resolve the issue.

 

@ashutoshmunot  @doug.schulze @Dave Hertel @Chuck Tomasi 

 

any commets?

Glad I could help! If this solved your issue, please mark it as ✅ Helpful and ✅ Accept as Solution so others can benefit too.*****Chavan A.P. | Technical Architect | Certified Professional*****
Labels:
0 Helpfuls
  • 1,783 Views
4 REPLIES 4

doug_schulze
ServiceNow Employee
ServiceNow Employee

‎06-24-2020 02:02 PM

Are they individual instances running on the host? Sounds as if there is only one sql server running and you may be having issues with collecting the catalog information.

0 Helpfuls

Chavan AP
Kilo Sage
In response to doug_schulze

‎06-24-2020 02:22 PM

yes we are not able to collect catalog info as well, please help me how to resolve this issue

Glad I could help! If this solved your issue, please mark it as ✅ Helpful and ✅ Accept as Solution so others can benefit too.*****Chavan A.P. | Technical Architect | Certified Professional*****
0 Helpfuls

doug_schulze
ServiceNow Employee
ServiceNow Employee
In response to Chavan AP

‎06-25-2020 03:08 PM

Ok cool, then just (if you haven't already) have the credentials in the instance as outlined here. AND be sure you are using the pattern for MSSQl and not probes/sensors!

0 Helpfuls

Vivektietsood
Tera Guru
Tera Guru

‎11-01-2020 12:57 PM

were you able to resolve this ?

It looks to me a credential issue also. 

 

0 Helpfuls