locked
Change default SQL port from 1433/1434 to 9877/9878 RRS feed

  • Question

  • Hi,

    Any one help me how can to Change default SQL port from 1433/1434 to 9877/9878, if i change is the port will be changing in Cluster listener in Always on also ?

    And i am not able find the Port 1434.

    In configuration manager-->Tcp/Ip--> Id address i can see only 1433..

    Saturday, February 2, 2013 4:21 AM

Answers

  • http://support.microsoft.com/kb/823938

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    • Proposed as answer by Fanny Liu Monday, February 4, 2013 10:41 AM
    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:41 AM
    Sunday, February 3, 2013 4:23 AM
  • In addition to Uri's post: You can't change 1434. It is only used for named instances, though, and not even neded for named instances if you connect using the IP port instead of instance name.

    Tibor Karaszi, SQL Server MVP | web | blog

    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:41 AM
    Tuesday, February 5, 2013 7:10 PM
  • TCP port 1434 is used for the DAC (dedicated administrator connection) which might or might not be used.

    The SQL Server Browser service which provides clients with the TCP port number, uses UDP port 1434 and cannot be changed. Yes, that's a UDP (user-datagram protocol) port, not a TCP port, which is probably why you couldn't find it.

     

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:42 AM
    Tuesday, February 5, 2013 9:50 PM

All replies

  • http://support.microsoft.com/kb/823938

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    • Proposed as answer by Fanny Liu Monday, February 4, 2013 10:41 AM
    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:41 AM
    Sunday, February 3, 2013 4:23 AM
  • In addition to Uri's post: You can't change 1434. It is only used for named instances, though, and not even neded for named instances if you connect using the IP port instead of instance name.

    Tibor Karaszi, SQL Server MVP | web | blog

    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:41 AM
    Tuesday, February 5, 2013 7:10 PM
  • TCP port 1434 is used for the DAC (dedicated administrator connection) which might or might not be used.

    The SQL Server Browser service which provides clients with the TCP port number, uses UDP port 1434 and cannot be changed. Yes, that's a UDP (user-datagram protocol) port, not a TCP port, which is probably why you couldn't find it.

     

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    • Marked as answer by Fanny Liu Friday, February 8, 2013 9:42 AM
    Tuesday, February 5, 2013 9:50 PM