{"id":644,"date":"2013-11-22T09:00:02","date_gmt":"2013-11-22T16:00:02","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=644"},"modified":"2014-10-30T13:36:06","modified_gmt":"2014-10-30T20:36:06","slug":"ssrs-subscription-error-failure-sending-mail-the-report-server-has-encountered-a-configuration-error-mail-will-not-be-resent","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2013\/11\/ssrs-subscription-error-failure-sending-mail-the-report-server-has-encountered-a-configuration-error-mail-will-not-be-resent\/","title":{"rendered":"SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent."},"content":{"rendered":"<p>So, when a SQL Server Reporting Services subscription gives you an error message like: \"Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.\" You know exactly what to do to fix it right? Just fix the so called \"configuration error\". Problem solved! Another day another dollar. Am I right? Unfortunately, \"configuration error\" is sufficiently vague that it could be anything. \u00a0In my specific case it turned out to be caused by a subscription being \"owned\" by a user account which had been disabled.<\/p>\n<p>Use the query below to find your failed subscription and take a look at the username column. Is that account disabled? If so you can use our <a href=\"http:\/\/www.sqldbpros.com\/2013\/11\/change-the-owner-of-an-ssrs-subscription-the-simple-way\/\">world renowned change the owner of an SSRS subscription script<\/a>\u00a0to set things right.<\/p>\n<pre>USE ReportServer\r\ngo\r\n\r\nSELECT\r\n    d.SubscriptionID\r\n   ,e.name AS ReportName\r\n   ,e.path AS ReportPath\r\n   ,d.LastStatus\r\n   ,d.LastRunTime\r\n   ,u.UserName\r\nFROM\r\n    dbo.Subscriptions d \r\nJOIN \r\n    dbo.Users AS u ON d.ownerid = u.UserID\r\nJOIN \r\n    dbo.Catalog e ON itemid = report_oid\r\nWHERE\r\n    d.LastStatus = 'Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.'<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, when a SQL Server Reporting Services subscription gives you an error message like: \"Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.\" You know exactly what to do to fix it right? Just fix the so called \"configuration error\". Problem solved! Another day another dollar. Am I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,43,122,58,57],"tags":[20,10,60,9,12,11,117,59,173],"class_list":["post-644","post","type-post","status-publish","format-standard","hentry","category-businss-intelligence","category-microsoft-sql-server","category-ssdt-sql-server-data-tools","category-ssrs-reporting-services","category-t-sql","tag-business-intelligence","tag-ms-sql","tag-reporting-services","tag-sql-server","tag-sql-server-2005","tag-sql-server-2008","tag-sql-server-2012","tag-ssrs","tag-t-sql"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=644"}],"version-history":[{"count":6,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/644\/revisions"}],"predecessor-version":[{"id":763,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/644\/revisions\/763"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}