SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Browser & DAC


SQL Server Browser & DAC

Author
Message
mtassin
mtassin
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13306 Visits: 72528
L' Eomot Inversé (6/13/2012)


I suspect the point he is attempting to make is that a competent administrator will succede, not fail, because if he knows the port numbers he can connect using sqlcmd. Service Broker is just one option for knowing the port numbers, there are others.

Incidentally, I think the choice of a Service Broker page as the reference for this question is a bad one; when that page says you can't use DAC it actually means that you can't use DAC if you use SB to get the port numbers. A reference to a page about DAC would have been better.


+1 Smile and this is why I got it wrong. My initial reaction was... "And why can't I? If I know the ports there are always ways to get in."

I would have been very seriously concerned if Microsoft didn't support some way into DAC without the SQL Browser Service.



--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50850 Visits: 13159
mtassin (6/13/2012)
SQLDBA360 (6/13/2012)
Do you mean the SQL Browser Service?


+1 Smile

Personally I've just started working with Service Broker... I was a little confused, but then I realized he meant SQL Browser Smile


Yes, of course. My mistake Blush. I have that disabled (and no Broker).

Edit: I'm crazy:- I abbreviate both As SB - maybe I should stop doing that, it appears to have left me mixing them up.

Tom

muthukkumaran Kaliyamoorthy
muthukkumaran Kaliyamoorthy
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10499 Visits: 4997
In my server the browser is disabled. and the port is 5555


Server is listening on [ 'any' <ipv4> 5555].
Dedicated admin connection support was established for listening remotely on port 1434.

I can able to connect via DAC.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

OzYbOi d(-_-)b
OzYbOi d(-_-)b
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2376 Visits: 778
interesting questions - cheers
Nakul Vachhrajani
Nakul Vachhrajani
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5509 Visits: 2155
muthukkumaran Kaliyamoorthy (6/13/2012)
In my server the browser is disabled. and the port is 5555


Server is listening on [ 'any' <ipv4> 5555].
Dedicated admin connection support was established for listening remotely on port 1434.

I can able to connect via DAC.


@Muthukkumaran: You will be. The question is for non-default ports (i.e. other than 1433 and 1434)

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: General Forum Members
Points: 146320 Visits: 13350
Nakul Vachhrajani (6/13/2012)
muthukkumaran Kaliyamoorthy (6/13/2012)
In my server the browser is disabled. and the port is 5555


Server is listening on [ 'any' <ipv4> 5555].
Dedicated admin connection support was established for listening remotely on port 1434.

I can able to connect via DAC.


@Muthukkumaran: You will be. The question is for non-default ports (i.e. other than 1433 and 1434)


Yes, but chances are big the admin will know which non-default ports are used - or how to find them as Tom explained - so any decent admin should be able to login with DAC. Ergo, the correct answer for this question might not be correct. It depends on the skill of the admin in question :-)


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Nadrek
Nadrek
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10427 Visits: 2752
L' Eomot Inversé (6/13/2012)[hrI suspect the point he is attempting to make is that a competent administrator will succede, not fail, because if he knows the port numbers he can connect using sqlcmd. Service Broker is just one option for knowing the port numbers, there are others.


+1

Any competent administrator, knowing the port numbers, will succeed.

At least some widely skilled administrators have a variety of ways of finding the port numbers, including but not limited to:
1) Hey, JuniorDBA: Try to connect to the instance or the DAC. Start at port 1 and work your way up until you get a connection, then figure out what you connected to.
2) Check your documentation for the port numbers
3) Check the log files for the port numbers
4) SQLPing
5) netstat -a -b -n
6) Sysinternals TCPView
7) NMAP or another port-scanning utility
SQLDCH
SQLDCH
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6149 Visits: 3533
Thanks for the question, Nakul.

----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.
muthukkumaran Kaliyamoorthy
muthukkumaran Kaliyamoorthy
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10499 Visits: 4997
Nakul Vachhrajani (6/13/2012)
muthukkumaran Kaliyamoorthy (6/13/2012)
In my server the browser is disabled. and the port is 5555


Server is listening on [ 'any' <ipv4> 5555].
Dedicated admin connection support was established for listening remotely on port 1434.

I can able to connect via DAC.


@Muthukkumaran: You will be. The question is for non-default ports (i.e. other than 1433 and 1434)


Got it Nakul.

Thanks for info/QA.

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

Ken Garrett
Ken Garrett
SSChasing Mays
SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)SSChasing Mays (608 reputation)

Group: General Forum Members
Points: 608 Visits: 171
Hi Nakul,

I know I am a little late to the party, but it does seem like a competent DBA would check the logs to find the DAC port for each instance.

It seems like a command context should have been included if you were assuming the connection attempt would use the default port (1434).

Thank you for the question.

Ken Garrett
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search