SQL Server 2012 / SSRS. Windows 2008 R2. When trying to access the Report Manager via URL (http://servername/reports), it prompts us for a username and password. When I enter a valid user/pass it works and I can get to the Report Manager site and run reports fine. But we don't want to be prompted, we don't even need Windows Authentication, just to go strait in to the page. Any ideas why its asking for a username and password and how I can allow direct access?
2 Answers
You need to store the credentials in the report.
You can store the credentials used to access an external data source. Credentials are stored in reversible encryption in the report server database. You can specify one set of stored credentials for each data source used in a report. The credentials you provide retrieve the same data for every user who runs the report.
Stored credentials are recommended as part of a strategy for accessing remote database servers. Stored credentials are required if you want to support subscriptions, or schedule report history generation or report snapshot refreshes. When a report runs as a background process, the report server is the agent that executes the report. Because there is no user context in place, the report server must get credential information from the report server database in order to connect to a data source. The user name and password that you specify can be Windows credentials or a database login. If you specify Windows credentials, the report server passes the credentials to Windows for subsequent authentication. Otherwise, the credentials are passed to the database server for authentication.