Post reply

SSRS 2005 - Windows Authentication VS Report Schedule

  • June 14, 2009 at 7:16 pm

    #206016

    Hi,

    I am using SSRS to build financial reports for a travel company. One of the requirements is that a DBA can log into the database and execute sp_who to see what is currently executing a report query. (Domain name) The second requirement is the end user should be able to schedule a report. I am having real issues getting these two requirements together. If I use Windows Authentication in report manager, I can see who is running what, but I cant schedule a report. If I change it to "Credentials stored securely in the report server", I then no longer can tell who is running what as I am now connecting as the same user for all report queries. I have tried to enable the unattended execution account, but still no luck. I get the following error: "

    The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"

    To recap. I need to use Windows Authentication to see who is running what, and I need the user to be able to schedule a report.

    Any help will be appreciated.

    Thanks

  • June 15, 2009 at 6:34 am

    #1009589

    I too would love to know how this could be done

    I am using SSRS 2008.

  • June 15, 2009 at 7:18 am

    #1009625

    Hi there,

    I don't think you can achieve that easily. If I'm not wrong, there's no way to identify who's running the report if you store the credentials inside the report using SQL, but you might be able to do so in IIS.

    Because you're using SSRS 2005, you'll have on the IIS logs an entry for every user accessing the SSRS site. Then, you can use something like LogParser to extract that information.

    I know it's not in realtime like sp_who (IIS records the entries on the logs with a little delay), and of course you need access to the IIS logs, but it's a way to see who is or was running reports and still be able to provide the scheduled reports functionality.

    Hope this helps,

    Alejandro

    Alejandro Pelc

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

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