I am new to sqlcmd and I want to create a new user. I have done the following:
1> CREATE LOGIN FYI_DBA WITH PASSWORD = 'V_2017' 2> go 1> CREATE USER FYI_DBA FOR LOGIN FYI_DBA 2> go
Then from cmd prompt I ran the following:
sqlcmd -s LOCALHOST -U 'FYI_DBA' -P 'V_2017' Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user ''FYI_DBA''..
What am I doing wrong?