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 [email protected]. To post to this group, send email to [email protected]. 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.
