How to generate an MS SQL Self-Help Tool report

How to generate an MS SQL Self-Help Tool report

Report by selecting the existing host

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug.

  2. Select "MS SQL" on the "Select Monitor" Drop-down.

  3. Select the issue reported, MS SQL, on the "Choose the Host" drop-down.

  4. Click Execute.

  5. After it got executed successfully, share the "DB Debug Response" PDF report.



Report by selecting the host DNS Name

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug.

  2. Select "MS SQL" on the "Select Monitor" Drop-down.

  3. Select "--New Host--" on the "Choose the Host" drop-down.

  4. Provide the hostname (host DNS Name) of the SQL Server-installed machine.

  5. Provide proper credentials.

  6. Click Execute.

  7. After it got executed successfully, share the "DB Debug Response" PDF report.



WarningError message: Login Failed. The login is from an untrusted domain and cannot be used with Report by providing "IPAddress 

Report by selecting "IPAddress "

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug.
  2. Select "MS SQL" on the "Select Monitor" Drop-down.
  3. Select "--New Host--" on the "Choose the Host" drop-down.
  4. Provide the IP address of the SQL Server-installed machine.
  5. Provide proper credentials.
  6. Click Execute.

After successful execution, share the "DB Debug Response" PDF report.

Report by selecting "JTDS JDBC Driver"

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug.
  2. Select "MS SQL" on the "Select Monitor" Drop-down.
  3. Select "--New Host--"  or " Issue reported MS SQL monitor" on the "Choose the Host" drop-down.
  4. If "New Host" is selected, provide hostname/ipaddress of the SQL Server-installed machine
  5. Provide proper credentials.
  6. Select "jTDS JDBC Driver" on the "Driver for SQL Server Connection".
  7. Click Execute.
  8. After it got executed successfully, share the "DB Debug Response" PDF report

Report by selecting "Microsoft JDBC Driver"

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug
  2. Select "MS SQL" on the "Select Monitor" Drop-down
  3. Select "--New Host--"  or " Issue reported MS SQL monitor" on the "Choose the Host" drop-down
  4. If "New Host" is selected, provide hostname/ipaddress of the SQL Server-installed machine
  5. Provide proper credential
  6. Select "Microsoft JDBC Driver" on the "Driver for SQL Server Connection"
  7. Click Execute
  8. After it got executed successfully, share the "DB Debug Response" PDF report


Report by selecting "JDBC URL"

  1. Navigate to Settings → Tools → Self Help Tools → DB Debug.
  2. Select "MS SQL" on the "Select Monitor" Drop-down.
  3. Select "--New Host--"  or " Issue reported MS SQL monitor" on the "Choose the Host" drop-down.
  4. If "New Host" is selected, provide hostname/ipaddress of the SQL Server-installed machine.
  5. Provide proper credentials.
  6. Select "Microsoft JDBC Driver" on the "Driver for SQL Server Connection".
  7. Select the "Use JDBC URL(Optional) check box.
  8. Provide the below-mentioned URL in the "JDBC URL" field.
  9. Click Execute.
  10. After it got executed successfully, share the "DB Debug Response" PDF report.


Quote

Multi-subnet enabled:

jdbc:sqlserver://HOSTNAME:PORT;databaseName=master;multiSubnetFailover=true;

jdbc:sqlserver://HOSTNAME:PORT;databaseName=master;domain=DOMAINNAME;multiSubnetFailover=true;

Windows Authentication:

jdbc:sqlserver://HOSTNAME:PORT;databaseName=master;domain=DOMAINNAME;integratedSecurity=true;authenticationScheme=NTLM;

jdbc:sqlserver://HOSTNAME:PORT;databaseName=master;domain=DOMAINNAME;integratedSecurity=false;authenticationScheme=NativeAuthentication;

Info
Refer to our feature page to learn more about SQL Server monitoring in Applications Manager.