# Sql server 2008 silent installation

**URL:** <https://discourse.chef.io/t/sql-server-2008-silent-installation/5465>\
**Category:** Chef Infra (archive)\
**Created:** [June 27, 2014, 7:18am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465 "2014-06-27T07:18:50Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [June 27, 2014, 7:18am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/1 "2014-06-27T07:18:50Z")

</div>

Hi

```
      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 ® SQL Server 2008 R2 Setup 10.50.1600.01  
172.16.1.114 Copyright © 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:   
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)
```

---

<div class="post-metadata">

**Author:** ![Kapil\_Shardha1](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@Kapil\_Shardha1](https://discourse.chef.io/u/Kapil_Shardha1)\
**Post date:** [June 27, 2014, 11:56am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/2 "2014-06-27T11:56:47Z")

</div>

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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
Sent: Friday, June 27, 2014 3:19 AM  
To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Subject: [chef] sql server 2008 silent installation

Hi

```
      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 ® SQL Server 2008 R2 Setup 10.50.1600.01  
172.16.1.114 Copyright © 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:   
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)
```

---

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [June 27, 2014, 12:41pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/3 "2014-06-27T12:41:45Z")

</div>

Thanks for response,

```
                 Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .

                   When i run this as  

```

knife winrm name:“WIN-DQ00DBBP3I1” ‘chef-client’ -x administrator -P “password” -a ipaddress

it shows a following error which i sent.

I think also same the problem is in permission,like when i run chef-client in administrator [user.so](http://user.so) i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache

* * *

From: Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "chef@lists.opscode.com" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Friday, 27 June 2014 5:26 PM  
Subject: [chef] RE: sql server 2008 silent installation

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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
Sent: Friday, June 27, 2014 3:19 AM  
To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Subject: [chef] sql server 2008 silent installation

Hi

```
      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 ® SQL Server 2008 R2 Setup 10.50.1600.01  
172.16.1.114 Copyright © 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:   
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)
```

---

<div class="post-metadata">

**Author:** ![Kapil\_Shardha1](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@Kapil\_Shardha1](https://discourse.chef.io/u/Kapil_Shardha1)\
**Post date:** [June 27, 2014, 12:52pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/4 "2014-06-27T12:52:09Z")

</div>

I vaguely remember running into similar issues while installing SQL Server via Powershell Remoting (winrm under the hood) – outside chef scope.

Check this link : [http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d972c35e-244a-4a5d-8add-0167d6e46646/require-help-on-doing-silent-installation-through-powershell-remoting-of-sql-server?forum=sqlsetupandupgrade](http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d972c35e-244a-4a5d-8add-0167d6e46646/require-help-on-doing-silent-installation-through-powershell-remoting-of-sql-server?forum=sqlsetupandupgrade)

-Kapil

From: Indra k [[mailto:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
Sent: Friday, June 27, 2014 8:42 AM  
To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Subject: [chef] Re: RE: sql server 2008 silent installation

Thanks for response,

```
                 Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .

                   When i run this as

```

knife winrm name:“WIN-DQ00DBBP3I1” ‘chef-client’ -x administrator -P “password” -a ipaddress

it shows a following error which i sent.

I think also same the problem is in permission,like when i run chef-client in administrator [user.so](http://user.so) i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache

* * *

From: Kapil Shardha \<[Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)[mailto:Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)\>  
To: Indra k \<[indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)[mailto:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)\>; "chef@lists.opscode.com[mailto:chef@lists.opscode.com](mailto:chef@lists.opscode.com)" \<[chef@lists.opscode.com](mailto:chef@lists.opscode.com)[mailto:chef@lists.opscode.com](mailto:chef@lists.opscode.com)\>  
Sent: Friday, 27 June 2014 5:26 PM  
Subject: [chef] RE: sql server 2008 silent installation

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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
Sent: Friday, June 27, 2014 3:19 AM  
To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)[mailto:chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Subject: [chef] sql server 2008 silent installation

Hi

```
      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 ® SQL Server 2008 R2 Setup 10.50.1600.01  
172.16.1.114 Copyright © 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:   
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)
```

---

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [July 3, 2014, 9:10am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/5 "2014-07-03T09:10:25Z")

</div>

hi,  
i have tried out by creating a separate account with admin rights also in without admin rights still it shows “access denied”

```
 Inner exception type: System.Security.Cryptography.CryptographicException 
        Message:  
                    Access is denied. 

```

Thanks,  
Indra

* * *

From: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
To: "chef@lists.opscode.com" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Friday, 27 June 2014 6:11 PM  
Subject: [chef] Re: RE: sql server 2008 silent installation

Thanks for response,

```
                 Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .

                   When i run this as  

```

knife winrm name:“WIN-DQ00DBBP3I1” ‘chef-client’ -x administrator -P “password” -a ipaddress

it shows a following error which i sent.

I think also same the problem is in permission,like when i run chef-client in administrator [user.so](http://user.so) i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache

* * *

From: Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "chef@lists.opscode.com" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Friday, 27 June 2014 5:26 PM  
Subject: [chef] RE: sql server 2008 silent installation

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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
Sent: Friday, June 27, 2014 3:19 AM  
To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Subject: [chef] sql server 2008 silent installation

Hi

```
      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 ® SQL Server 2008 R2 Setup 10.50.1600.01  
172.16.1.114 Copyright © 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:   
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)
```

---

<div class="post-metadata">

**Author:** ![Aditya\_Karanjkar](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Aditya\_Karanjkar](https://discourse.chef.io/u/Aditya_Karanjkar)\
**Post date:** [July 3, 2014, 6:42pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/6 "2014-07-03T18:42:10Z")

</div>

Hi,

May not be related but I hit the similar (access denied) issues when  
installing any windows package that might need to install a .msu update as  
a part of the installation process. And as in your case, it runs perfectly  
when chef-client is triggered from an administrative command within the  
node itself. It might be related to the following issue:

> **[Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED -...](https://learn.microsoft.com/en-US/troubleshoot/windows-server/deployment/windows-update-standalone-installer-returns-error)**
>
> Works around an issue that occurs when you deploy Windows Update .msu files through Windows Remote Management 2.0 and Windows Remote Shell.

I have hit this with SCCM client, SCEP client etc. It's a Windows  
limitation and Chef cannot do anything about it.

My workaround was to create a scheduled task scheduled to run 'once' and  
fire it off immediately. I don't think you can use the windows\_task  
resource provided by the windows cookbook as it doesn't accept 'once' as a  
valid schedule. I used the execute resource with 'schtasks' to do the same.  
Give it a shot and let me know if it works for you:

Example:  
execute "Task to install SCEP Client" do  
command "schtasks /create /f /sc once /st  
#{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr  
"C:\Windows\Temp\Client\scepinstall.exe  
#{node['scep\_client']['installer\_options']}" /RU  
#{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
action :run  
end  
execute "Run SCEP Client installer task" do  
command "schtasks /run /i /tn Install\_SCEP\_Client"  
action :run  
end

Best Regards,  
Aditya

On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

> hi,  
> i have tried out by creating a separate account with admin rights  
> also in without admin rights still it shows "access denied"
> 
> ```
> Inner exception type:
> 
> ```
> 
> System.Security.Cryptography.CryptographicException  
> Message:  
> Access is denied.
> 
> Thanks,  
> Indra
> 
> * * *
> 
> _From:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _To:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 27 June 2014 6:11 PM  
> _Subject:_ [chef] Re: RE: sql server 2008 silent installation
> 
> Thanks for response,
> 
> ```
> Actually my sql server 2008 r2 standard edition
> 
> ```
> 
> cookbook is working fine when i run chef-client from a target node .
> 
> ```
> When i run this as
> 
> ```
> 
> knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P  
> "password" -a ipaddress
> 
> it shows a following error which i sent.
> 
> I think also same the problem is in permission,like when i run chef-client  
> in administrator user.so i create another account without have admin rights  
> ,again when i run chef-client from a command prompt not even workstation it  
> shows pemission denied errror to c:/chef/cache
> 
> * * *
> 
> _From:_ Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" \<  
> [chef@lists.opscode.com](mailto:chef@lists.opscode.com)\>  
> _Sent:_ Friday, 27 June 2014 5:26 PM  
> _Subject:_ [chef] RE: sql server 2008 silent installation
> 
> 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> _Sent:_ Friday, June 27, 2014 3:19 AM  
> _To:_ [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Subject:_ [chef] sql server 2008 silent installation
> 
> Hi
> 
> ```
> 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:   
> 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)

---

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [July 7, 2014, 9:16am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/7 "2014-07-07T09:16:16Z")

</div>

Hi,

```
  i have tried by giving

```

winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"

but it shows the system path can't specified.

I dont know how to give can u help me in this.

Thanks,  
indra

* * *

From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Friday, 4 July 2014 12:12 AM  
Subject: [chef] Re: Re: Re: RE: sql server 2008 silent installation

Hi,

May not be related but I hit the similar (access denied) issues when installing any windows package that might need to install a .msu update as a part of the installation process. And as in your case, it runs perfectly when chef-client is triggered from an administrative command within the node itself. It might be related to the following issue:

> **[Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED -...](https://learn.microsoft.com/en-US/troubleshoot/windows-server/deployment/windows-update-standalone-installer-returns-error)**
>
> Works around an issue that occurs when you deploy Windows Update .msu files through Windows Remote Management 2.0 and Windows Remote Shell.

I have hit this with SCCM client, SCEP client etc. It's a Windows limitation and Chef cannot do anything about it.

My workaround was to create a scheduled task scheduled to run 'once' and fire it off immediately. I don't think you can use the windows\_task resource provided by the windows cookbook as it doesn't accept 'once' as a valid schedule. I used the execute resource with 'schtasks' to do the same. Give it a shot and let me know if it works for you:

Example:  
execute "Task to install SCEP Client" do  
command "schtasks /create /f /sc once /st #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr "C:\Windows\Temp\Client\scepinstall.exe #{node['scep\_client']['installer\_options']}" /RU #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
action :run  
end  
execute "Run SCEP Client installer task" do  
command "schtasks /run /i /tn Install\_SCEP\_Client"  
action :run  
end

Best Regards,

Aditya

On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

hi,

> ```
> i have tried out by creating a separate account with admin rights also in without admin rights still it shows "access denied"
> 
> Inner exception type: System.Security.Cryptography.CryptographicException 
> Message:  
> Access is denied. 
> 
> ```
> 
> Thanks,  
> Indra
> 
> * * *
> 
> From: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> To: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> Sent: Friday, 27 June 2014 6:11 PM  
> Subject: [chef] Re: RE: sql server 2008 silent installation
> 
> Thanks for response,
> 
> ```
> Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .
> 
> When i run this as  
> 
> ```
> 
> knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P "password" -a ipaddress
> 
> it shows a following error which i sent.
> 
> I think also same the problem is in permission,like when i run chef-client in administrator user.so i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache
> 
> * * *
> 
> From: Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> Sent: Friday, 27 June 2014 5:26 PM  
> Subject: [chef] RE: sql server 2008 silent installation
> 
> 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> Sent: Friday, June 27, 2014 3:19 AM  
> To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> Subject: [chef] sql server 2008 silent installation
> 
> Hi
> 
> ```
> 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:   
> 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)
> 
> ```

---

<div class="post-metadata">

**Author:** ![Aditya\_Karanjkar](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Aditya\_Karanjkar](https://discourse.chef.io/u/Aditya_Karanjkar)\
**Post date:** [July 7, 2014, 5:06pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/8 "2014-07-07T17:06:59Z")

</div>

Hi Indra,

I haven't tried the winrs method as the 'scheduled task' way I described  
above sufficed for us. I'll try the winrs method sometime later and let you  
know. Meanwhile you can try the scheduled task way as described in my  
previous example and let me know if that works for you.

Regards,  
Aditya

On Mon, Jul 7, 2014 at 2:16 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

> Hi,
> 
> ```
> i have tried by giving
> 
> ```
> 
> winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"
> 
> but it shows the system path can't specified.
> 
> I dont know how to give can u help me in this.
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 4 July 2014 12:12 AM  
> _Subject:_ [chef] Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi,
> 
> May not be related but I hit the similar (access denied) issues when  
> installing any windows package that might need to install a .msu update as  
> a part of the installation process. And as in your case, it runs perfectly  
> when chef-client is triggered from an administrative command within the  
> node itself. It might be related to the following issue:  
> [Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED - Windows Server | Microsoft Learn](http://support.microsoft.com/kb/2773898)
> 
> I have hit this with SCCM client, SCEP client etc. It's a Windows  
> limitation and Chef cannot do anything about it.
> 
> My workaround was to create a scheduled task scheduled to run 'once' and  
> fire it off immediately. I don't think you can use the windows\_task  
> resource provided by the windows cookbook as it doesn't accept 'once' as a  
> valid schedule. I used the execute resource with 'schtasks' to do the same.  
> Give it a shot and let me know if it works for you:
> 
> Example:  
> execute "Task to install SCEP Client" do  
> command "schtasks /create /f /sc once /st  
> #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr  
> "C:\Windows\Temp\Client\scepinstall.exe  
> #{node['scep\_client']['installer\_options']}" /RU  
> #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
> action :run  
> end  
> execute "Run SCEP Client installer task" do  
> command "schtasks /run /i /tn Install\_SCEP\_Client"  
> action :run  
> end
> 
> Best Regards,  
> Aditya
> 
> On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> hi,  
> i have tried out by creating a separate account with admin rights  
> also in without admin rights still it shows "access denied"
> 
> ```
> Inner exception type:
> 
> ```
> 
> System.Security.Cryptography.CryptographicException  
> Message:  
> Access is denied.
> 
> Thanks,  
> Indra
> 
> * * *
> 
> _From:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _To:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 27 June 2014 6:11 PM  
> _Subject:_ [chef] Re: RE: sql server 2008 silent installation
> 
> Thanks for response,
> 
> ```
> Actually my sql server 2008 r2 standard edition
> 
> ```
> 
> cookbook is working fine when i run chef-client from a target node .
> 
> ```
> When i run this as
> 
> ```
> 
> knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P  
> "password" -a ipaddress
> 
> it shows a following error which i sent.
> 
> I think also same the problem is in permission,like when i run chef-client  
> in administrator user.so i create another account without have admin rights  
> ,again when i run chef-client from a command prompt not even workstation it  
> shows pemission denied errror to c:/chef/cache
> 
> * * *
> 
> _From:_ Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" \<  
> [chef@lists.opscode.com](mailto:chef@lists.opscode.com)\>  
> _Sent:_ Friday, 27 June 2014 5:26 PM  
> _Subject:_ [chef] RE: sql server 2008 silent installation
> 
> 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> _Sent:_ Friday, June 27, 2014 3:19 AM  
> _To:_ [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Subject:_ [chef] sql server 2008 silent installation
> 
> Hi
> 
> ```
> 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:   
> 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)

---

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [July 8, 2014, 10:18am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/9 "2014-07-08T10:18:12Z")

</div>

Hi Aditya,

```
             Have to run those scep code which installs client settings.

```

I dont understand,need to install scep client and sscm ah what it can do?

```
      Because my problem is only running sql server silent installation commands it shows access denied error while running from workstation.

```

Thanks,  
indra

* * *

From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Monday, 7 July 2014 10:36 PM  
Subject: [chef] Re: Re: Re: Re: RE: sql server 2008 silent installation

Hi Indra,

I haven't tried the winrs method as the 'scheduled task' way I described above sufficed for us. I'll try the winrs method sometime later and let you know. Meanwhile you can try the scheduled task way as described in my previous example and let me know if that works for you.

Regards,  
Aditya

On Mon, Jul 7, 2014 at 2:16 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

Hi,

> ```
> i have tried by giving
> 
> ```
> 
> winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"
> 
> but it shows the system path can't specified.
> 
> I dont know how to give can u help me in this.
> 
> Thanks,  
> indra
> 
> * * *
> 
> From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> Sent: Friday, 4 July 2014 12:12 AM  
> Subject: [chef] Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi,
> 
> May not be related but I hit the similar (access denied) issues when installing any windows package that might need to install a .msu update as a part of the installation process. And as in your case, it runs perfectly when chef-client is triggered from an administrative command within the node itself. It might be related to the following issue:  
> [Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED - Windows Server | Microsoft Learn](http://support.microsoft.com/kb/2773898)
> 
> I have hit this with SCCM client, SCEP client etc. It's a Windows limitation and Chef cannot do anything about it.
> 
> My workaround was to create a scheduled task scheduled to run 'once' and fire it off immediately. I don't think you can use the windows\_task resource provided by the windows cookbook as it doesn't accept 'once' as a valid schedule. I used the execute resource with 'schtasks' to do the same. Give it a shot and let me know if it works for you:
> 
> Example:  
> execute "Task to install SCEP Client" do  
> command "schtasks /create /f /sc once /st #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr "C:\Windows\Temp\Client\scepinstall.exe #{node['scep\_client']['installer\_options']}" /RU #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
> action :run  
> end  
> execute "Run SCEP Client installer task" do  
> command "schtasks /run /i /tn Install\_SCEP\_Client"  
> action :run  
> end
> 
> Best Regards,

Aditya

> On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> hi,
> 
> > ```
> > i have tried out by creating a separate account with admin rights also in without admin rights still it shows "access denied"
> > 
> > Inner exception type: System.Security.Cryptography.CryptographicException 
> > Message:  
> > Access is denied. 
> > 
> > ```
> > 
> > Thanks,  
> > Indra
> > 
> > * * *
> > 
> > From: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> > To: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > Sent: Friday, 27 June 2014 6:11 PM  
> > Subject: [chef] Re: RE: sql server 2008 silent installation
> > 
> > Thanks for response,
> > 
> > ```
> > Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .
> > 
> > When i run this as  
> > 
> > ```
> > 
> > knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P "password" -a ipaddress
> > 
> > it shows a following error which i sent.
> > 
> > I think also same the problem is in permission,like when i run chef-client in administrator user.so i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache
> > 
> > * * *
> > 
> > From: Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> > To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > Sent: Friday, 27 June 2014 5:26 PM  
> > Subject: [chef] RE: sql server 2008 silent installation
> > 
> > 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> > Sent: Friday, June 27, 2014 3:19 AM  
> > To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > Subject: [chef] sql server 2008 silent installation
> > 
> > Hi
> > 
> > ```
> > 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:   
> > 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)
> > 
> > ```

---

<div class="post-metadata">

**Author:** ![Aditya\_Karanjkar](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Aditya\_Karanjkar](https://discourse.chef.io/u/Aditya_Karanjkar)\
**Post date:** [July 8, 2014, 5:44pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/10 "2014-07-08T17:44:04Z")

</div>

Hi Indra,

My example was with regards to the SCEP client installation. Replace the  
installation command with the silent install command for SQL Server 2008.

Regards,  
Aditya

On Tue, Jul 8, 2014 at 3:18 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

> Hi Aditya,
> 
> ```
> Have to run those scep code which installs client
> 
> ```
> 
> settings.  
> I dont understand,need to install scep client and sscm ah what it can do?
> 
> ```
> Because my problem is only running sql server silent
> 
> ```
> 
> installation commands it shows access denied error while running from  
> workstation.
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Monday, 7 July 2014 10:36 PM  
> _Subject:_ [chef] Re: Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi Indra,
> 
> I haven't tried the winrs method as the 'scheduled task' way I described  
> above sufficed for us. I'll try the winrs method sometime later and let you  
> know. Meanwhile you can try the scheduled task way as described in my  
> previous example and let me know if that works for you.
> 
> Regards,  
> Aditya
> 
> On Mon, Jul 7, 2014 at 2:16 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> Hi,
> 
> ```
> i have tried by giving
> 
> ```
> 
> winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"
> 
> but it shows the system path can't specified.
> 
> I dont know how to give can u help me in this.
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 4 July 2014 12:12 AM  
> _Subject:_ [chef] Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi,
> 
> May not be related but I hit the similar (access denied) issues when  
> installing any windows package that might need to install a .msu update as  
> a part of the installation process. And as in your case, it runs perfectly  
> when chef-client is triggered from an administrative command within the  
> node itself. It might be related to the following issue:  
> [Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED - Windows Server | Microsoft Learn](http://support.microsoft.com/kb/2773898)
> 
> I have hit this with SCCM client, SCEP client etc. It's a Windows  
> limitation and Chef cannot do anything about it.
> 
> My workaround was to create a scheduled task scheduled to run 'once' and  
> fire it off immediately. I don't think you can use the windows\_task  
> resource provided by the windows cookbook as it doesn't accept 'once' as a  
> valid schedule. I used the execute resource with 'schtasks' to do the same.  
> Give it a shot and let me know if it works for you:
> 
> Example:  
> execute "Task to install SCEP Client" do  
> command "schtasks /create /f /sc once /st  
> #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr  
> "C:\Windows\Temp\Client\scepinstall.exe  
> #{node['scep\_client']['installer\_options']}" /RU  
> #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
> action :run  
> end  
> execute "Run SCEP Client installer task" do  
> command "schtasks /run /i /tn Install\_SCEP\_Client"  
> action :run  
> end
> 
> Best Regards,  
> Aditya
> 
> On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> hi,  
> i have tried out by creating a separate account with admin rights  
> also in without admin rights still it shows "access denied"
> 
> ```
> Inner exception type:
> 
> ```
> 
> System.Security.Cryptography.CryptographicException  
> Message:  
> Access is denied.
> 
> Thanks,  
> Indra
> 
> * * *
> 
> _From:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _To:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 27 June 2014 6:11 PM  
> _Subject:_ [chef] Re: RE: sql server 2008 silent installation
> 
> Thanks for response,
> 
> ```
> Actually my sql server 2008 r2 standard edition
> 
> ```
> 
> cookbook is working fine when i run chef-client from a target node .
> 
> ```
> When i run this as
> 
> ```
> 
> knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P  
> "password" -a ipaddress
> 
> it shows a following error which i sent.
> 
> I think also same the problem is in permission,like when i run chef-client  
> in administrator user.so i create another account without have admin rights  
> ,again when i run chef-client from a command prompt not even workstation it  
> shows pemission denied errror to c:/chef/cache
> 
> * * *
> 
> _From:_ Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" \<  
> [chef@lists.opscode.com](mailto:chef@lists.opscode.com)\>  
> _Sent:_ Friday, 27 June 2014 5:26 PM  
> _Subject:_ [chef] RE: sql server 2008 silent installation
> 
> 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> _Sent:_ Friday, June 27, 2014 3:19 AM  
> _To:_ [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Subject:_ [chef] sql server 2008 silent installation
> 
> Hi
> 
> ```
> 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:   
> 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)

---

<div class="post-metadata">

**Author:** ![Indra\_k](https://avatars.discourse-cdn.com/v4/letter/i/c89c15/32.png) [@Indra\_k](https://discourse.chef.io/u/Indra_k)\
**Post date:** [July 9, 2014, 6:45am UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/11 "2014-07-09T06:45:53Z")

</div>

Hi Aditiya,  
I have run a following code for sql as you mentioned,it runs successfully .But sql server silent installation doesnot installed in a target machine .It doesnot shows error So what shall i do next?

```
 execute "Task to install Sql Client" do
    command "schtasks /create /f /sc once /st #{(::Time.now+1).strftime('%H:%M')} /tn Install_SQL /tr \"#{node['sqlstd']['path']} #{node['sqlstd']['installer_options']}\" /RU #{node['sqlstd']['sch_user']} /RP #{node['sqlstd']['sch_passwd']}"
    action :run

```

end  
execute "Run SQL installer task" do  
command "schtasks /run /i /tn Install\_SQL"  
action :run  
end

output

2014-07-09T12:11:33+05:30] INFO: Loading cookbooks [windows@1.12.4, powershell@1.1.2, chef\_handler@1.1.4, sqlstd@0.1.0]  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Storing updated cookbooks/sqlstd/recipes/default.rb in the cache.  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Powershell light-weight provider already initialized -- overriding!  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: WindowsPackage light-weight resource already initialized -- overriding!  
192.168.3.217 QS /IACCEPTSQLSERVERLICENSE  
192.168.3.217 TERMS=TRUE /ACTION=Install /PID="DDT3B-8W62X-P9JD6-8MX7M-HWK38" /SECURITYMODE=SQ  
192.168.3.217 L /ROLE="AllFeatures\_WithDefaults" /INSTANCENAME="MSSQLSERVER" /AGTSVCACCOUNT="  
192.168.3.217 NT AUTHORITY\NETWORK SERVICE" /AGTSVCSTARTUPTYPE="Automatic" /RSSVCACCOUNT="NT A  
192.168.3.217 UTHORITY\NETWORK SERVICE" /ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /ISSVCSTA  
192.168.3.217 RTUPTYPE="Automatic" /ASSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /ASSVCSTARTUPT  
192.168.3.217 YPE="Automatic" /ASSYSADMINACCOUNTS="WIN-DQ00DBBP3I1\Administrator" /SAPWD="Welc  
192.168.3.217 0me"  
192.168.3.217  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Processing execute[Task to install Sql Client] action run (sqlstd::default line 80)  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: execute[Task to install Sql Client] ran successfully  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Processing execute[Run SQL installer task] action run (sqlstd::default line 84)  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: execute[Run SQL installer task] ran successfully  
192.168.3.217 [2014-07-09T12:11:34+05:30] WARN: Skipping final node save because override\_runlist was given  
192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Chef Run complete in 4.212008 seconds  
192.168.3.217 [2014-07-09T12:11:35+05:30] INFO: Running report handlers  
192.168.3.217 [2014-07-09T12:11:35+05:30] INFO: Report handlers complete

Thanks,  
indra

* * *

From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
Sent: Tuesday, 8 July 2014 11:14 PM  
Subject: [chef] Re: Re: Re: Re: Re: Re: RE: sql server 2008 silent installation

Hi Indra,

My example was with regards to the SCEP client installation. Replace the installation command with the silent install command for SQL Server 2008.

Regards,  
Aditya

On Tue, Jul 8, 2014 at 3:18 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

Hi Aditya,

> ```
> Have to run those scep code which installs client settings.
> 
> ```
> 
> I dont understand,need to install scep client and sscm ah what it can do?
> 
> ```
> Because my problem is only running sql server silent installation commands it shows access denied error while running from workstation.
> 
> ```
> 
> Thanks,  
> indra
> 
> * * *
> 
> From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> Sent: Monday, 7 July 2014 10:36 PM  
> Subject: [chef] Re: Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi Indra,
> 
> I haven't tried the winrs method as the 'scheduled task' way I described above sufficed for us. I'll try the winrs method sometime later and let you know. Meanwhile you can try the scheduled task way as described in my previous example and let me know if that works for you.
> 
> Regards,  
> Aditya
> 
> On Mon, Jul 7, 2014 at 2:16 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> Hi,
> 
> > ```
> > i have tried by giving
> > 
> > ```
> > 
> > winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"
> > 
> > but it shows the system path can't specified.
> > 
> > I dont know how to give can u help me in this.
> > 
> > Thanks,  
> > indra
> > 
> > * * *
> > 
> > From: Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> > To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> > Cc: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > Sent: Friday, 4 July 2014 12:12 AM  
> > Subject: [chef] Re: Re: Re: RE: sql server 2008 silent installation
> > 
> > Hi,
> > 
> > May not be related but I hit the similar (access denied) issues when installing any windows package that might need to install a .msu update as a part of the installation process. And as in your case, it runs perfectly when chef-client is triggered from an administrative command within the node itself. It might be related to the following issue:  
> > [Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED - Windows Server | Microsoft Learn](http://support.microsoft.com/kb/2773898)
> > 
> > I have hit this with SCCM client, SCEP client etc. It's a Windows limitation and Chef cannot do anything about it.
> > 
> > My workaround was to create a scheduled task scheduled to run 'once' and fire it off immediately. I don't think you can use the windows\_task resource provided by the windows cookbook as it doesn't accept 'once' as a valid schedule. I used the execute resource with 'schtasks' to do the same. Give it a shot and let me know if it works for you:
> > 
> > Example:  
> > execute "Task to install SCEP Client" do  
> > command "schtasks /create /f /sc once /st #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr "C:\Windows\Temp\Client\scepinstall.exe #{node['scep\_client']['installer\_options']}" /RU #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
> > action :run  
> > end  
> > execute "Run SCEP Client installer task" do  
> > command "schtasks /run /i /tn Install\_SCEP\_Client"  
> > action :run  
> > end
> > 
> > Best Regards,

Aditya

> > On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> > 
> > hi,
> > 
> > > ```
> > > i have tried out by creating a separate account with admin rights also in without admin rights still it shows "access denied"
> > > 
> > > Inner exception type: System.Security.Cryptography.CryptographicException 
> > > Message:  
> > > Access is denied. 
> > > 
> > > ```
> > > 
> > > Thanks,  
> > > Indra
> > > 
> > > * * *
> > > 
> > > From: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> > > To: "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > > Sent: Friday, 27 June 2014 6:11 PM  
> > > Subject: [chef] Re: RE: sql server 2008 silent installation
> > > 
> > > Thanks for response,
> > > 
> > > ```
> > > Actually my sql server 2008 r2 standard edition cookbook is working fine when i run chef-client from a target node .
> > > 
> > > When i run this as  
> > > 
> > > ```
> > > 
> > > knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P "password" -a ipaddress
> > > 
> > > it shows a following error which i sent.
> > > 
> > > I think also same the problem is in permission,like when i run chef-client in administrator user.so i create another account without have admin rights ,again when i run chef-client from a command prompt not even workstation it shows pemission denied errror to c:/chef/cache
> > > 
> > > * * *
> > > 
> > > From: Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> > > To: Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > > Sent: Friday, 27 June 2014 5:26 PM  
> > > Subject: [chef] RE: sql server 2008 silent installation
> > > 
> > > 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> > > Sent: Friday, June 27, 2014 3:19 AM  
> > > To: [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> > > Subject: [chef] sql server 2008 silent installation
> > > 
> > > Hi
> > > 
> > > ```
> > > 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:   
> > > 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)
> > > 
> > > ```

---

<div class="post-metadata">

**Author:** ![Aditya\_Karanjkar](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Aditya\_Karanjkar](https://discourse.chef.io/u/Aditya_Karanjkar)\
**Post date:** [July 9, 2014, 6:15pm UTC](https://discourse.chef.io/t/sql-server-2008-silent-installation/5465/12 "2014-07-09T18:15:59Z")

</div>

Hi Indra,

If the task has been created correctly, it should install SQL Server. Try  
the following:

1. Use schtasks to check if the task is created correctly for the  
installation.

> schtasks /query /tn Install\_SQL /v /fo list

1. Run the task manually from the command prompt and check if it installs  
SQL.

> schtasks /run /i /tn Install\_SQL

1. If the above two things are fine, the installer should leave a log file  
behind. Check it to see if the error is still access denied.

Regards,  
Aditya

On Tue, Jul 8, 2014 at 11:45 PM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:

> Hi Aditiya,  
> I have run a following code for sql as you mentioned,it runs  
> successfully .But sql server silent installation doesnot installed in a  
> target machine .It doesnot shows error So what shall i do next?
> 
> ```
> execute "Task to install Sql Client" do
> command "schtasks /create /f /sc once /st
> 
> ```
> 
> #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SQL /tr  
> "#{node['sqlstd']['path']} #{node['sqlstd']['installer\_options']}" /RU  
> #{node['sqlstd']['sch\_user']} /RP #{node['sqlstd']['sch\_passwd']}"  
> action :run  
> end  
> execute "Run SQL installer task" do  
> command "schtasks /run /i /tn Install\_SQL"  
> action :run  
> end
> 
> output
> 
> 2014-07-09T12:11:33+05:30] INFO: Loading cookbooks [windows@1.12.4,  
> powershell@1.1.2, chef\_handler@1.1.4, sqlstd@0.1.0]  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Storing updated  
> cookbooks/sqlstd/recipes/default.rb in the cache.  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Powershell light-weight  
> provider already initialized -- overriding!  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: WindowsPackage  
> light-weight resource already initialized -- overriding!  
> 192.168.3.217 QS /IACCEPTSQLSERVERLICENSE  
> 192.168.3.217 TERMS=TRUE /ACTION=Install  
> /PID="DDT3B-8W62X-P9JD6-8MX7M-HWK38" /SECURITYMODE=SQ  
> 192.168.3.217 L /ROLE="AllFeatures\_WithDefaults"  
> /INSTANCENAME="MSSQLSERVER" /AGTSVCACCOUNT="  
> 192.168.3.217 NT AUTHORITY\NETWORK SERVICE" /AGTSVCSTARTUPTYPE="Automatic"  
> /RSSVCACCOUNT="NT A  
> 192.168.3.217 UTHORITY\NETWORK SERVICE" /ISSVCACCOUNT="NT  
> AUTHORITY\NETWORK SERVICE" /ISSVCSTA  
> 192.168.3.217 RTUPTYPE="Automatic" /ASSVCACCOUNT="NT AUTHORITY\NETWORK  
> SERVICE" /ASSVCSTARTUPT  
> 192.168.3.217 YPE="Automatic"  
> /ASSYSADMINACCOUNTS="WIN-DQ00DBBP3I1\Administrator" /SAPWD="Welc  
> 192.168.3.217 0me"  
> 192.168.3.217  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Processing execute[Task to  
> install Sql Client] action run (sqlstd::default line 80)  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: execute[Task to install  
> Sql Client] ran successfully  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Processing execute[Run  
> SQL installer task] action run (sqlstd::default line 84)  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: execute[Run SQL installer  
> task] ran successfully  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] WARN: Skipping final node save  
> because override\_runlist was given  
> 192.168.3.217 [2014-07-09T12:11:34+05:30] INFO: Chef Run complete in  
> 4.212008 seconds  
> 192.168.3.217 [2014-07-09T12:11:35+05:30] INFO: Running report handlers  
> 192.168.3.217 [2014-07-09T12:11:35+05:30] INFO: Report handlers complete
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Tuesday, 8 July 2014 11:14 PM  
> _Subject:_ [chef] Re: Re: Re: Re: Re: Re: RE: sql server 2008 silent  
> installation
> 
> Hi Indra,
> 
> My example was with regards to the SCEP client installation. Replace the  
> installation command with the silent install command for SQL Server 2008.
> 
> Regards,  
> Aditya
> 
> On Tue, Jul 8, 2014 at 3:18 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> Hi Aditya,
> 
> ```
> Have to run those scep code which installs client
> 
> ```
> 
> settings.  
> I dont understand,need to install scep client and sscm ah what it can do?
> 
> ```
> Because my problem is only running sql server silent
> 
> ```
> 
> installation commands it shows access denied error while running from  
> workstation.
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Monday, 7 July 2014 10:36 PM  
> _Subject:_ [chef] Re: Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi Indra,
> 
> I haven't tried the winrs method as the 'scheduled task' way I described  
> above sufficed for us. I'll try the winrs method sometime later and let you  
> know. Meanwhile you can try the scheduled task way as described in my  
> previous example and let me know if that works for you.
> 
> Regards,  
> Aditya
> 
> On Mon, Jul 7, 2014 at 2:16 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> Hi,
> 
> ```
> i have tried by giving
> 
> ```
> 
> winrs.exe -r:"WIN-J34DQLCH" wusa.exe /extract:"C:"
> 
> but it shows the system path can't specified.
> 
> I dont know how to give can u help me in this.
> 
> Thanks,  
> indra
> 
> * * *
> 
> _From:_ Aditya Karanjkar [aditya.karanjkar@relevancelab.com](mailto:aditya.karanjkar@relevancelab.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _Cc:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 4 July 2014 12:12 AM  
> _Subject:_ [chef] Re: Re: Re: RE: sql server 2008 silent installation
> 
> Hi,
> 
> May not be related but I hit the similar (access denied) issues when  
> installing any windows package that might need to install a .msu update as  
> a part of the installation process. And as in your case, it runs perfectly  
> when chef-client is triggered from an administrative command within the  
> node itself. It might be related to the following issue:  
> [Windows Update Standalone Installer (WUSA) returns 0x5 ERROR\_ACCESS\_DENIED - Windows Server | Microsoft Learn](http://support.microsoft.com/kb/2773898)
> 
> I have hit this with SCCM client, SCEP client etc. It's a Windows  
> limitation and Chef cannot do anything about it.
> 
> My workaround was to create a scheduled task scheduled to run 'once' and  
> fire it off immediately. I don't think you can use the windows\_task  
> resource provided by the windows cookbook as it doesn't accept 'once' as a  
> valid schedule. I used the execute resource with 'schtasks' to do the same.  
> Give it a shot and let me know if it works for you:
> 
> Example:  
> execute "Task to install SCEP Client" do  
> command "schtasks /create /f /sc once /st  
> #{(::Time.now+1).strftime('%H:%M')} /tn Install\_SCEP\_Client /tr  
> "C:\Windows\Temp\Client\scepinstall.exe  
> #{node['scep\_client']['installer\_options']}" /RU  
> #{node['scep\_client']['sch\_user']} /RP #{node['scep\_client']['sch\_pass']}"  
> action :run  
> end  
> execute "Run SCEP Client installer task" do  
> command "schtasks /run /i /tn Install\_SCEP\_Client"  
> action :run  
> end
> 
> Best Regards,  
> Aditya
> 
> On Thu, Jul 3, 2014 at 2:10 AM, Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com) wrote:
> 
> hi,  
> i have tried out by creating a separate account with admin rights  
> also in without admin rights still it shows "access denied"
> 
> ```
> Inner exception type:
> 
> ```
> 
> System.Security.Cryptography.CryptographicException  
> Message:  
> Access is denied.
> 
> Thanks,  
> Indra
> 
> * * *
> 
> _From:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)  
> _To:_ "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Sent:_ Friday, 27 June 2014 6:11 PM  
> _Subject:_ [chef] Re: RE: sql server 2008 silent installation
> 
> Thanks for response,
> 
> ```
> Actually my sql server 2008 r2 standard edition
> 
> ```
> 
> cookbook is working fine when i run chef-client from a target node .
> 
> ```
> When i run this as
> 
> ```
> 
> knife winrm name:"WIN-DQ00DBBP3I1" 'chef-client' -x administrator -P  
> "password" -a ipaddress
> 
> it shows a following error which i sent.
> 
> I think also same the problem is in permission,like when i run chef-client  
> in administrator user.so i create another account without have admin rights  
> ,again when i run chef-client from a command prompt not even workstation it  
> shows pemission denied errror to c:/chef/cache
> 
> * * *
> 
> _From:_ Kapil Shardha [Kapil.Shardha@SimulationIQ.com](mailto:Kapil.Shardha@SimulationIQ.com)  
> _To:_ Indra k [indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com); "[chef@lists.opscode.com](mailto:chef@lists.opscode.com)" \<  
> [chef@lists.opscode.com](mailto:chef@lists.opscode.com)\>  
> _Sent:_ Friday, 27 June 2014 5:26 PM  
> _Subject:_ [chef] RE: sql server 2008 silent installation
> 
> 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:indra.k@cloudenablers.com](mailto:indra.k@cloudenablers.com)]  
> _Sent:_ Friday, June 27, 2014 3:19 AM  
> _To:_ [chef@lists.opscode.com](mailto:chef@lists.opscode.com)  
> _Subject:_ [chef] sql server 2008 silent installation
> 
> Hi
> 
> ```
> 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:   
> 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)