I'm getting the following error when trying to load an Asp.NET MVC App on IIS 7 with Sql Server 2008 Express. The App uses Linq to SQL.
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)
I've done some searching and all answers point to enabling TCP connections in Sql Server Configuration which I have done to no avail.
The connection string I am using is:
The catch. I have another app that already could talk to the Sql Server just fine. Even before playing around with the Sql Server Configuration Settings.
The other app uses the following connectionstring:
Data Source=SERVERNAME\SQLEXPRESS;Initial Catalog=OtherDbName;Integrated Security=True;Persist Security Info=False;Connect Timeout=120
I've tried this connectionstring on the app that isn't working and it still doesn't work.
Please help. I think i'm about to go crazy