Need to create an id for an application to execute reports....

  • I'm new at reporting services and am not certain of the best way to do this.  I'm not interested in creating a domain account to the app to use, therefore would I create a sql server login and then give it "browser" permission to report manager in the folder that holds the reports?

  • For exexuting reports, you can use a SQL Server Account.  But when you say the "app," are you refrerring to Report Manager?  If so, by defauly only NT authentication is available for a user to browse folders and reports.  You're other option is to use forms authentication which requires custom code to implement.

  • When I say app, I mean there is a web application in developement that needs access to run reports created in SQL Serverreporting services.  How do I do that?  If I use a SQL Server login, what permissions do I give it to be able to run these reports?

    The report goes against an Oracle data source.  I don't know if that makes a difference.

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

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