Monday, March 26, 2012

Report Deployment Error on --http://localhost/reportserver

I am getting the following ERROR!! below when I try to DEPLOY my report. The output generated from - Debug --> Start
-- Deploy started: Project: Report Project1, Configuration: DebugLocal --
Deploying to http://localhost/reportserver/?%2fReport+Project1
Error rsReportServerDatabaseUnavailable : The report server cannot opena connection to the report server database. A connection to thedatabase is required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
=====================================================

When I try to go tohttp://<server>/reportserver a PROMT window pop up "Enter username and password for "" at http://localhost. Atthis point I'm pretty desperate to get it to work., I have been tryingfor couple of days. I reinstalled reporting services couple of timeswith no success. Any help would be greatly appreciated. Thanks!

-lalon

Hi it sounds to me the AspNet user or the user used in your dataset don't have access to your SRS database( "ReportServer" DB) . Check the permissions of the SQL Reporting Services database. Also you can't deploy to a server not running the SRS Server, unless you are on a SQL reporting server as localhost . I assume you clicked 'play' in VS.Net ? You need to deploy to a SRS Server.

No comments:

Post a Comment