vim-dadbod icon indicating copy to clipboard operation
vim-dadbod copied to clipboard

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

Open michael-duren opened this issue 2 months ago • 4 comments

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

michael-duren avatar Oct 27 '25 16:10 michael-duren