Error 40 - Could Not Open A Connection To SQL Server

A Network 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.

What it means

The Recast Management Server is not able to connect to the configured SQL server for some reason. Because of this inability to connect, the Management Server will not function correctly.

How to resolve the issue

  • If the SQL database is located on a separate computer from your Recast Management Server verify that the SQL server is powered on, is online and is reachable from your Recast Management Server computer (try pinging the specified computer).

  • Verify that the correct server address and port are specified in the appsettings.Production.json file. This file is located at C:\Program Files(x86)\Recast Software\Recast Management Server\appsettings.Production.json and can be viewed and edited with a text editor.

Additional Information

Information on configuring SQL Server is located here: Configuring SQL Server