locked
if hiding sql server instance not connected,why ? RRS feed

  • Question

  • hello everyone,

    for security purpose, i don't want to show my sql servers in network list. 

    when I  used one option hide instance=yes ,but sql server  not connected to  my local machine(remotely). if I change the hide instance= no ,sql server connecting to my local machine(remotely).

    note: it happening only for named instance not for default instance. 


    mastanvali shaik

    Monday, May 19, 2014 12:00 PM

Answers

  • Hello,

    The SQL Server Browser Service is responsable to provide informations about the installed SQL Server instances and the used IP port. If you "hide" an instance, then you have to provide the IP port on your own. If e.g. the port 4833 is used, then you have to address the instance with

    machinename, 4833

    as Server Name in the Connection string / Login Dialog.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Edited by Olaf HelperMVP Monday, May 19, 2014 12:07 PM
    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 12:21 PM
    • Marked as answer by Sofiya Li Monday, May 26, 2014 2:06 AM
    Monday, May 19, 2014 12:06 PM
  • Hello,

    Try providing the port number of each of those instances on the connection. Named instances do not use the standard 1433 port.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 12:21 PM
    • Marked as answer by Sofiya Li Monday, May 26, 2014 2:06 AM
    Monday, May 19, 2014 12:12 PM

All replies

  • Hello,

    The SQL Server Browser Service is responsable to provide informations about the installed SQL Server instances and the used IP port. If you "hide" an instance, then you have to provide the IP port on your own. If e.g. the port 4833 is used, then you have to address the instance with

    machinename, 4833

    as Server Name in the Connection string / Login Dialog.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Edited by Olaf HelperMVP Monday, May 19, 2014 12:07 PM
    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 12:21 PM
    • Marked as answer by Sofiya Li Monday, May 26, 2014 2:06 AM
    Monday, May 19, 2014 12:06 PM
  • Hello,

    Try providing the port number of each of those instances on the connection. Named instances do not use the standard 1433 port.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 12:21 PM
    • Marked as answer by Sofiya Li Monday, May 26, 2014 2:06 AM
    Monday, May 19, 2014 12:12 PM
  • The full story SQL Server Browser Service http://technet.microsoft.com/en-us/library/ms181087(v=SQL.105).aspx

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

    Monday, May 19, 2014 4:10 PM