I got a ASP.NET project with a integrated SQL Express database in to App_data folder like below
When I click on F5 into debug mode and I try out some database operation, I got hit by the following error message.
Connection Error: (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.
Peek into SQL Server Configuration Manager and I see that Named Pipes is enable
So what is wrong with it? My network is OK
After searching the web I realized that SQL Server Agent service got disabled and it can cause problem with database in App_data folder. Open up the Services MMC and confirmed this.
So I enabled the SQL Server Agent service and got it started and my ASP.NET can functions per normal.
No guarantee it will work for your scenario though.