MSSQL Databases doscovery

[VPN]

Hi All,

We Ran discovery on windows servers which has MSSQL DB's on it.

We are able to discover DB instance but not MSSQL DB's, got read access to DB's.

Could anyone please let me know how to discover MSSQL DB's and where to check exactly.

Regards

Vikas

[VivekSattanatha]

Hi Vikas,

BTW just for your information, you cannot discover Oracle databases by OOB probes. you can only discovery Oracle instance and listeners.

Also from Jakarta ServiceNow is asking us to use patterns instead of probes for discovering Oracle.

Oracle database discovery

The warnings in the logs show that the credential which you are using does not have permission to read the pfiles. The second warning didn't find the oratab file. OOB ServiceNow discovers oratab files in some different locations hardcoded in the probe. if the probe didn't find the file there then it will give this error. The oratab file responsible to find oracle home folder directory. If the probe didn't find the oratab file then some times your instance wont have any oracle versions.

Regards,

Vivek

[Dave Smith1]

This looks like you need credentials set up - a user that's part of the oradba group would be sufficient for read-only access.

Have you looked at the permissions on those files/dirs?

[VPN]

Oracle dba team says read access is granted .ora files and dirs.

Regards,

Vikas