locked
tcp port RRS feed

  • Question

  • Hi all,

    can i change the defalut tcp port number (1433) in ms sql server..?

    Thursday, May 23, 2013 3:19 PM

Answers

All replies

  • Yes, you can

    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

    Thursday, May 23, 2013 3:32 PM
  • Yes, you can change the default port. But sql server browser service uses the default port 1433. So if you are not able to connect with server name after you change the default port then you need to provide the port number along with the server name like <servername>,<port number>

    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.


    • Edited by rksqldba Thursday, May 23, 2013 3:34 PM
    Thursday, May 23, 2013 3:34 PM
    • Proposed as answer by Olaf HelperMVP Thursday, May 23, 2013 3:54 PM
    • Marked as answer by Fanny Liu Thursday, May 30, 2013 10:52 AM
    Thursday, May 23, 2013 3:38 PM