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 [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/c2e50c29-51d3-41cb-b0ad-b36d69ba8320%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
