<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Brian Kelley
»
Enabling the Dedicated Administrator...
13 posts, Page 1 of 2
1
2
»»
Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express
Rate Topic
Display Mode
Topic Options
Author
Message
K. Brian Kelley
K. Brian Kelley
Posted Wednesday, October 21, 2009 12:28 AM
Keeper of the Duck
Group: Moderators
Last Login: 2 days ago @ 1:13 PM
Points: 6,584,
Visits: 1,790
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
Roberto Filippi
Roberto Filippi
Posted Wednesday, October 21, 2009 3:55 AM
Forum 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
noeld
noeld
Posted Wednesday, October 21, 2009 10:51 AM
SSCertifiable
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260,
Visits: 1,977
Although certainly cool, there should be very little value of this on SQL Express
* Noel
Post #806668
K. Brian Kelley
K. Brian Kelley
Posted Wednesday, October 21, 2009 1:39 PM
Keeper of the Duck
Group: Moderators
Last Login: 2 days ago @ 1:13 PM
Points: 6,584,
Visits: 1,790
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
K. Brian Kelley
K. Brian Kelley
Posted Wednesday, October 21, 2009 1:41 PM
Keeper of the Duck
Group: Moderators
Last Login: 2 days ago @ 1:13 PM
Points: 6,584,
Visits: 1,790
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
Roberto Filippi
Roberto Filippi
Posted Wednesday, October 21, 2009 4:05 PM
Forum 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
K. Brian Kelley
K. Brian Kelley
Posted Wednesday, October 21, 2009 6:16 PM
Keeper of the Duck
Group: Moderators
Last Login: 2 days ago @ 1:13 PM
Points: 6,584,
Visits: 1,790
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
Roberto Filippi
Roberto Filippi
Posted Thursday, October 22, 2009 10:19 AM
Forum 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
K. Brian Kelley
K. Brian Kelley
Posted Thursday, October 22, 2009 1:36 PM
Keeper of the Duck
Group: Moderators
Last Login: 2 days ago @ 1:13 PM
Points: 6,584,
Visits: 1,790
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
Roberto Filippi
Roberto Filippi
Posted Friday, October 23, 2009 2:24 AM
Forum 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 »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
