InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:49:40 GMT20http://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxNetstat 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 pidtelnet 127.0.0.1 49467 seems to connect (no error messages, just a blank screen)Sat, 24 Oct 2009 08:35:53 GMTRoberto Filippihttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxCan 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?Sat, 24 Oct 2009 01:45:42 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxCan 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?Sat, 24 Oct 2009 01:42:33 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxYes, it seems to be running. Look at image2Moreover it doesn't connect if I specify the portLook at this. The message in italian means 'server not found or not accessible. Check if DAC is enabled'TnxFri, 23 Oct 2009 02:24:01 GMTRoberto Filippihttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxIs SQL Browser running. Can you connect if you specify the port?Thu, 22 Oct 2009 13:36:55 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxThis is the situation:Thu, 22 Oct 2009 10:19:13 GMTRoberto Filippihttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxAnd the log says that the DAC isn't enabled?Wed, 21 Oct 2009 18:16:44 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxPardon Brian, firt of all I forgoto to thank you for your workThe flag seems to be on, as you well explained to check in logsWed, 21 Oct 2009 16:05:57 GMTRoberto Filippihttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspx[quote][b]noeld (10/21/2009)[/b][hr]Although certainly cool, there should be very little value of this on SQL Express[/quote]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. Wed, 21 Oct 2009 13:41:38 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspx[quote][b]Roberto Filippi (10/21/2009)[/b][hr]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[/quote]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?Wed, 21 Oct 2009 13:39:21 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxAlthough certainly cool, there should be very little value of this on SQL ExpressWed, 21 Oct 2009 10:51:22 GMTnoeldhttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxto me on Express 2008 it still says that DAC isn't enabled, though the log says that it's enabled. I don't understandWed, 21 Oct 2009 03:55:14 GMTRoberto Filippihttp://www.sqlservercentral.com/Forums/Topic806275-59-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/DAC/68334/">Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express</A>[/B]Wed, 21 Oct 2009 00:28:13 GMTK. Brian Kelley