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 «««1234»»

SQL Server Browser & DAC Expand / Collapse
Author
Message
Posted Wednesday, June 13, 2012 7:53 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
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 :) 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
Post #1315134
Posted Wednesday, June 13, 2012 7:56 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:08 PM
Points: 8,844, Visits: 9,405
mtassin (6/13/2012)
SQLDBA360 (6/13/2012)
Do you mean the SQL Browser Service?


+1 :)

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


Yes, of course. My mistake . 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
Post #1315136
Posted Wednesday, June 13, 2012 8:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:49 AM
Points: 1,155, Visits: 4,643
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
Post #1315163
Posted Wednesday, June 13, 2012 10:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
interesting questions - cheers
Post #1315292
Posted Wednesday, June 13, 2012 10:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:30 AM
Points: 1,422, Visits: 1,838
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
Post #1315307
Posted Wednesday, June 13, 2012 1:03 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:29 AM
Points: 13,741, Visits: 10,716
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1315423
Posted Wednesday, June 13, 2012 2:38 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:09 AM
Points: 869, Visits: 2,399
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
Post #1315488
Posted Wednesday, June 13, 2012 2:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:09 PM
Points: 1,321, Visits: 2,809
Thanks for the question, Nakul.

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

Yeah, well...The Dude abides.
Post #1315490
Posted Thursday, June 14, 2012 12:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:49 AM
Points: 1,155, Visits: 4,643
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
Post #1315639
Posted Thursday, June 14, 2012 3:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 19, 2012 12:50 PM
Points: 385, Visits: 170
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

Post #1316219
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse