Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I tried but problem still exist. In error log Message: " Error: 17813, Severity: 20, State: 1. The requested service has been stopped or disabled and is unavailable at this time. The connection has been closed. [CLIENT: xxx.xxx.9.xxx] " and during connection from sqlcmd: "Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired. "
–
JP ChauhanSep 5 '12 at 13:39

how to enable DAC? I tried to connect from sqlcmd mode and Management studio only . Is there any another mechanism to enable the DAC. While connecting from Managment studio "Microsoft Error 64 reported"
–
JP ChauhanSep 5 '12 at 13:48

Open sql server configuration manager on the sql server, look for server protocols, look for named pipes, enable it. Right click an select properties, copy the named pipe string (for later),now restart the sql server service. Open management studio, paste the named pipe string in the server name box. Connect. This should work
–
Edward DortlandSep 5 '12 at 13:58