ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA UIM : sqlserver windows authentication confirmation

book

Article ID: 237446

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are monitoring our sql DB using windows authentication using sqlserver and sql_response probe and we have a request to disable interactive logon for that specific ID. We need help in deciding if we can confirm the team to diable interactive logon for the ID?

Environment

UIM 20.1 and later

SQLServer

Resolution

Interactive login is authentication to a computer through the usage of their local user account or by their domain account. When the user is logged in, Windows will run applications on behalf of the user and the user can interact with those applications.

if you remove Interactive login ,sqlresponse probe connection,  it will impact the existing SQL connection.