MSSQL Discovery - Optional Applicative Credentials

[Josh P1]

Hey all,

We are going through trying to evaluate the discovery requirements and how to meet those requirements.  However, I am having a bit trouble understanding some of the documentation when it comes the credentials sections.  In some cases the docs mention that the certain credentials are optional, but I do not understand under what circumstances the credentials are optional or the effects of omitting the optional credentials.  For example, under MSSQL server discovery there are entries for Applicative Credentials and the second indicates the credentials are optional, but I am failing to understand what is optional about the credentials.  If we are choose to not set the credentials, what are we omitting (if anything) from the discovery process?

Thanks,

Josh

[DaveHertel]

Hi Josh - it all depends on the type of thing needing to be discovered.  MS-SQL needs specific creds for that product, but MS-IIS doesn't need unique creds to be interrogated.  

Hope that helps..

[Rahul Priyadars]

To achieve this Applicative Creds is needed for SQL Server.

The pattern uses applicative credentials to run the MSSQL command to retrieve the following information:

• Version count
• cpu_ids
• Server properties

The credentials need access to the following:

• A database user that can access these MSSQL tables: sys.dm_exec_sessions and sys.dm_os_schedulers, SERVERPROPERTY.
• The CI Type MSFT SQL Instance.

Regards

RP

[Shridhar S Mal2]

Hi All, Whether applicative credentials can be domain users which are mapped in SQL logins in SQL Database instance ? For example "domain\user" which is mapped on SQL logins as windows authentication has access to all of the below sys.dm_exec_sessions and sys.dm_os_schedulers, SERVERPROPERTY