SQL Instance Not Connectable

Symptom

Within the Configurator, the SQL Agent instance prerequisites screen displays the following error:

SQL Instance Not Connectable

The Configurator prompts for credentials but fails to clear the error, no matter what credentials are entered.

Cause

Both Shared Memory and TCP/IP must be enabled network protocols for the SQL server instance being connected to.

Resolution

  1. Open the Microsoft SQL Server Configuration Manager.
  2. Select the SQL server instance being connected to.
  3. Check that both Shared Memory and TCP/IP are enable network protocols for the instance.