I'm trying to run SQL 2014c install using the xSQLserverSetup module with the following error messages:
Directory: C:\Temp\SqlServerSetup
Mode LastWriteTime Length Name
-a---- 29/07/2016 11:51 6248 LONSQL60A.mof
-a---- 29/07/2016 11:51 1122 LONSQL60A.meta.mof
PS C:\Program Files\WindowsPowerShell\Modules> Start-DscConfiguration -Path C:\Temp\SqlServerSetup\ -credential (Get-credential) -Verbose -Wait -Force
cmdlet Get-Credential at command pipeline position 1
Supply values for the following parameters:
VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = root/Microsof
t/Windows/DesiredStateConfiguration'.
VERBOSE: An LCM method call arrived from computer CONTOSO.COM with user sid S-1-5-21-3798882980-2146746437-3985048140-44958.
VERBOSE: [CONTOSO.COM]: LCM: [ Start Set ]
VERBOSE: [CONTOSO.COM]: [DSCEngine] Importing the module C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PSDesiredStateConfiguration\DscResources\MSFT_ScriptResour
ce\MSFT_ScriptResource.psm1 in force mode.
VERBOSE: [CONTOSO.COM]: [DSCEngine] Importing the module C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PSDesiredStateConfiguration\DscResources\MSFT_RoleResource
\MSFT_RoleResource.psm1 in force mode.
VERBOSE: [CONTOSO.COM]: [DSCEngine] Importing the module C:\Program Files\WindowsPowerShell\Modules\xSQLServer\1.5.0.0\DscResources\MSFT_xSQLServerSetup\MSFT_xSQLServ
erSetup.psm1 in force mode.
VERBOSE: [CONTOSO.COM]: LCM: [ Start Resource ] [[Script]DisableFirewall]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Test ] [[Script]DisableFirewall]
VERBOSE: [CONTOSO.COM]: [[Script]DisableFirewall] Importing the module MSFT_ScriptResource in force mode.
VERBOSE: [CONTOSO.COM]: LCM: [ End Test ] [[Script]DisableFirewall] in 1.2350 seconds.
VERBOSE: [CONTOSO.COM]: LCM: [ Skip Set ] [[Script]DisableFirewall]
VERBOSE: [CONTOSO.COM]: LCM: [ End Resource ] [[Script]DisableFirewall]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Resource ] [[File]DSCResourceFolder]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Test ] [[File]DSCResourceFolder]
VERBOSE: [CONTOSO.COM]: [[File]DSCResourceFolder] The network name cannot be found.
VERBOSE: [CONTOSO.COM]: [[File]DSCResourceFolder] The related file/directory is: \CONTOSO.COM\Modules.
VERBOSE: [CONTOSO.COM]: [[File]DSCResourceFolder] Building file list from cache.
VERBOSE: [CONTOSO.COM]: [[File]DSCResourceFolder] The destination object was found and no action is required.
VERBOSE: [CONTOSO.COM]: LCM: [ End Test ] [[File]DSCResourceFolder] in 7.6720 seconds.
VERBOSE: [CONTOSO.COM]: LCM: [ Skip Set ] [[File]DSCResourceFolder]
VERBOSE: [CONTOSO.COM]: LCM: [ End Resource ] [[File]DSCResourceFolder]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Resource ] [[WindowsFeature]NTFranmeworkcore]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Test ] [[WindowsFeature]NTFranmeworkcore]
VERBOSE: [CONTOSO.COM]: [[WindowsFeature]NTFranmeworkcore] Importing the module MSFT_RoleResource in force mode.
VERBOSE: [CONTOSO.COM]: [[WindowsFeature]NTFranmeworkcore] The operation 'Get-WindowsFeature' started: Net-Framework-Core
VERBOSE: [CONTOSO.COM]: [[WindowsFeature]NTFranmeworkcore] The operation 'Get-WindowsFeature' succeeded: NET-Framework-Core
VERBOSE: [CONTOSO.COM]: LCM: [ End Test ] [[WindowsFeature]NTFranmeworkcore] in 0.6710 seconds.
VERBOSE: [CONTOSO.COM]: LCM: [ Skip Set ] [[WindowsFeature]NTFranmeworkcore]
VERBOSE: [CONTOSO.COM]: LCM: [ End Resource ] [[WindowsFeature]NTFranmeworkcore]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Resource ] [[xSQLServerSetup]SqlInstaller]
VERBOSE: [CONTOSO.COM]: LCM: [ Start Test ] [[xSQLServerSetup]SqlInstaller]
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing the module MSFT_xSQLServerSetup in force mode.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\xSQLServer\1.5.0.0\xPDT.psm1'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'GetxPDTVariable'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'NetUse'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'ResolvePath'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'StartWin32Process'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'WaitForWin32ProcessEnd'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Path: Z:\setup.exe
VERBOSE: [CONTOSO.COM]: LCM: [ End Test ] [[xSQLServerSetup]SqlInstaller] in 1.5790 seconds.
VERBOSE: [CONTOSO.COM]: LCM: [ Start Set ] [[xSQLServerSetup]SqlInstaller]
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing the module MSFT_xSQLServerSetup in force mode.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Loading module from path 'C:\Program Files\WindowsPowerShell\Modules\xSQLServer\1.5.0.0\xPDT.psm1'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'GetxPDTVariable'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'NetUse'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'ResolvePath'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'StartWin32Process'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'WaitForWin32ProcessEnd'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Path: Z:\setup.exe
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'GetxPDTVariable'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'NetUse'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'ResolvePath'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'StartWin32Process'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'WaitForWin32ProcessEnd'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Path: Z:\setup.exe
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Arguments: /Quiet="True" /IAcceptSQLServerLicenseTerms="True" /Action="Install" /AGTSVCSTARTUPTYPE=Automatic /
InstanceName="MSSQLSERVER" /Features="SQLENGINE,ADV_SSMS" /SQLSysAdminAccounts="installer"
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Process matching path 'Z:\setup.exe' started in process ID 1472
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'GetxPDTVariable'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'NetUse'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'ResolvePath'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'StartWin32Process'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Importing function 'WaitForWin32ProcessEnd'.
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Path: Z:\setup.exe
VERBOSE: [CONTOSO.COM]: [[xSQLServerSetup]SqlInstaller] Test-TargetResource returned false after calling set. | ErrorType: MSFT_xSQLServerSetup.TestFailedAfterSet
VERBOSE: [CONTOSO.COM]: LCM: [ End Set ] [[xSQLServerSetup]SqlInstaller] in 15.3120 seconds.
PowerShell DSC resource MSFT_xSQLServerSetup failed to execute Set-TargetResource functionality with error message: Test-TargetResource returned false after calling set.
+ CategoryInfo : InvalidOperation: (:) [], CimException
+ FullyQualifiedErrorId : ProviderOperationExecutionFailure
+ PSComputerName : CONTOSO.COM
VERBOSE: [CONTOSO.COM]: LCM: [ End Set ]
The SendConfigurationApply function did not succeed.
+ CategoryInfo : NotSpecified: (root/Microsoft/...gurationManager:String) [], CimException
+ FullyQualifiedErrorId : MI RESULT 1
+ PSComputerName : CONTOSO.COM
VERBOSE: Operation 'Invoke CimMethod' complete.
VERBOSE: Time taken for configuration job to complete is 27.741 seconds
PS C:\Program Files\WindowsPowerShell\Modules>
Here is the message summary:
IOverall summary:
Final result: Failed: see details below
Exit code (Decimal): -2147024895
Exit facility code: 7
Exit error code: 1
Exit message: Incorrect function.
Start time: 2016-07-29 11:58:02
End time: 2016-07-29 11:58:09
Requested action: Install
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0x60797DC7%400xAC9299FD&EvtType=0x60797DC7%400xAC9299FD
Machine Properties:
Machine name: CONTOSO.COM
Machine processor count: 4
OS version: Windows Server 2012
OS service pack:
OS region: United Kingdom
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
Package properties:
Description: Microsoft SQL Server 2014
ProductName: SQL Server 2014
Type: RTM
Version: 12
SPLevel: 0
Installation location: Z:\x64\setup
Installation edition: Enterprise
Product Update Status:
None discovered.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT:
AGTSVCPASSWORD:
AGTSVCSTARTUPTYPE: Automatic
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: MULTIDIMENSIONAL
ASSVCACCOUNT:
ASSVCPASSWORD:
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS:
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME:
CLTRESULTDIR:
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT:
CLTSVCPASSWORD:
CLTWORKINGDIR:
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE:
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT:
CTLRSVCPASSWORD:
CTLRUSERS:
ENABLERANU: false
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE, ADV_SSMS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME:
FTSVCACCOUNT:
FTSVCPASSWORD:
HELP: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server
INSTALLSQLDATADIR:
INSTANCEDIR: C:\Program Files\Microsoft SQL Server
INSTANCEID:
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD:
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME:
MATRIXNAME:
NPENABLED: 0
PID: *****
QUIET: true
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT:
RSSVCPASSWORD:
RSSVCSTARTUPTYPE: Automatic
SAPWD:
SECURITYMODE:
SQLBACKUPDIR:
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT:
SQLSVCPASSWORD:
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: installer
SQLTEMPDBDIR:
SQLTEMPDBLOGDIR:
SQLUSERDBDIR:
SQLUSERDBLOGDIR:
SQMREPORTING: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
USEMICROSOFTUPDATE: false
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20160729_115801\ConfigurationFile.ini
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20160729_115801\SystemConfigurationCheck_Report.htm
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: System.IO.IOException
Message:
Incorrect function.
HResult : 0x80070001
Data:
DisableWatson = true
Stack:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
at Microsoft.SqlServer.Configuration.UIExtension.HelpFileMigrator.CopyHelpFilestoLocal()
at Microsoft.SqlServer.Configuration.UIExtension.StartAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)