Hi All,
i am trying to install SQLServer in silent mode on remote windows machine using ansible. in middle of execution its failed with below error. my target host is Azure Windows. 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Action: Calculating default service account for AS engine Service 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Data: User Name = NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Data: Role= 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Data: Is Domain Controller =False 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Sco: Attempting to determine if the password is required for account 'NT AUTHORITY\SYSTEM' 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Sco: Attempting to determine if the account 'NT AUTHORITY\SYSTEM' is Virtual Account 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Sco: Attempting to get local system account name 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Sco: Attempting to get NT account from sid S-1-5-18 2018-01-30 12:27:47,300 [StandardOutput] INFO PATools - Sco: Attempting to get account from sid S-1-5-18 2018-01-30 12:27:47,315 [StandardOutput] INFO PATools - Sco: Attempting to get account sid for user account NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,315 [StandardOutput] INFO PATools - Sco: Attempting to get sid for user account NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,315 [StandardOutput] INFO PATools - Sco: GetSidForAccount normalized accountName NT AUTHORITY\SYSTEM parameter to NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,315 [StandardOutput] INFO PATools - Data: User Name = NT AUTHORITY\SYSTEM after calculating default service account. 2018-01-30 12:27:47,315 [StandardOutput] INFO PATools - Result: Completed calculating default service account for AS engine service 2018-01-30 12:27:47,331 [StandardOutput] INFO PATools - Action Scenario: Install, Feature Scenario: Install, Resolved Scenario Install 2018-01-30 12:27:47,331 [StandardOutput] INFO PATools - Action Scenario: Install, Feature Scenario: Install, Resolved Scenario Install 2018-01-30 12:27:47,347 [StandardOutput] INFO PATools - SqlEngine: Calculating default service account for engine service. Current value of SqlAccount: NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,347 [StandardOutput] INFO PATools - SqlEngine: Completed calculating default service account for engine service. Final value of SqlAccount: NT AUTHORITY\SYSTEM 2018-01-30 12:27:47,382 [StandardOutput] INFO PATools - Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction" threw an exception during execution. 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: There was an error generating the XML document. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: There was an error generating the XML document. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.Security.Cryptography.CryptographicException: Access is denied. 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - at System.Security.Cryptography.ProtectedData.Protect(Byte[] userData, Byte[] optionalEntropy, DataProtectionScope scope) 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - at Microsoft.SqlServer.Common.SqlSecureString.WriteXml(XmlWriter writer) 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped) 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write7_SqlEngineSetupPublic(String n, String ns, SqlEngineSetupPublic o, Boolean isNullable, Boolean needType) 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterSqlEngineSetupPublic.Write8_SqlEngineSetupPublic(Object o) 2018-01-30 12:27:47,393 [StandardOutput] INFO PATools - --- End of inner exception stack trace --- The problem is how do i run .exe with Run as Administrator mode using Ansible. the current execution user is a part of Administrative group only. Please suggest how do i fix this. Please find complete installation log of SQLServer. Thanks, Suresh. -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscr...@googlegroups.com. To post to this group, send email to ansible-project@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/f308c642-2ab2-4bab-b789-14f7cecc90b2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
