Publish A Report Services Report to SharePoint

OK... I'm running out of things to try.

I have SQL Server 2005 SP2 installed and Reporting Services Addin configured. I am trying to publish a report from BIDS to SharePoint... but a box continues to pop up asking me for credencials.

What am I doing wrong? I have reviewed all the web.config files as per an earlier post referenced, but I only see one entry in the config file for the location tag. However, I did see this tag in two config files... not certain if that is something I should be concerned with?

I'd really like to just get a sample report up on the Sharepoint Server so I can move forward.

Can anyone help?

You can always just upload the .RDL file directly into SharePoint using the SharePoint web UI. When RS integrates with SharePoint, we tell SharePoint to handle .RDL files as Report Server items, and it doesn't really matter whether they get into SharePoint through Report Designer, or through SharePoint web UI.

I'm afraid I can't help with the Report Designer issue. I'll pass this on to someone who might know about it.

|||Please check Inetpub\wwwroot\wss\VirtualDirectories\80\web.config|||

What am I looking for when I go to Inetpub\wwwroot\wss\VirtualDirectories\80\web.config?

It does have one entry for location path=" _vti_bin...." as previously mentioned, a number of the web config files have this entry in it... but only once per file.

And just to clarify... I am using BIDS trying to deploy the report. The version of Visual Studio is: 8.0.50727.42.

|||I did that and surprisingly it worked... how does the report connect to the database? I did not upload or create a datasource? Well... actually I had manually created one in SharePoint in another library, but subsequently deleted it. The report still runs?|||Actually... I'll answer my own question... the first report used a custom data source... so that is why it worked. The second used a shared data source... it failed until I created the shared datasource|||

I've been running into this, too. Brian Welcker's blog solved it.

http://blogs.msdn.com/bimusings/archive/2007/02/07/reporting-services-login-dialog-appears-when-deploying-to-moss-wss.aspx