Connect SQL local server group using CMD

1149545 pts.
Tags:
CMD
SQL
This is a short but concise question: I just created a MS SQL Local server group. Now, can I connect to that through CMD? If you can just point me in the right direction, that would be great.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Read up on the steps to do this at Microsoft’s post on connecting to SQL server from a command..

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Probably you are asking for sqlcmd utility. Open command Prompt window and browse to the location where the Sqlcmd utility is available on this system. Generally it is under C:\Program Files\Microsoft SQL Server\100\Tools\Binn\ directory/ folder. If you want to connect default instance, pass this one like,

    SQLCMD -S SERVERNAME -E

    For named instance, SQLCMD -S SERVERNAME\INSTANCENAME -E

    For more help, here is a short but good help from Microsoft, https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/log-in-to-an-instance-of-sql-server-command-prompt

    140,720 pointsBadges:
    report
  • Subhendu Sen
    Probably you are asking for sqlcmd utility. Open command Prompt window and browse to the location where the Sqlcmd utility is available on this system. Generally it is under C:\Program Files\Microsoft SQL Server\100\Tools\Binn\ directory/ folder. If you want to connect default instance, pass this one like,

    SQLCMD -S SERVERNAME -E

    For named instance, SQLCMD -S SERVERNAME\INSTANCENAME -E

    140,720 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: