ITADN

MS SQL Server adapter -U/-P flags passed in SQL Server connection string

#215Openmichael-duren 创建于 2025-10-27
M
michael-durencommented
```lua vim.g.dbs = { { name = "DEV", url = "sqlserver://HOSTNAME:1433/DBNAME", }, } ```` ``` Connecting to db DEV... Error detected while processing function <SNR>38_method[2]..43[30]..46[7]..17[16]..function <SNR>38_method[2]..43[30]..46[7]..17[15]..db_ui#notifications#error[1]..<SNR>42_notification[17]..<SNR>42_notification _nvim_notify: line 17: Error connecting to db DEV DB exec error: Sqlcmd: The -E and the -U/-P options are mutually exclusive. ``` This happens regardless if I'm adding a connection manually or adding it to my config. I'm using dadbod-ui, but if I just try the command I get the same output: `The -E and the -U/-P options are mutually exclusive.` It seems to pass the -U/-P flags even though my connection string doesn't have a username and password and per the documentation it should add the integratedSecurity if I omit the username/pwd. ```` Supported query parameters are `authentication`, `secure` and `trustServerCertificate`, which correspond to connection properties of the same name. The `authentication` property is only supported when using `go-sqlcmd`. ```` Is there something I'm doing incorrectly? `SQLCMD.EXE 16.0.1000… C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\SQLCMD.EXE`
4 条评论