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.

Report deployment

Hello,

I have two questions:

1. When I debug my application it seems it deploys reports to report manager, how can I prevent that from happening, I would like to deploy when I chose deploy command only?
2. I have a report which has many sub-report, when I deploy sub-reports are deployed to report manager to and they become visible in the report manager screen., so user my chose and try to run them, I would like to make only my main report be visible on the report manager, is there anyway to accomplish this?

Thanks,

Disable the deploy of your project in the configuration for the solution in debug mode.

Report Builder Query

Can we view the query that is fired on the Report builder to debug as i am finding some error in data...

Can you run SQL Profiler to get the SQL command that is sent to SQL Server?

Jarret

|||

http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx tells how to do it.

R