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
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4836 Visits: 72518
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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14394 Visits: 12213
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
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2003 Visits: 4942
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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1348 Visits: 778
interesting questions - cheers
Nakul Vachhrajani
Nakul Vachhrajani
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2272 Visits: 2145
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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27573 Visits: 13268
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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1913 Visits: 2729
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
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2230 Visits: 3399
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
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2003 Visits: 4942
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
SSC-Addicted
SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)

Group: General Forum Members
Points: 406 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