Reporting Services Login Box always prompting when deploying my report

Question

Post reply

Reporting Services Login Box always prompting when deploying my report

Viewing 15 posts - 46 through 60 (of 72 total)

You must be logged in to reply to this topic. Login to reply

yipiha SSC Rookie Points: 46 More actions · Answer 1

Be sure to deply on 'http://SERVER/ReportServer' and not 'http://SERVER/Reports'

Michael Tocik SSCertifiable Points: 7039 More actions · Answer 2

Hi

On your project properties are you pointing the TargetServerURL to http://server/%5Bb%5Dreportserver%5B/b%5D?

Chad Crawford SSChampion Points: 11610 More actions · Answer 3

Thanks guys! I had this same issue again today and couldn't figure out what I had done last time to fix it. Your posts put me on the right track. You need the Web Service URL (not the Report Manager URL in the TargetServerURL property and any subfolders you want your report in go in the TargetReportFolder field, not appended to the TargetServerURL. Whew!

Thanks,

Chad

tathu2008 Valued Member Points: 59 More actions · Answer 4

Is your RS using other port than 80?

Provide port # if this is the case:

EXP: http://Servername:8080/ReportServer

Gook luck

drobinson-968235 Valued Member Points: 55 More actions · Answer 5

I have had various issues with this...and I am assuming that the problem you are describing is when you are deploying to a remote server. It is to do with your security settings (far from an expert on that one) and I believe that during the deploy process your local windows logon is being used. So far the only way I have got round this (successfully on a number of computers) is to logon to your machine with a username password that is valid on the remote machine/domain or add your username & password to the remote machine e.g. if you logon to your machine with Fred password Bloggs then create a local user on the remote machine with the same user name & password.

I have tended to create a deployment user that has local admin rights and then logon to my machine with this...this should enable you to deploy. If anyone has a more elegant solution (which there must be) then I would love to know.

Kevin Stump SSC Enthusiast Points: 186 More actions · Answer 6

drobinson-968235 why aren't you using Active Directory to control your security instead of logging everyone in as the same user. If you use AD you can control what reports different users are using. You can setup group security and per user security. I would not suggest signing in everyone with the same user name and password especially with local admin rights.

drobinson-968235 Valued Member Points: 55 More actions · Answer 7

we are controlled by the customer on the AD front....and it isn't everyone logged in only developers who are deploying reports. We did have one site that was using AD but we still encountered the same problem. Set up with AD? perhaps an issue with the configuration of reporting services? we had a general deployment user and and we could deploy remotely whenever we needed to (this was VPN from the office into the customers site)

RK-383011 Old Hand Points: 313 More actions · Answer 8

Make sure your Report Project properties: TargetServerURL is set to http://servername/ReportServer

bluepaperbag SSCrazy Points: 2055 More actions · Answer 9

I'm facing the same issue. Anyone knows the answer?

Kevin Stump SSC Enthusiast Points: 186 More actions · Answer 10

Look at grasshopper's response right before yours. That should fix your problem.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 11

Kevin Stump (1/14/2010)
drobinson-968235 why aren't you using Active Directory to control your security instead of logging everyone in as the same user. If you use AD you can control what reports different users are using. You can setup group security and per user security. I would not suggest signing in everyone with the same user name and password especially with local admin rights.

In SSRS 2005 the correct way to use Windows ACL (access control list) is to define authorization section in IIS. The reason Asp.net AD provider uses LDAP and IIS to resolve users permissions.

Kind regards,
Gift Peddie

jvillaro Grasshopper Points: 21 More actions · Answer 12

Hi, maybe this could be more simple than it seems.

I also had this problem before. If is the first time you are deploying, the target url is no the Reportmanager url, its the reportservice url.

If you click on the "help" button on the login window you get hen deploying you can see this note:

"Note If this is the first time you have published a report to a report server since set you set the deployment property TargetServerURL for a project, verify that the server name you specified is similar to http://localhost/reportserver, and not http://localhost/reports. Specifying the reports directory on the local server instead of the reportserver directory indirectly causes this dialog box to open. For more information about setting TargetServerURL, see How to: Set Deployment Properties (Reporting Services). "

Hope this helps

shalinder.verma Mr or Mrs. 500 Points: 539 More actions · Answer 13

I was facing similar problem but was managed to solve the problem.

My environment:

Vista Professional

SQL 2008 Express

Steps:

A. Fix Report Target Server URL.

1. In the Solution Explorer, Right Click Report Object.

2. Click Properties

3. There is only one Property Page - General

4. Check TargetServer URL. This should be - http://<machinename>/<reportserver>

<machinename> = name of your computer

<reportserver> = Virtual Directory

This you will get in Report Services Configuration Manager -> Web Service URL

<<<<Please note: Don't take Report Manager URL>>>>

B. Fix Service Account.

1. Report Services Configuration Manager -> Service Account

This should be LocalSystem or LocalService with Integrated DB access.

C. Deploy Project

This is the most crucial step.

DEPLOY the FULL Project again and not just the individual report - For the first time or whenever you change the settings.

Hopefully this should solve your problem.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 14

B. Fix Service Account.
1. Report Services Configuration Manager -> Service Account
This should be LocalSystem or LocalService with Integrated DB access.
C. Deploy Project
This is the most crucial step.
DEPLOY the FULL Project again and not just the individual report - For the first time or whenever you change the settings.
Hopefully this should solve your problem.

I am not sure your answer is relevant to this thread because you are in Express and this thread is about full SSRS, your first solution is not valid in Windows 7 because a named instace must use new account created by the person who installed the instance and most large companies deploy reports as needed based on defined requirements.

Kind regards,
Gift Peddie

brinzeuc Grasshopper Points: 11 More actions · Answer 15

Mrs Ivana,

We follow step by step your way to be able to watch a report from SSRS and it's work well

THX