Table of Contents
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 #
- Open the Microsoft SQL Server Configuration Manager.
- Select the SQL server instance being connected to.
- Check that both Shared Memory and TCP/IP are enable network protocols for the instance.
NOTE: The SQL server instance will need to be restarted to pick up the change.
