Skip to content

SQLCHECK

Jump to bottom
Malcolm Stewart edited this page Apr 13, 2021 · 51 revisions

SQL Connectivity Check (SQLCHECK)

This is a command-line tool that will examine the current computer settings and service account settings and produce a text report to the Console window that is useful in determining why a connection may be failing. Normal usage is to redirect the output to a file, e.g.

Usage

     SQLCHECK > c:\temp\SQLCHECK.LOG

Installation

This is a C# application that requires the full .NET 4x framework on Windows.
Download SQLCHECK.EXE to a folder of your choice. It is ready to use.
Note: It requires an Administrative command-line (to read the SQL ERRORLOG file).

Disclaimers

Note: This tool reads local system settings; it does not make any changes.
Note: This tool does not save the report anywhere. You must redirect the output to a file.
Note: This tool does not communicate with any external systems.
Note: This tool does not make a connection to SQL Server, IIS, or other application services.
Note: This tool DOES make some LDAP queries regarding service account properties and to determine related domains that may be used in a cross-domain database connection.

For best results, run this tool on the SQL Server and on the client machine.

Reports

The report is intended mainly to illuminate issues that can result in consistent connection failures.
It can also be useful in identifying client and server properties for other issues, as well.

The report is divided into three main sections:

  • Computer Report
  • Client Security and Driver Report
  • SQL Server Report

The Computer Report

This report lists information about the local computer system, such as:

  • Computer name
  • Windows edition
  • Windows version
  • .NET Framework versions (not .NET Core)
  • Computer role and whether it is part of a domain
  • Information on the current domain
  • Related domains and trusts and whether Selective Authentication is in use
  • Are the Program Files or Common Files folders located on a drive other than C:
  • Is there any low disk condition
  • General network settings, such as TCP Chimney, RSS, and the Ephemeral Port range
  • Network adapters and their properties and offloading settings

The Client Security and Driver Report

The SQL Server Report

Clone this wiki locally