User Subscription. Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.
Hello,I have the following problem in SQL2008 SP1 Report ServerNative mode. The report has a few subscriptions. If subsription is organized by report server Administrator it works fine. But if it is created byregular user with correspondent permisionstwo issuesare observed:1. Email is not picked up automatically it should be name@domain.com. But only name is picked up. However owner name is correctly set up:domain\name2. The subscription rises subj exception.I tried to compare admin and usersubscriptions, they are identical.Then I have changed OwnerID field in ReportServer..Subscriptions table. After that subscription works fine.But I do not like this solution. If I change ownership, the user would not be able neither modify nor browsethe subscription.May be somethingwrong with impersonation of usersubscrioption, not sure. But I have no such kind ofproblems in Sharepoint mode.
July 23rd, 2009 1:50pm

Do you see any errors in report server log files for the failed subscriptions.You might want to try switching on the verbose logging for more detailed errors.
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2009 6:42am

Yes, I can seethe followinglog entries:library!WindowsService_0!79c!07/24/2009-08:00:43:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. library!WindowsService_0!604!07/24/2009-08:00:43:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.I gess I have to change service account from NETWORK SERVICES to domain oneThanks for the tip.
July 24th, 2009 1:28pm

Thats right. let me know if it works
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2009 9:50pm

Check this link for the login issue http://blogs.msdn.com/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx
July 30th, 2009 4:54pm

According to this article to work underdomain accountI have to get rid of <RSWindowsNegotiate/>entry in the following configuration section:<AuthenticationTypes><RSWindowsNegotiate/><RSWindowsNTLM/></AuthenticationTypes>When I switch to domain account with NTLM authentication I am able to to avoid authorization dialog to get access to report manager. ButI have gotnew error like this. Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.What is that?Domain accountcan not get access to sql server?That isweird, I used to use this account in all sql tasks, even sql server works under that account on the same box.The more I dig, the more problems I have.
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2009 3:30pm

I think I have got this issue: http://support.microsoft.com/?kbid=842423When I try to switch to domain account I have another problem: when user get access to report manager first of all he sees the authorization dialog which does not accept user credentials at all. So, Network Service account allows to get access to report manager smoothly, but does not work with Active Directory and vice-versa.As it was advised in Method 1 of kb, ReportServerMachineName\Network Service account should be added to AD the Pre-Windows 2000 Compatibility Access group. I am not sure that is the best solution.Therefore, I have to rephrase my question: How to avoid authorization dialog to get access to report manager if Report Server service account is under domain user?In RS 2005 there was anonymous access IIS settings. In 2008 I can't change this behaviour in RS configuration snap-in.
August 5th, 2009 3:33pm

did you ever got this fixed? im also stuck with this issue...Thanks...
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 7:38pm

We had the same issue and managed to solve it using the steps set out in http://support.microsoft.com/?kbid=842423 We had to apply Method 1 and Method 2. We added the service account running the SQL Agent + Reporting Services to the Active Directory security group “Windows Authorization Access Group”, this allows those accounts to read all user properties in the domain, this is only applicable to domains running in Windows 2003 Native Mode. It’s basically just the steps in method 2 + 3 combined although the MS doc never mentions you need to do it on the Agent service account as well but it is indeed needed.
August 2nd, 2011 5:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics