SQL2008SP3 Enterprise Edition: Getting an exception when trying to set an execution account

Question

Hi Experts,

We have an SSRS installation on a box that has been running with an execution account for the last year or so. But recently when I tried to change the password for the execution account, I started getting an error like so:

System.Runtime.InteropServices.COMException (0x8004023F)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.SetUnattendedExecutionAccount(String userName, String password)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetUnattendedExecutionAccount(String userName, String password)

Could someone explain why this started happening suddenly? Let me know if you need any additional information from my side.

We are running SQL2008SP3 x64 Enterprise Edition.

Thanks,
Shahnaz.

Answer 1

Hi Shahnaz,

The error message you posted doesn’t provide much information. Here, I suggest that you remove the execution account first and then specify it again. To remove the execution account, please uncheck the “Specify an execution account” and click “Apply” in the “Execution Account” tab of the Reporting Services Configuration Manager.

If the issue persists, please post more related error details for further analysis.

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support

Answer 2

Hi Mike,

Apologies for the delay in responding to your reply. But when I tried to do as you suggested, I still get the same error - when I tried to remove the execution account, I still get the same error as when I was trying to change the password saying - "Unattended execution account could not be set at this time" and the same stack trace. I can't find any relevant messages in the event logs either. Is there any other place I can look for any relevant messages? So basically I'm stuck here - can't remove the execution account nor can I update the password so that the SSRS reports start working. Our SSRS reports are down because of this issue.

This is really annoying little error for us these last couple of weeks. Please advise.

Thanks,
Shahnaz.