Logon and Password prompt when Deploying Reports

[GrandMauler]

I've created my report using BIDS and am ready to deploy it.

When I try to deploy it, I get a prompt for Logon and Password. When I input both, it prompts me again, suggesting it is rejecting my logon and password.


I've already confirmed that I have Admin permission for both the OS and SQL Server.


But it wont accept my logon.


What am I doing wrong?

 

[ptheriault]

I think it wants the login and password of your datasource. and if you have more than one database connection you get prmoted for each db.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[GrandMauler]

I did find the following fix... for SQL 2000

http://support.microsoft.com/kb/842517

I'm still searching for the Fix for 2005

 

[GrandMauler]

@ptheriault - No, I don't think that's it. I've assigned a role to the Cube the report uses as a data source, complete with my full logon profile.

I've made sure that all access to secure data sources are accounted for. However, I can always double check.

 

[GrandMauler]

I guess I should've mentioned that I'm remoting into the computer with the Report Server. That seems to be important.

 

[GrandMauler]

Ok, I found the answer in the following link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1675815&SiteID=1

But the short of it is this:
Change your TargertServerURL from

http://servername/reports

to

http://servername/reportserver.

After I did this, it deployed fine.


I hope this helps!!