Post reply

SQL Browser service needed for non-standard static port?

  • August 15, 2012 at 2:23 am

    #1525903

    Ness (8/14/2012)

    Re:

    Keep in mind that should you ever need to use the dedicated admin connection, the browser service will need to be running and 1434 will need to be accessible.

    I have just set my browser service to stop and amended my tcp/IP all properies to use dynamic ports and re-started the SQL service and I can connect using DAC - SQL 2008R2 D/E, so I'm not sure that statement is true??

    However, my instance is the default and I always thought you only need the browser service for named instances.

    Have you tested this using a computer other than the server hosting your Instance

  • August 15, 2012 at 3:41 am

    #1525924

    Yep - it works fine... As long as you do not use an alias, and use the server name and it's the default instance it works fine. It listens by default on 1434 but it will listen to any dynamic port that it is assigned on start up. Of course you require 'remote admin connections' to be configured.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

Viewing 2 posts - 16 through 16 (of 16 total)

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