I am facing an issue in connecting to SQL Server 2012 with a .net application. SQL Server 2012 database and code are deployed on the same server.
<add key="umbracoDbDSN" value="server=test.test.com;database=testumbraco;user id=testumbraco;password=testumbraco" />
<add key="umbracoDbDSN" value="server=localhost;database=testumbraco;user id=testumbraco;password=testumbraco" />
I tried same credentials with SQL Server Management Studio 2012/2014 and these are working fine locally and from remote machine.
The network path was not found
Create a second test virtual directory:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)