Post reply

SQL SERVER REPORTING SERVICES 2000 QUERY

  • September 22, 2010 at 7:49 am

    #238579

    Hi,

    We are using SQL reporting serivces 2000 in our system. This is deployed in WIndows Server 2003 R2 and works fine when we run the reports manually. i want to Automatrically scheduled the report to save our report in file sahre. i tried Subscriptions giving all the details required but the subscription is not initiating and not saving any file. No errors in event viewer exither in report serbver or SQL server Please help. Below shows the subscription page. Am i missing any settings whioch need to be included

    Report Description Folder Trigger Last Run Status

    Case Save in \\35.96.8.31\test as Cas /Message Hub Reports TimedSubscription New Subscription

  • September 23, 2010 at 10:55 am

    #1226466

    Make certain that the user that you are connecting with has the appropriate rights on the share. That user needs modify or above on the share and write or above on the NTFS permissions for the folder.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 24, 2010 at 2:27 am

    #1226761

    Yes... Using the Doamin level account which has all the permissions required. Even Eventviewer doesn't show any errors. Any help?

  • September 24, 2010 at 6:10 am

    #1226887

    Does the execution log of the SSRS database give you any clues?

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 29, 2010 at 6:11 am

    #1228922

    Yes... Able to fix the issue. Job was failing due to server access. Need one more help. I have set the parameter but when i set the subscription on default parameters there is no output coming.

  • September 29, 2010 at 6:29 am

    #1228928

    did the same parameter giving result in the manual report execution?

    Thanks,

    Veeren.

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • September 29, 2010 at 6:31 am

    #1228929

    Yes....

  • September 29, 2010 at 6:36 am

    #1228936

    oh...i belive that the subcription has issues with the report parameter if you are able to get the o/p with out any parameter!

    No idea in 2000.we can go for linked reports.

    thanks,

    veeren.:)

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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