I tried with Win_shell and Win_command module both are giving same error. On Tuesday, January 30, 2018 at 6:25:11 PM UTC+5:30, suresh sargar wrote: > > 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/c2e50c29-51d3-41cb-b0ad-b36d69ba8320%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
