Validation of Ms Sql Server Login - Documentation for Bmc Patrol for Microsoft Sql Server 9.6

The MS SQL Server login can be either standard or integrated user.

Validation for standard user

1. Open the command prompt from the <PATROL_HOME>\mssql\x64 directory.
2. Type the following command:
   SQLCollector.exe -diag check_sql_conn




3. Enter the properties of the SQL Server instance that you want to check.

4. The SQL Server connection status and query execution status displayed.
   1. Success scenario output
      

      In the above example, 

      Connection to SQL instance vw-tlv-ngp-dv13\A2 is open indicates that the connection is established successfully.

      Query execution success indicates that the entered query is executed successfully.

   2. Failed scenario output
      

Validation for integrated user 

1. Open the command prompt from the <PATROL_HOME>\mssql\x64 directory
2. Type the following command
   Runas /user:<domain_name>\<user_name> "SQLCollector.exe -diag check_sql_conn"

    

3. Enter the password
   
4. The following message is displayed in case of a failure:
   
   This message indicates that PATROL will fail to start external collector to collect data from SQL Server instance with this integrated user. Reslove this issue, before using integrated user for monitoring.
5. A window with the RUNAS user opens in case of a successful login
   

   In the above example, a window with the BMC-6YS58W1 (RUNAS user) can be seen.

6. Enter the properties of the SQL Server instance that you want to check.

   Important

   Use the same username and password combination that was used for the RUNAS command.

7. The SQL Server connection status and query execution status displayed.

   1. Success scenario output
       
      In the above example, 
      Connection to SQL instance BMC-6YS58W1 is open indicates that the connection is established successfully.
      Query execution success indicates that the entered query is executed successfully.

   2. Failed scenario output