I am currently trying to connect to mssql from the remote server using sqlcmd utility. The command used:
sqlcmd -S <ip> -U my/Username.admin01 -P <password -C
However, when I run the sql command, I received following error:
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'myUsername.admin01'..
where it removed the "/" in my command. As I checked the existing DB, the username my/Username.admin01 is created using windows authentication, instead of normal sql server authentication, which I believe windows authentication uses the AD in the domain.
Is there any way to access the mssql using sqlcmd utility for the username created by the windows auth? Thanks.