trustservercertificate=true possible

[tovoro]

Is it possible to add connection strings like the above somewhere?

I get a "The certificate chain was issued by an authority that is not trusted" error while trying to backup / restore a db to a development mssql server and would like to circumvent that with the connection parameter.

[lowlydba]

I recommend running a variation of Set-DbatoolsInsecureConnection on an as-needed basis to work around this. DBATools handles this as a setting config, so it isn't really necessary to add it to every connection string.

You can see we use this approach during our initial CI setup to fix the same problem:

lowlydba.sqlserver/tests/integration/targets/setup_sqlserver/vars/main.yml

Lines 5 to 6 in bee0380

	Install-Module dbatools -MinimumVersion {{ dbatools_min_version }} -Force -SkipPublisherCheck -AllowClobber
	Set-DbatoolsInsecureConnection -Scope FileUserLocal