I am not able to connect sql server from cmd

• rajeshjaiswalraj

  SSCrazy

  Points: 2574

  More actions

  January 30, 2013 at 5:46 am

  #394063

  in windows cmd prompt i typed the below command

  First....

  C:\Users\sony>sqlcmd

  1>

  second...

  C:\Users\sony>sqlcmd -U sa -P nuware@123

  Msg 18456, Level 14, State 1, Server SONY-VAIO, Line 1

  Login failed for user 'sa'.

  Thired ...

  C:\Users\sony>sqlcmd -S lpc:SONY-VAIO\MSSQLSERVER01 -U sa -P nuware@123

  1> use master

  2> ;

  Please help me..........

• rajeshjaiswalraj

  SSCrazy

  Points: 2574

  More actions

  January 30, 2013 at 5:49 am

  #1582566

  urgent ......................

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  January 30, 2013 at 5:53 am

  #1582569

  What do you need help with? It is not very clear.

  1st one, your connected to the default instance using a trusted connection

  2nd one, your giving the wrong password for the SA account for the default instance, or instance is in Windows only mode

  3rd one, the ; needs to be on the same line as use master. Also use GO to ensure the command runs on a new line

  1>USE MASTER;

  2>GO

• Ajay Reddy

  Right there with Babe

  Points: 750

  More actions

  January 30, 2013 at 6:09 am

  #1582574

  plz visit this website you will get idea .

  http://msdn.microsoft.com/en-us/library/ms165702(v=sql.105).aspx

  Thanks&Regards
  AJAY REDDY.L