Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Get login prompt for SQL reporting services deployment.

I really just want to deploy a report.

I have -set my Web Service URL to be "ReportServer"

-I have tried several different service accounts.

-tried many different passwords for this dialog (but my understanding is if all is well you will not see this dialog)

What else do I need to try? What could I be doing wrong?

share|improve this question

SSRS for SQL 2008 always requests authentication. Use the Report Manager URL (servername/reports). Someone will need to give you access to the report server via the Report Server UI or SSMS connecting to he Report Server.

There's a bunch of log info in the ReportServer folder in C:\Program Files\Microsoft SQL Server\MSRS.MSSQLSERVER... that can show you why it's failing. Also check out the application log.

share|improve this answer

If i remember correctly there's a sqlserver2005ReportingServicesWebServicesUser$ windows group. Try adding your admin in there. The rest of the security settings should be available from the reporting services page

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.