passwords - 将用户名和密码传递给 sqlcmd，

Question

Sqlcmd：错误：Microsoft ODBC Driver 13 for SQL Server：用户“abc.pqr”登录失败..

Begin
Declare @trcustomerid int = 16
Declare @cmd varchar(8000)

set @bcp = 'sqlcmd -S  servername,portname -U abc.pqr -P Password, -W -Q "set nocount on; SELECT * FROM [dbname].[schemaname].[tablename] WHERE id= '+ cast(@trcustomerid as nvarchar(10))+' "'
EXEC master..xp_cmdshell @cmd
END

---

或者 set @bcp = 'sqlcmd -S servername,portname -U abc.pqr -P Password, -W'

也给Sqlcmd: 错误: Microsoft ODBC Driver 13 for SQL Server: Login failed for user 'abc.pqr'..

基本上，sqlcmd 无法解析传递的密码

如何解决？请帮忙

标签： passwordssqlcmd