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.


          New to M365 Manager Plus?
          New to M365 Manager Plus?
            New to RecoveryManager Plus?
            New to RecoveryManager Plus?
              New to Exchange Reporter Plus?
              New to Exchange Reporter Plus?
                New to SharePoint Manager Plus?
                New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • Troubleshooting issues while adding an MS SQL Monitor

                        1. Ensure that the SQL Server is running and accessible. Try connecting to the SQL Server instance via SQL Server Management Studio or DBVisualizer using the same credentials. This step helps diagnose connection issues, ensuring that both the server ...

                      • Using Self Help WMI Tool in Applications Manager

                        Follow the steps given below to troubleshoot errors in monitors or to run WMI queries using the Self Help WMI Tool: Navigate to Admin -> Tools -> Self Help Tools Select the required host from the Choose the Host drop down. The host names of the ...

                      • How to generate a URL Debug Tool Response for troubleshooting?

                        The URL Debug Tool in Applications Manager helps you analyze and troubleshoot the performance of URLs and their components on webpages. It executes the URL, collects performance data, and provides detailed reports for further analysis. Follow the ...

                      • How to troubleshoot MS SQL login failure

                        Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication. Follow the steps given below to resolve this error. 1. Verify Credentials Ensure that the username and password of the SQL account (domain\username) ...

                      • Self monitor Applications Manager using Real User Monitoring

                        We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...
                      Related Products