Post reply

Subscriptions not running

  • August 13, 2012 at 6:40 pm

    #265827

    Hello,

    I'm new to SSRS and am having problems with subscriptions. when I create a subscription FOR Windows File Share I get one of two outcomes.

    1. In My Subscriptions, I set the report to run once at a scheduled time (1 or 2 minutes in the future), but when the time comes the "Last Run" field is blank and "Status" shows New Subscription.

    2. It will show the last time it ran, but under Status it shows "Failure writing file <File Path> : Logon Failure: The target account name is incorrect.

    The account Name is set as a system admin for the site and a Content manager for the Database, Report, ect (everything)

    Any Help would be greatly appreciated,

    David92595

  • August 13, 2012 at 7:46 pm

    #1525352

    Hi.

    you can see error history of your subscription in "dbo.sysjobhistory ". As each subscription is a sql job.

    http://msdn.microsoft.com/en-us/library/ms174997

  • August 14, 2012 at 1:45 am

    #1525375

    When you create the subscription you should of given it a username and password, that user needs access to the file share your saving to in the subscription.

  • August 14, 2012 at 9:51 am

    #1525612

    Thank Anthony,

    My issue was an inconsistency in usernames.

    Thank you both,

    David92595

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply