Tag Archives: SQL Server Express

SQL Server named pipes error has nothing to do with the pipe

Posted on by
Reply

I got a ASP.NET project with a integrated SQL Express database in to App_data folder like below

 image

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

image

So what is wrong with it? My network is OK

image

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.

image

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.