Unable to run Invoke-SqlCmd against SQL Server 2016

[Beakerboy]

I have the simplest yml file possible:

services:
  - mssql2016
image:
  - Visual Studio 2017
install:
  - ps: Invoke-Sqlcmd -Username sa -Password "Password12!" -Query "CREATE DATABASE mydrupalsite"

The error message is:

Invoke-Sqlcmd : Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

I’ve also tried the Visual Studio 2015 image with the same result.

I’ve also tried moving the call to a separate powershell script and calling that with:
- ps: powershell .\dev\appveyor\mssql2016.ps1

The file contains the line:
Invoke-Sqlcmd -Query "CREATE DATABASE mydrupalsite" -ConnectionString "(local)\SQL2016;Database=master;User ID=sa;Password=Password12!"

[Beakerboy]

I’m able to get around this by skipping powershell and using the basic command line with:
- cmd: sqlcmd -U sa -P Password12! -Q "CREATE DATABASE mydrupalsite"

[FeodorFitsner]

Calling .ps1 with powershell should work as well. Try changing command prefix to cmd::

- cmd: powershell .\dev\appveyor\mssql2016.ps1