I am trying to deploy a Visual Studio 2013 website with a database to a machine running Windows 7 Enterprise, SQL Server without Management Studio, and IIS 6.1. The data connection works fine in the development environment but is breaking as soon as I move the site to the production environment. I don't know if there is something wrong with my connection string or if SQL Server is not installed/configured properly. How do I determine where the problem is and how would I go about fixing it?
The error I get is:
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)
The connection string is:
Data Source=.\SQL;AttachDbFilename=|DataDirectory|\dbAndon.mdf;Integrated Security=false;Connect Timeout=30
Thanks for the help.