Hi Indra,
I am not sure if I understand your statement :
‘As it runs and installs successfully from target machine but when i run this from workstation , it shows error’.
What do you mean by running it from workstation? From the SQL summary file, it looks like a permission issue. Please provide some more information on the specific
scenario where you experience this issue.
-Kapil
From: Indra k [mailto:
Sent: Friday, June 27, 2014 3:19 AM
To:
Subject: [chef] sql server 2008 silent installation
I have done silent installation for sql server 2008 r2 using cookbook in open source chef .
As it runs and installs successfully from target machine but when i run this from workstation , it shows error
[2014-06-27T00:06:38-07:00] FATAL: Mixlib::ShellOut::ShellCommandFailed: batch[sql install] (sqlstd::default line 80) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received
'-2068774911'
172.16.1.114 ---- Begin output of "cmd.exe" /c "C:/Users/ADMINI~1/AppData/Local/Temp/chef-script20140627-2648-1hfdy0h.bat" ----
172.16.1.114 STDOUT: C:\>"C:\Program Files\SQL SERVER 2008 R2\setup.exe"/ConfigurationFile="C:\Program Files (x86)\configuration.ini"
172.16.1.114 The following error occurred:
172.16.1.114 There was an error generating the XML document.
172.16.1.114
172.16.1.114 Error result: -2068774911
172.16.1.114 Result facility code: 1201
172.16.1.114 Result error code: 1
172.16.1.114
172.16.1.114 Please review the summary.txt log for further details
172.16.1.114 Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
172.16.1.114 Copyright (c) Microsoft Corporation. All rights reserved.
172.16.1.114 STDERR:
172.16.1.114 ---- End output of "cmd.exe" /c "C:/Users/ADMINI~1/AppData/Local/Temp/chef-script20140627-2648-1hfdy0h.bat" ----
172.16.1.114 Ran "cmd.exe" /c "C:/Users/ADMINI~1/AppData/Local/Temp/chef-script20140627-2648-1hfdy0h.bat" returned -2068774911
AND MY summary.txt file is :
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068774911
Exit facility code: 1201
Exit error code: 1
Exit message: There was an error generating the XML document.
Start time: 2014-06-27 12:23:25
End time: 2014-06-27 12:23:37
Requested action: RunRules
Machine Properties:
Machine name: WIN-DQ00DBBP3I1
Machine processor count: 1
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 32 Bit
OS clustered: No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: C:\Program Files\SQL SERVER 2008 R2\x86\setup\
Installation edition: DATA_CENTER
User Input Settings:
ACTION: RunRules
CONFIGURATIONFILE: C:\Program Files (x86)\configuration.ini
ENU: True
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES:
HELP: False
IACCEPTSQLSERVERLICENSETERMS: True
INDICATEPROGRESS: False
INSTANCENAME: MSSQLSERVER
PASSPHRASE: *****
QUIET: False
QUIETSIMPLE: True
RULES: GlobalRules
UIMODE: Normal
X86: True
Configuration file: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20140627_122318\ConfigurationFile.ini
Detailed results:
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: The rule result report file is not available.
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
Message:
There was an error generating the XML document.
Data:
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache)
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(Object objectToSerialize)
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveInputSettingValueToObject(InputSettingInfo inputSettingInfo, List`1 values)
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveParsedArgumentsIntoInputSettingStore(InputSettingSource source, Dictionary`2 parsedArguments, Boolean chainerSetting, Boolean ignoreSettingsForNotAllowedScnearios)
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.ProcessConfigFile(String configFileFullPath, Boolean chainerSetting, Boolean ignoreSettingsForNotAllowedScnearios)
at Microsoft.SqlServer.Configuration.BootstrapExtension.ProcessConfigFileArguments.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
Inner exception type: System.InvalidOperationException
Message:
There was an error generating the XML document.
Stack:
at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
at System.Xml.Serialization.XmlSerializer.Serialize(TextWriter textWriter, Object o, XmlSerializerNamespaces namespaces)
at System.Xml.Serialization.XmlSerializer.Serialize(TextWriter textWriter, Object o)
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache)
Inner exception type: System.Security.Cryptography.CryptographicException
Message:
Access is denied.
Stack:
at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope)
at Microsoft.SqlServer.Common.SqlSecureString.WriteXml(XmlWriter writer)
at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write6_SqlEngineSetupPublic(String n, String ns, SqlEngineSetupPublic o, Boolean isNullable, Boolean needType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write7_SqlEngineSetupPublic(Object o)
|