Timed Subscription issue
I have SSRS 2005 installed and when I go to a SSRS report\Subscriptions tab\New subscription and select delivery method Windows File Share with UNC path and supply credentials used to access the file share and the select schedule. The report never runs and
the file share is empty and under History its blank. In the server Application event log is the following warning
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 5/26/2011
Time: 4:11:00 PM
User: N/A
Computer: SSRSserver
Description:
SQL Server Scheduled Job 'F1650A49-6788-441B-B3B7-B88BEDA9A46E' (0xC987614372BB4346877509C9EAB544D9) - Status: Failed - Invoked on: 2011-05-26 16:11:00 - Message: The job failed. Unable to determine if the owner (DomainName\SSRSserviceaccountName) of
job F1650A49-6788-441B-B3B7-B88BEDA9A46E has server access (reason: Could not obtain information about Windows NT group/user 'DomainName\SSRSserviceaccountName', error code 0x5. [SQLSTATE 42000] (Error 15404)).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
May 26th, 2011 4:26pm
Hi OkcThunderFan,
The error refers to "Access Denied" when it reported error code 0x5. It is basically a permission issue, and the domain account 'DomainName\SSRSserviceaccountName' may not have enough permissions within Active Directory to view / verify the mentioned user
accounts computed group membership, also known as tokenGroupsGlobalAndUniversal.
You may need to Added the SQL Agent service account to the Pre-Windows 2000 Compatible Access Group.
For more details, please refer to follows,
Some applications and APIs require access to authorization information on account objects
http://support.microsoft.com/default.aspx?scid=kb;EN-US;331951
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2011 1:20pm