A network-related or instance-specific error occurred while establishing a connection to SQL Server on EPIServer installation

  • Updated

When installing an installation of EPIServer on a local machine the following error message is thrown by the site on compilation.

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: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.) (Microsoft SQL Server, Error: 2)

This error message indicates that the localdb may not be installed onto the server hositng the site. Please ensue that the appropriate version of sql is selected as the link below is specific for sql server 2012.

https://www.microsoft.com/en-us/download/details.aspx?id=29062

Screen capture of localdb download option