Ports that DBAs Need to Know

Question

Ports that DBAs Need to Know

yup

SSCarpal Tunnel

Points: 4490
More actions
October 27, 2011 at 9:41 pm

#390709

Comments posted to this topic are about the item Ports that DBAs Need to Know

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Thanks for the overview.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

M&M SSC-Insane Points: 21700 More actions · Answer 2

Thanks Yusuf, very useful information, I've stored it in briefcase.

M&M

David Bird SSCarpal Tunnel Points: 4669 More actions · Answer 3

David Bird

SSCarpal Tunnel

Points: 4669

October 28, 2011 at 7:15 am

#1400616

Great reference sheet

David Bird

SL10 Old Hand Points: 307 More actions · Answer 4

Already listed among other entries, however I believe it should be mentioned separately:

TCP 445 - named pipes.

william-375754 SSC-Addicted Points: 498 More actions · Answer 5

This is a great list to keep handy. One correction, most examples I've seen for mirroring use TCP 5022, and this is the port the wizard will auto fill for database mirroring.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 6

Thanks for this excellent article.I added it to my favorites.

I hope you will excuse me but i think i have found a tiny problem in it ( so tiny that i am ashamed ) : in the left column , you wrote MsDTC instead MSDTC./

I hope you will write quickly articles as useful and clear as this one

M&M SSC-Insane Points: 21700 More actions · Answer 7

william-375754 (10/28/2011)
This is a great list to keep handy. One correction, most examples I've seen for mirroring use TCP 5022, and this is the port the wizard will auto fill for database mirroring.

I too had this doubt but this link says otherwise.

link

M&M

Johan Bijnens SSC Guru Points: 135361 More actions · Answer 8

Well documented overview , Yusuf.

Always nice to have a cheat sheet at hand.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

SQLdba-473999 SSCrazy Points: 2761 More actions · Answer 9

The link to the article does not work. Anyone know where to find it?

Zapper SSC Veteran Points: 230 More actions · Answer 10

The link is no longer working. Was there a reason this article was removed???

yup SSCarpal Tunnel Points: 4490 More actions · Answer 11

We are working on this, it should be up sooner than later.

yup SSCarpal Tunnel Points: 4490 More actions · Answer 12

This is online now.

http://www.sqlservercentral.com/articles/networking/75481/

yup SSCarpal Tunnel Points: 4490 More actions · Answer 13

Forgot to add NP, 🙁 again

Will add this in next update.

rschantz Newbie Points: 3 More actions · Answer 14

Any plans to update this with Mirroring ports like 5022 or additional changes needed by newer versions of SQL Server? This is a great cheat sheet as well as a quick reference document used by all my team.

Thanks