Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.
Sign upxSQLServerScript: Fails when calling Invoke-Sqlcmd using PowerShell 4.0 from LCM #273
Comments
johlju
added
bug
help wanted
in progress
and removed
help wanted
labels
Dec 30, 2016
johlju
self-assigned this
Jan 1, 2017
This comment has been minimized.
This comment has been minimized.
|
For the time being I will put a note in the README.md that there is a known problem running the xSQLServerScript resource using PowerShell 4.0. |
johlju
referenced this issue
Jan 1, 2017
Merged
xSQLServerScript: Changes to the resource and tests #280
johlju
closed this
in
#280
Jan 5, 2017
johlju
removed their assignment
Apr 16, 2017
johlju
removed
the
in progress
label
Apr 16, 2017
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
johlju commentedDec 30, 2016
•
edited
Details of the scenario you try and problem that is occurring:
When PowerShell 4,0 is installed calling
Invoke-Sqlcmdfrom the helper functionInvoke-SqlScriptfails.See more detailed explanation here:
#252 (comment)
If there is no solution to running this resource using PowerShell 4.0, then as a minimum we have to document in the README.md that this is PowerShell 5.0 only.
The DSC configuration that is using the resource (as detailed as possible):
Configuration
Get-RunSQLScript.sql
Set-RunSQLScript.sql
Test-RunSQLScript.sql
Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
Windows Server 2012 R2, SQL Server 2014, PowerShell 4.0
Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev