All Collections
Inspectors
Microsoft SQL Server
Microsoft SQL Server | Troubleshooting "Error Locating Server/Instance Specified"
Microsoft SQL Server | Troubleshooting "Error Locating Server/Instance Specified"
Updated over a week ago

Error Locating Server/Instance Specified

Connectivity test failed. Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

This setup issue only occurs in the event that you've entered a named instance in the Inspector template.

966

In most cases, this setup issue indicates that the Inspector was unable to locate the instance specified in the Inspector configuration template. It's important to note that if your goal is NOT to run the inspection against a named instance, you should leave this field blank. Leaving the field empty will prompt the Inspector to run the inspection using the default SQL Server instance name, MSSQLSERVER.

If you're trying to specify a named instanced in the template, it might also need to be in the form 'hostname\instance'.

Did this answer your question?