The Connection Check tool helps you check your SQL Server connections and diagnose why a database user cannot connect to a specific instance. Connection problems are difficult to identify because there are many causes, such as a service not restarting after routine maintenance or an incorrect network configuration setting on the client computer. With this tool, database administrators and Help Desk technicians can quickly and easily assess connection problems.

How the Connection Check tool works

The Connection Check tool allows you to:

  • Check whether you can connect to a SQL Server.
  • Validate the network connection between the client computer and the SQL Server computer including proper network and DNS configuration.
  • Check the status of the SQL Server service.
  • Receive best-practice recommendations for your next steps.
  • Specify alternate SQL login or Windows user credentials to test the database access from the end-user viewpoint.

By default, Connection Checker attempts to connect to the specified SQL Server instance using the credentials of your currently logged on Windows account. Connection Check then performs a series of tests that diagnose what is working on your SQL Server computer. These tests validate the SQL Server configuration and the network connectivity. After Connection Check completes these tests, it provides best-practice guidance regarding the steps required to confirm the diagnoses and repair the problem.

Use the Connection Check tool

To check the connection on a SQL Server instance using the Connection Check tool:

  1. Open the Idera SQL Admin Toolset Launchpad, and then click Connection Check.
  2. Search for and then select the SQL Server instance whose connection you want to check.
  3. Optional. Type the name of the database you want to check.
  4. Type which port you want to use during the test. By default, the Connection Check tool uses port 1433.
  5. Specify the account credentials you want to use to perform the test.
  6. Click the appropriate button for the type of test you want to run.
  7. Use the Test Results pane to review the individual test results as each test runs, and then use the Recommendation pane to review your next steps.

 

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

 

 

  • No labels