The MS SQL Server login can be either standard or integrated user.
Important
If the MS SQL Server login field is left blank, then the Windows user will serve to connect the MS SQL Server. In this case Windows user must pass all validation steps as described in Validation for integrated user section.
Validation for standard user
- Open the command prompt from the <PATROL_HOME>\mssql\x64 directory.
- Type the following command:
SQLCollector.exe -diag check_sql_conn Enter the Microsoft SQL server name and port, press enter for default port (1433).

- Enter 'i' for integrated login, enter 's' for standard login:

- Standard Login
Enter user name and password:

Success scenario output

- Failed scenario output
- Integrated Login
When using integrated mode the current logged in user will be used for the test.
- Success scenario output

- Failed scenario output

- To execute another query enter ‘y’, enter ‘n’ to continue.
- To run another test type ‘y’, type ‘n’ to quit.
Note
To use another integrated login, run SQLCollector.exe using the RUNAS command
Runas /user:<domain_name>\<user_name> "SQLCollector.exe -diag check_sql_conn"
For example, to test the integrated user BMC-6YS58W1\patrol do the following:
Runas /user: BMC-6YS58W1\patrol "SQLCollector.exe -diag check_sql_conn"

- Another CMD window will pop-up as BMC-6YS58W1\patrol user. Select integrated mode.