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

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

Other recent topics Other recent topics