Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express Expand / Collapse
Author
Message
Posted Saturday, October 24, 2009 1:42 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, September 26, 2014 7:52 AM
Points: 6,624, Visits: 1,873
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #808266
Posted Saturday, October 24, 2009 1:45 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, September 26, 2014 7:52 AM
Points: 6,624, Visits: 1,873
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #808268
Posted Saturday, October 24, 2009 8:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 29, 2009 12:11 PM
Points: 9, Visits: 42
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)

Post #808301
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse