Applicative Credentials for MSSQL

[KhasimKhanP]

Hi folks,

I'm trying to discover MS SQL installed in Windows Machine.

I've defined applicative credentials and win credentials but's throwing the error.

Credentials being used:

User name: sa

[SwamyM]

Hi @KhasimKhanP ,

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,
Swamy

[Kieran Anson]

Hi,

Is your credential record a sa_applicative_credentials 'applicative credentials' type?

Have you attempted to debug the pattern to view the error logs. This'll help with identifying the type of authentication failure occuring

[KhasimKhanP]

Yeah, these are the results

[Selva Arun]

Hi,

Even we are getting an error at the identification, but eventually a record has been created and updated on cmdb_ci_db_mssql_instance table. Could you please go to this table and search for your sql name and open the CI and look out for the related CI or you can do otherway round too, open the windows CI and click on related CI, check if it is available or missing?

This is how our error looks like, could you please paste your error too like this in order to help you?

If you believe the solution provided has adequately addressed your query, could you please mark it as 'Helpful' and 'Accept it as a Solution'? This will help other community members who might have the same question find the answer more easily.

Thank you for your consideration.

Selva