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

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

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
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: