MCOURTIN


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




Re: Deploying reports to MOSS 2007

Brian Welcker - MS


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





Re: Deploying reports to MOSS 2007

MCOURTIN

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






Re: Deploying reports to MOSS 2007

Prash Shirolkar - MS

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