SQL Server named pipes error has nothing to do with the pipe
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.
No Responses to “SQL Server named pipes error has nothing to do with the pipe”
RSS feed for comments on this post. TrackBack URL
