Post reply

Instance name is not showing up in SQL Server List

  • March 11, 2007 at 10:48 pm

    #75136

    Hi All

    We have an SQL Server which is not showing up its name when we try to search it in Query Analyzer' servers list or when we try with EM. But if we manually enter its name then we are able to connect it with either QA or EM.

    Can anybody please explain what might gone wrong..

    Thanks ,

    Shekhar

  • March 12, 2007 at 2:08 am

    #694305

    Hi,

    Is the SQL Browser service running on that machine? Could anything be blocking UDP port 1433 as this is the default port SQL Browser uses to report on what versions and instances of SQL Server are running on the machine?

    - James

    --
    James Moore
    Red Gate Software Ltd

  • March 12, 2007 at 4:08 am

    #694315

    Hi James

     thanx for you quick reply. MS SQL Server 2000 is installed on the box.. and MSSQLServer & SQLSERVERAGENT Services are running properly.

    I did not find any service named SQL Browser...

     

    Thanks ,

    Shekhar

  • March 12, 2007 at 4:42 am

    #694319

    In the Server Network Utility, is it listening on named pipes and/or TCP? If it is only TCP, verify in the TCP properties that it does not have the Hide Server checkbox enabled.

    Do the instances show up when you hit the ellipses button next to the drop-down button?

    Ron

  • March 12, 2007 at 7:53 am

    #694362

    yeah .. "Hide Server" is not checked..

    Thanks ,

    Shekhar

Viewing 5 posts - 1 through 4 (of 4 total)

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