Installing SQL server with DBAtools

[AlexDBA012]

Hi

I'm looking to automate installing SQL 2017 as part of an automated server build script. I think I've got the syntax right now but it's asks for conformation and I'd like to remove it. Does anyone know if that's possible? I've tried adding confirm:$false but that doesn't make difference

PS C:\Users\SQLInstall> Install-DbaInstance -sqlinstance $virtualmachine -version 2017 -credential $cred -path "\\Server1\SQL Server\SQL2017\
SQL2017_ENT_x64" -ConfigurationFile "\\server1\SQL2017\SQL2017_ENT_x64\ConfigurationFile.ini"

Confirm
Are you sure you want to perform this action?
Performing the operation "Install 2017 from \\pr-dep-03\apps$\SQL Server\SQL2017\SQL2017_ENT_x64\setup.exe" on target "Server-SQL-01".
[Y] Yes  [A] Yes to All  [N] No  [L] No to All  [S] Suspend  [?] Help (default is "Y"): a

[nvarscar]

Adding -Confirm:$false would remove the necessity to confirm the actions

[AlexDBA012]

I've tried that and it made no difference

[nvarscar]

That's how it should work. Please provide your full statement with the confirm parameter, and the value of $ConfirmPreference variable in your powershell session.

[potatoqualitee]

Agreed, according to the code you provided, it should be

Install-DbaInstance -SqlInstance $virtualmachine -Version 2017 -Credential $cred -Path "\Server1\SQL Server\SQL2017_ENT_x64" -ConfigurationFile "\server1\SQL2017\SQL2017_ENT_x64\ConfigurationFile.ini" -Confirm:$false

Or another way to put it

$params = @{
  SqlInstance = $virtualmachine
  Version = "2017"
  Credential = $cred
  Path = "\Server1\SQL Server\SQL2017_ENT_x64"
  ConfigurationFile = "\server1\SQL2017\SQL2017_ENT_x64\ConfigurationFile.ini"
  Confirm = $false
}
Install-DbaInstance @params