none
SQL Server name list is not showing

    Question

  • Hi,

        I am trying to install SQL server 2005 management studio express. I have installed it many time but some time after installation it does not show server name list. I tried to browse server list but there is no list.

    I am afraid why it is not showing or how i can get it back.

    Please help me out

    Thanks

    Pankaj sharma

    Tuesday, February 28, 2012 2:55 AM

Answers

  • Hi,

    Thank you for the post.

    1. Please check these parts for Browse for Servers (Network Servers) no list issue:
    .The SQL Server Browser service might not be running on the computer running SQL Server.
    .UDP port 1434 might be blocked by a firewall.
    .The HideInstance flag might be set.

    2. You could input the Servername\instancename directly when you logon SQL server connection.

    If there are more inquiries on this issue, please feel free to let us know.

    Regards


    Rick Tan

    TechNet Community Support


    Tuesday, February 28, 2012 5:59 AM

All replies

  • Hi,

    Thank you for the post.

    1. Please check these parts for Browse for Servers (Network Servers) no list issue:
    .The SQL Server Browser service might not be running on the computer running SQL Server.
    .UDP port 1434 might be blocked by a firewall.
    .The HideInstance flag might be set.

    2. You could input the Servername\instancename directly when you logon SQL server connection.

    If there are more inquiries on this issue, please feel free to let us know.

    Regards


    Rick Tan

    TechNet Community Support


    Tuesday, February 28, 2012 5:59 AM
  • Thanks Rick Tan,

         Please Let me know how to run SQL Server Browser service .

        Or how to unblock UDP port 1434 .

      Can you please provide me video for this if it is possible.

    Thanks

    Pankaj Sharma

    • Edited by mpspankaj Tuesday, February 28, 2012 4:21 PM
    Tuesday, February 28, 2012 4:21 PM
  • Hi,

    1.Check SQL Server Browser service via service.msc or Sql server configuration Manager--SQL server services
    2.Check the UDP port 1434
    Connect SQL via server local: run command netstat -ano | find "1434"
    Connect SQL via client remote: Open 1434 port to firewall rule (KB968872) or add exception for the SQL Server Browser service (KB914277)

    SQL Server Browser Service

    Regards


    Rick Tan

    TechNet Community Support

    • Proposed as answer by PiyushV Wednesday, February 29, 2012 8:21 PM
    Wednesday, February 29, 2012 6:37 AM
  • Hi Rick Tan,

          But there is no server configuration Manager installed it is the problem. I tried many setup from net, But it did not installed.

    can you please provide me link for this.

    Thanks

    Pankaj Sharma

    Thursday, March 01, 2012 1:27 AM
  • Hi,

    Thank you for your post.

    Well, check article below include command net start sqlbrowser.

    How to: Start and Stop the SQL Server Browser Service

    If there are more inquiries on this issue, please feel free to let us know.

    Regards


    Rick Tan

    TechNet Community Support

    Thursday, March 01, 2012 3:27 AM