Deploying reports to MOSS 2007

Hello,

I wonder if anyone can help me save the few remaining hairs on my head? I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying.

Can anyone give me any clues?

Thanks,

Michael

What is the deployment location(s) that you are trying to deploy to? You are able to see the contents of the document library that you are deploying to?|||

The TargetDataSource Folder is http://vpc001/ReportingServices/DataSources, the TargetReportFolder is http://vpc001/ReportingServices/Reports and the TargetServerURL is http://vpc001/ReportingServices. I can see all of these locations.

When I try to deploy I get the Reporting Services Login window with the Server set to http://vpc001/ReportingServices.

Thanks for your interest in helping me understand what is going on here. Regards, Michael

|||

Can you make sure you are using the upgraded Report Designer that ships with SP2 CTP2 / CTP3?

btw, what Authentication mode (Windows Integrated or Trusted Account) did you use to setup the SharePoint Integration?

thanx,
Prash