SQL Server Performance

MSSQL2K SP4 INSTANCES

Discussion in 'Getting Started' started by stressederic, Apr 24, 2007.

  1. stressederic New Member

    HI Guys and Dolls
    WHY? in enterprise manager and query analyser when trying to connect or register, to a new named instance or a server with two named instances and no default, do I only see the name of the server. I would like to know how to see all instances on my network.

    Yo
  2. Luis Martin Moderator

    When you try to register for the first time with EM you have to write those names.

    Example: Serverinstance1, Serverinstance2.

    I suppose you are using the wizard in EM.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    You can try registering the default instance which will be the servername, if you have tried that already then ensure the SQL Server services for that instance are started successfully.

    OSQL -L is to know about available SQL instances on the network.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page