Strange problem with RS 2008R2/2012 subscriptions

• Roust_m

  SSCoach

  Points: 17408

  More actions

  May 7, 2014 at 9:12 pm

  #285391

  Hi,

  I am running two servers with reporting services, one 2008R2 and another 2012. After I create a subscription, the subscription fails with this error:

  "Failure sending mail: The report server has encountered a configuration error. Mail will not be resent."

  Our tech support team member did the same and it worked for him.

  I did the below workaround setting him as the owner of all subscriptions:

  update [ReportServer].[dbo].[Subscriptions] set OwnerID = '61AEA956-C62F-43DD-9B34-CB573918E4A3'

  where OwnerID <> '61AEA956-C62F-43DD-9B34-CB573918E4A3'

  And it worked.

  We don't want to use this workaround on a permanent basis, as there are many people who are allowed to create subscriptions and it would be a trouble each time to update the system table.

  What could be a reason for this? I have the third RS 2008R2 server where everything works normal even for my account.

  Any ideas?

  Thanks.