SQLCMD uses windows authentication by default. According to the MSDN documentation, you can change it by adding a -U parameter to the command and then the user name.

The problem is with the password. Is there any way to access the sql server if the password is blank?

sqlcmd -U admin
password:

Whenever I try this and just press enter (indicating that the password is an empty string), I get a message saying that the login failed.

Any suggestions? thanks

sql command-line sqlcmd
Edit
Report