October 21, 2009 at 12:28 am
Comments posted to this topic are about the item Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express
K. Brian Kelley
@kbriankelley
October 21, 2009 at 3:55 am
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
October 21, 2009 at 10:51 am
Although certainly cool, there should be very little value of this on SQL Express
* Noel
October 21, 2009 at 1:39 pm
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
October 21, 2009 at 1:41 pm
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
October 21, 2009 at 4:05 pm
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
October 21, 2009 at 6:16 pm
And the log says that the DAC isn't enabled?
K. Brian Kelley
@kbriankelley
October 22, 2009 at 10:19 am
This is the situation:
October 22, 2009 at 1:36 pm
Is SQL Browser running. Can you connect if you specify the port?
K. Brian Kelley
@kbriankelley
October 23, 2009 at 2:24 am
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
October 24, 2009 at 1:42 am
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
October 24, 2009 at 1:45 am
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
October 24, 2009 at 8:35 am
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)
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply