Validation of MS SQL Server login

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 Microsoft SQL server name and port, press enter for default port (1433).

   

4. Enter 'i' for integrated login, enter 's' for standard login:
   
   

   1. Standard Login
      Enter user name and password:
      
      

      1. Success scenario output

         

      2. Failed scenario output
          
   2. Integrated Login
      When using integrated mode the current logged in user will be used for the test.
      
      1. Success scenario output
         
      2. Failed scenario output
         
5. To execute another query enter ‘y’, enter ‘n’ to continue.

6. To run another test type ‘y’, type ‘n’ to quit.

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