Post reply

Browser Servvice is not required when we assign statis IPs ?

  • May 22, 2011 at 11:58 pm

    #389568

    Hi All,

    If I manually assign static IPs to all the named instances in my sever, then Don't I need to start the Browser Servervise .? Browser Servvice is not required at all in this case.?

    Thanks in advance.

  • May 23, 2011 at 1:35 am

    #1328315

    Joy Smith San (5/22/2011)

    Hi All,

    If I manually assign static IPs to all the named instances in my sever, then Don't I need to start the Browser Servervise .? Browser Servvice is not required at all in this case.?

    Thanks in advance.

    Nope. Static IP can't de-materialise the usage of Browser Service.IPs are not the only thing which you require for a connection to be established with sql server . We also need port . Port on which sql server service runs. By default (for default instances) it is 1433 so sql server is binded with it. But when we install a named instance it uses dynamic port which means sql server could use any port at runtime whichever is asssigned to it by OS and binds its services with it.

    So, By only static IPs you can't achieve the connection.unless you bind the static port as well.

    Sql server Gurus , will put more light on it...

    Regards,

    Sachin Sharma

  • May 23, 2011 at 3:24 am

    #1328362

    Oh Goood... I am extremely sorry.

    Infact I was asking if I allocate static PORT numbers... Not IP Addresses... It's a typo from my side. Sorry.

    Wel, Wot if I allocation static PORT Numbers to all the named instances.?

    Thank you so much for youre quick response.

  • May 24, 2011 at 1:05 am

    #1328851

    Expertrs, I am still waiting for an answer.

    Is Browser service useless if I decide to allocate PORTs manualy to all my names instances .?

    Thanks again.

  • May 24, 2011 at 3:12 am

    #1328883

    if the SQL Server Browser service is not running, the following connections do not work:

    Any component that tries to connect to a named instance without fully specifying all the parameters (such as the TCP/IP port or named pipe).

    Any component that generates or passes server\instance information that could later be used by other components to reconnect.

    Connecting to a named instance without providing the port number or pipe.

    DAC to a named instance or the default instance if not using TCP/IP port 1433.

    The OLAP redirector service.

    Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.

    http://msdn.microsoft.com/en-us/library/ms181087.aspx

    Thanks

  • May 24, 2011 at 7:32 am

    #1329052

    Thanks a lot

  • May 24, 2011 at 10:53 am

    #1329249

    forsqlserver (5/24/2011)

    ...

    DAC to a named instance or the default instance if not using TCP/IP port 1433.

    ...

    Just want to correct this - DAC does NOT use port 1433.

    2005 - http://msdn.microsoft.com/en-us/library/ms189595(SQL.90).aspx

    2008 - http://msdn.microsoft.com/en-us/library/ms189595(v=SQL.100).aspx

    2008 R2 - http://msdn.microsoft.com/en-us/library/ms189595(v=SQL.105).aspx

Viewing 7 posts - 1 through 6 (of 6 total)

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