none
local sql server name

    Question

  • Hi, I can use my computer's name or "(local)" as the sql server name to login in, but I can' see the sql server name in my local server list. My friend can see my sql server name which is the same as my computer's name in the network server list. How I can see the sql server name in the list? 

    Friday, June 15, 2012 11:39 AM

Answers

  • open Command Prompt

    Type SQLCMD -L

    you will get the list of servers present in your network

    Hope this helps


    • Edited by sushil naik Friday, June 15, 2012 12:38 PM
    • Marked as answer by yanhua.chen Saturday, June 16, 2012 3:05 AM
    Friday, June 15, 2012 12:34 PM
  • You can connect to local default instance of sql with:

    • .
    • (local)
    • localhost
    • <computer name>

    All of the instances installed should show up in the Services Snap-In in the Microsoft Management Console. To get the instance names, go to Start | Run | type Services.msc and look for all entries with "Sql Server (Instance Name)".

    SQLCMD -L
    or
    OSQL -L

    These commands will how the servers available, but sometimes your server may not be listed (if it is hidden). 

    • Edited by irusul Friday, June 15, 2012 2:26 PM
    • Marked as answer by yanhua.chen Saturday, June 16, 2012 3:05 AM
    Friday, June 15, 2012 2:21 PM

All replies

  • open Command Prompt

    Type SQLCMD -L

    you will get the list of servers present in your network

    Hope this helps


    • Edited by sushil naik Friday, June 15, 2012 12:38 PM
    • Marked as answer by yanhua.chen Saturday, June 16, 2012 3:05 AM
    Friday, June 15, 2012 12:34 PM
  • You can connect to local default instance of sql with:

    • .
    • (local)
    • localhost
    • <computer name>

    All of the instances installed should show up in the Services Snap-In in the Microsoft Management Console. To get the instance names, go to Start | Run | type Services.msc and look for all entries with "Sql Server (Instance Name)".

    SQLCMD -L
    or
    OSQL -L

    These commands will how the servers available, but sometimes your server may not be listed (if it is hidden). 

    • Edited by irusul Friday, June 15, 2012 2:26 PM
    • Marked as answer by yanhua.chen Saturday, June 16, 2012 3:05 AM
    Friday, June 15, 2012 2:21 PM
  • Thanks, I has get my sql server name by entering Sqlcmd -L in the cmd.
    Saturday, June 16, 2012 3:11 AM
  • Thanks, I has get my sql server name by entering Sqlcmd -L in the cmd.
    Saturday, June 16, 2012 3:12 AM