Connect to SQl Server from command prompt

Posted 19 July 2016 by Darren Welch

If you find yourself needing to connect to an instance of SQL Server without Sequel Server Management Studio installed you can connect via command Prompt.

To connect using SQL authentication you need to use the following command:

sqlcmd /S /d -U -P

/S = the servername/instance name. Example:

/d = the database name. Example: DB1

-E = Windows authentication.

-U = SQL Server authentication/user. Example: darrenwelch

-P = password that belongs to the user. Example: 123456789


sqlcmd /S /d DB1 -U darrenwelch -P 12345678 


Once connected you can type your query & press enter, then type go and press enter. This will display your results.:

select * from table

Darren Welch


Darren Welch

  19 July 2016

Contact me online



sql database

Has this helped?

If this has saved you time and you are feeling generous, why not buy me a coffee.

Thank You cup of coffee

Related Content