How to generate an MS SQL Self-Help Tool report
Report by selecting the 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 the 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 the 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.
Error message: Login Failed. The login is from an untrusted domain and cannot be used with Report by providing "IPAddress Report by selecting "IPAddress "
- 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 the IP address of the SQL Server-installed machine.
- Provide proper credentials.
- Click Execute.
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 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 "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 the "Use JDBC URL(Optional) check box.
- Provide the below-mentioned URL in the "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 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) ...How do I resolve certificate validation failures when "Validate Server Certificate" is enabled in the MS SQL monitor?
Issue When Validate Server Certificate is enabled, the MS SQL monitor may fail with the following error: MS SQL : Certificate validation failed. The hostname in the SQL Server's certificate does not match the configured hostname. Please ensure the ...