I just ran into this problem. I've seen other posts and have ran the net start MSSQL$MYDBNAME /c /m /T3600 command to which is responds service is starting and service was started successfully.
However when I run sqlcmd -e it doesn't work. I get a Named Pipes Provider: error. I'm on the actual server where this instance has been installed. I don't think I need named_pipes as we use tcpip.
If I look in services it still shows the service as down.
This is SQL Server 2008 R2 on Windows Data Center 2008 R2.
View Complete Post