search

appveyor / website

AppVeyor CI public website.
https://www.appveyor.com
MIT License
106 stars 300 forks source link

Unable to run Invoke-SqlCmd against SQL Server 2016 #738

Open Beakerboy opened 3 years ago

Beakerboy commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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

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