Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

 
discard

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.