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
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7332 Visits: 72521
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
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26184 Visits: 12501
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4625 Visits: 4965
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
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1712 Visits: 778
interesting questions - cheers
Nakul Vachhrajani
Nakul Vachhrajani
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3321 Visits: 2149
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 (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63568 Visits: 13298
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4614 Visits: 2741
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
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3465 Visits: 3401
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4625 Visits: 4965
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 (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)SSC-Addicted (466 reputation)

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