How to connect to SQL Server from command prompt with Windows authentication

Question

How can I connect to SQL Server from command prompt using Windows authentication   This command  Sqlcmd -u username -p password    assumes a username  amp  password for the SQL Server already setup  Alternatively how can I setup a user account from command prompt   I ve SQL Server 2008 Express on a Windows Server 2008 machine  if that relates

User · Answer

here is the commend which is tested  Sqlcmd -E -S  server name  -d  DB name  -i  SQL file path    -E stand for windows trusted

User · Answer

This might help        SQLCMD -S SERVERNAME -E

User · Answer

You can use different syntax to achieve different things  If it is windows authentication you want  you could try this   sqlcmd  S   d  -E   If you want to use SQL Server authentication you could try this   sqlcmd  S   d -U -P    Definitions    S   the servername instance name  Example  Pete s Laptop SQLSERV  d   the database name  Example  Botlek1 -E   Windows authentication  -U   SQL Server authentication user  Example  Pete -P   password that belongs to the user  Example  1234   Hope this helps

User · Answer

After some tries  these are the samples I am using in order to connect   Specifying the username and the password   sqlcmd -S 211 11 111 111 -U NotSA -P NotTheSaPassword   Specifying the DB as well   sqlcmd -S 211 11 111 111 -d SomeSpecificDatabase -U NotSA -P NotTheSaPassword

User · Answer

type sqlplus  as sysdba  in cmd for connection in cmd prompt

User · Answer

Try This   --Default Instance  SQLCMD -S SERVERNAME -E  --OR  --Named Instance  SQLCMD -S SERVERNAME INSTANCENAME -E  --OR  SQLCMD -S SERVERNAME INSTANCENAME 1919 -E  More details can be found here

[sql] How to connect to SQL Server from command prompt with Windows authentication

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008

Examples related to command-prompt