Some time there is a need to start SQL Server Service in DAC mode (Dedicated Administrator Connection) (Emergency Mode).
Enable Remote Admin Connection using sp_configure so a dedicated connection can be made when SQL Server Start in single user mode.
sp_configure ‘remote admin connections’ ,1
reconfigure with override
C:Program FilesMicrosoft SQL ServerMSSQL10.BIMSSQLBinn>sqlservr.exe -sBI(instance name) -m
Note : Before stopping SQL Server Service Stop the SQL Server Reporting Service as it will make the first connection (Connection Pooling) as SQL Server Service starts in Single User Mode.
Stop SQL Server Service and start again using option -m from command Prompt.