How to generate MS SQL Self-Help Tool report
Steps to generate MS SQL Self-Help tool report:
Report by selecting existing host
Navigate to Settings → Tools → Self Help Tools → DB Debug.
Select "MS SQL" on the "Select Monitor" Drop-down.
Select the issue reported MS SQL on the "Choose the Host" drop-down.
Click Execute.
After it got executed successfully, share the "DB Debug Response" PDF report.
Report by selecting host DNS Name
Navigate to Settings → Tools → Self Help Tools → DB Debug.
Select "MS SQL" on the "Select Monitor" Drop-down.
Select "--New Host--" on the "Choose the Host" drop-down.
Provide hostname (host DNS Name) of the SQL Server installed machine.
Provide proper credentials.
Click Execute.
After it got executed successfully, share the "DB Debug Response" PDF report.
Report by selecting "IPAddress "
1.Navigate to Settings → Tools → Self Help Tools → DB Debug.
Report by selecting "JTDS JDBC Driver"
- Navigate to Settings → Tools → Self Help Tools → DB Debug.
- Select "MS SQL" on the "Select Monitor" Drop-down.
- Select "--New Host--" or " Issue reported MS SQL montior" on the "Choose the Host" drop-down.
- If "New Host" is selected, provide hostname/ipaddress of the SQL Server installed machine
- Provide proper credentials.
- Select "jTDS JDBC Driver" on the "Driver for SQL Server Connection".
- Click Execute.
- After it got executed successfully, share the "DB Debug Response" PDF report
Report by selecting "Microsoft JDBC Driver"
Navigate to Settings → Tools → Self Help Tools → DB Debug
Select "MS SQL" on the "Select Monitor" Drop-down
Select "--New Host--" or " Issue reported MS SQL monitor" on the "Choose the Host" drop-down
If "New Host" is selected, provide hostname/ipaddress of the SQL Server installed machine
Provide proper credential
Select "Microsoft JDBC Driver" on the "Driver for SQL Server Connection"
Click Execute
After it got executed successfully, share the "DB Debug Response" PDF report
Report by selecting "JDBC URL"
- Navigate to Settings → Tools → Self Help Tools → DB Debug.
- Select "MS SQL" on the "Select Monitor" Drop-down.
- Select "--New Host--" or " Issue reported MS SQL monitor" on the "Choose the Host" drop-down.
- If "New Host" is selected, provide hostname/ipaddress of the SQL Server installed machine.
- Provide proper credentials.
- Select "Microsoft JDBC Driver" on the "Driver for SQL Server Connection".
- Select "Use JDBC URL(Optional) check box.
- Provide the below mentioned URL on "JDBC URL" field.
- Click Execute.
- After it got executed successfully, share the "DB Debug Response" PDF report.
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;
New to ADSelfService Plus?
Related Articles
Troubleshooting MS SQL Monitor Addition Problems
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 ...Troubleshooting 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 the 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) ...