How to: Log In to an Instance of SQL Server (Command Prompt)

To test connectivity to an instance of SQL Server, use the sqlcmd utility.

  1. From a command prompt, enter the following command to connect by using Windows Authentication:

    sqlcmd [ /E ] [ /S servername ]
    
    

  1. From a command prompt, enter the following command to connect by using Windows Authentication:

    sqlcmd [ /E ] /S servername\instancename
    
    

Community Additions

ADD
Show: