Sqlcmd from sql authentication command line

Question

SQLCMD uses Windows Authentication by default. According to the MSDN documentation, you can change it by adding the -U option to the command and then the username.

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

sqlcmd -U admin
password:

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

Any suggestions? thank

Answer 1

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/15e4a7c0-6547-44e8-9e25-4f14c12570ca , sqlcmd . osql.

sqlcmd :

" -U -P , SQLCMDPASSWORD , sqlcmd . -P sqlcmd (NULL)."

, !