How do I deploy my Visual Studio Web Site to a production and maintain SQL connectivity

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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
DISCLAIMER: I admit I am new to ASP.Net site development and deployment.   I gave done SQL Server deployment with Desktop Apps. I have also done Classic ASP development.

 The deployment target will require IIS and SQL Server installed.  Web sites that use scriptiung or ASP code will require a web server to execute the server sire scripts/code.

How do I determine where the problem is and how would I go about fixing it?

You will need to update the connection string to match the SQL server on the target site

One way to test the SQL Server is to set up an DSN (ODBC Concection) to the server to test the server. I used DSNs in the past to make deployment of my ASP sites and Apps easier. Not sure if that is considered Best Practice with .NET.
OhioWoodWrightAuthor Commented:
Thanks Boyd,

IIS  6.1 and ASP 4.0 are installed and I'm told SQL Server is installed but I can not find the SQL Server Management Studio. I think what I'm trying to find is the connection string for the installed SQL Server. The person who set the server up doesn't seem to know and I'm at a bit of a loss as to next steps.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Data Source=.\SQL
The dot (.) means localhost so if the SQL Server isn't installed in the same server would never connect. Replace the dot by the servername.

I'm told SQL Server is installed but I can not find the SQL Server Management Studio.
Having the SQL Server Management Studio (SSMS) doesn't mean that SQL Server is installed. SSMS is only a tool for administering and deployment for SQL Server. If you want to know if SQL Server is installed you need to find SQL Server Configuration Manager. With that tool you'll see all the SQL Server instances installed locally.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.