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 Wednesday, October 21, 2009 12:28 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
Comments posted to this topic are about the item Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

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 #806275
Posted Wednesday, October 21, 2009 3:55 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
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
Post #806340
Posted Wednesday, October 21, 2009 10:51 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
Although certainly cool, there should be very little value of this on SQL Express


* Noel
Post #806668
Posted Wednesday, October 21, 2009 1:39 PM


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
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, 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 #806760
Posted Wednesday, October 21, 2009 1:41 PM


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
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, 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 #806764
Posted Wednesday, October 21, 2009 4:05 PM
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
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

Post #806859
Posted Wednesday, October 21, 2009 6:16 PM


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
And the log says that the DAC isn't enabled?


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 #806904
Posted Thursday, October 22, 2009 10:19 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
This is the situation:


  Post Attachments 
Immagine1.JPG (25 views, 109.23 KB)
Immagine2.JPG (17 views, 23.55 KB)
Immagine3.JPG (15 views, 40.61 KB)
Post #807298
Posted Thursday, October 22, 2009 1:36 PM


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
Is SQL Browser running. Can you connect if you specify the port?


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 #807424
Posted Friday, October 23, 2009 2:24 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
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




  Post Attachments 
Immagine4.JPG (8 views, 68.48 KB)
Post #807676
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse