Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

Question

Post reply

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

K. Brian Kelley

SSC Guru

Points: 114642
More actions
October 21, 2009 at 12:28 am

#98251

Comments posted to this topic are about the item Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express
K. Brian Kelley
@kbriankelley

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Roberto Filippi SSC Enthusiast Points: 185 More actions · Answer 1

to me on Express 2008 it still says that DAC isn't enabled, though the log says that it's enabled. I don't understand

noeld SSC Guru Points: 96590 More actions · Answer 2

Although certainly cool, there should be very little value of this on SQL Express

* Noel

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Roberto Filippi (10/21/2009)
to me on Express 2008 it still says that DAC isn't enabled, though the log says that it's enabled. I don't understand

I had to do the work around I mentioned in the article. I also had to do so with appropriate privileges to make those changes. When you check the startup parameters, do you see the indicators that SQL Server Express has picked up the additional trace flag?

K. Brian Kelley
@kbriankelley

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

noeld (10/21/2009)
Although certainly cool, there should be very little value of this on SQL Express

In a regular production environment I would tend to agree. This came out of the comments I saw when folks were trying to use Logon Triggers and not being able to use the DAC. Turns out they were using SQL Server Express because it's what was installed on their systems.

K. Brian Kelley
@kbriankelley

Roberto Filippi SSC Enthusiast Points: 185 More actions · Answer 5

Pardon Brian, firt of all I forgoto to thank you for your work

The flag seems to be on, as you well explained to check in logs

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

And the log says that the DAC isn't enabled?

K. Brian Kelley
@kbriankelley

Roberto Filippi SSC Enthusiast Points: 185 More actions · Answer 7

Roberto Filippi

SSC Enthusiast

Points: 185

October 22, 2009 at 10:19 am

#1069525

This is the situation:

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 8

Is SQL Browser running. Can you connect if you specify the port?

K. Brian Kelley
@kbriankelley

Roberto Filippi SSC Enthusiast Points: 185 More actions · Answer 9

Yes, it seems to be running. Look at image2

Moreover it doesn't connect if I specify the port

Look at this. The message in italian means 'server not found or not accessible. Check if DAC is enabled'

Tnx

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 10

Can you telnet to the port that the DAC is said to be listening on? If you run a netstat -ano on the computer, do you see something listening on that port? Does the PID match that for the SQL Server Express instance?

K. Brian Kelley
@kbriankelley

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 11

Can you telnet to the port that the DAC is said to be listening on? If you run a netstat -ano on the computer, do you see something listening on that port? Does the PID match that for the SQL Server Express instance?

K. Brian Kelley
@kbriankelley

Roberto Filippi SSC Enthusiast Points: 185 More actions · Answer 12

Netstat looks like:

...

TCP 127.0.0.1:49467 0.0.0.0:0 LISTENING 2668

...

(I DON'T KNOW WHAT IT MEANS): TCP [::1]:49467 [::]:0 LISTENING 2668

...

in fact 2668 is the sqlservr.exe's pid

telnet 127.0.0.1 49467 seems to connect (no error messages, just a blank screen)