Upgraded from VS 2008 -> VS 2010. Can't Connect to SQL Server in Staging Environment
- by Bob Kaufman
I have a test application written in C#/ASP.NET that I've developed using Visual Studio 2008 Professional/.NET 3.5 which connects to a local SQL Server 2008 Express instance. I upgraded the development machine to Visual Studio 2010 Professional maintaining .NET 3.5 and everything in the development environment continues to work correctly. Upon deployment of the new app to an internal staging machine, that app cannot connect to its local SQL Server 2008 Express database. I get the customary "server not found" error:
A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible...
Does something need to be upgraded on the staging machine to be able to host a Visual Studio 2010/.NET 3.5 application?