up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

3 Answers

up vote 1 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

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

link|improve this answer
feedback
up vote 0 down vote

I had a similar situation. It was resolved by changing the deployment/server URL from:

servername/reports

to

servername/ReportServer

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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