SQL Server Performance


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.

  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

    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
    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