Archive

Archive for the ‘DAC’ Category

How to make Dedicated Admin Connection to SQL Server in Single User Mode

May 3, 2010 Leave a comment

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 Files\Microsoft SQL Server\MSSQL10.BI\MSSQL\Binn>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. 

 To create a DAC Connection open a new commond prompt and connect to sqlcmd 

 

  

Stop SQL Server Service and start again using option -m from command Prompt.

 

  

  
 
 

 

 

Categories: DAC