Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
SQL Server name list is not showing

Answered SQL Server name list is not showing

  • Tuesday, February 28, 2012 2:55 AM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Tuesday, February 28, 2012 5:59 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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 4:21 PM
     
     
    Sign In to Vote
    0

    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
    •  
     
  • Wednesday, February 29, 2012 6:37 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    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
    •  
     
  • Thursday, March 01, 2012 1:27 AM
     
     
    Sign In to Vote
    0

    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 3:27 AM
    Moderator
     
     
    Sign In to Vote
    0

    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