February 10, 2009 at 8:55 am
Hi,
When trying to deploy a data source & model from BIDS to our Sharepoint site, I am now confronted with a 'Reporting Services Login' box. I have spent nearly two days trying to find a way to solve the problem, but to no avail. Our setup was working just fine until a week or so ago.
Setup is as follows:
Sharepoint & SQL Server 2005 are installed on the same server. I followed the instructions in the following document to set up everything initially, the only difference being that I used one domain account for both services in reporting services configuration rather than two separate ones. The account used is a domain administrator, and is also added to the local administrator group. > http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
Everything appears to work exactly as it should, bar the fact that I can't seem to deploy to the Sharepoint site. I have read countless articles about fixes for other users, including some on this site, but nothing has worked.
Things I have tried/checked:
Deployment URLs - These are correct, and were working fine until recently.
Blocked file types on Sharepoint
IIS authentication/directory security
Virtual directory setup
Account used to run Report Service
Web.config file of Sharepoint installation
Re-installation of Reporting Services, SQL Server 2005 SP2 & Reporting Services Add-in for Sharepoint
Re-installation of Reporting Services, installation of SQL Server 2005 SP3 & Reporting Services Add-in for Sharepoint (SP3 version)
I am at my wits end with this problem. Is there anyone out there who can shed some light on it, or who has any suggestions as to what I can do now?
Many thanks
Ash
February 10, 2009 at 4:45 pm
The solution is in here check your web.config and edit it so the prompt will go away.
http://msdn.microsoft.com/en-us/library/bb969101.aspx
Kind regards,
Gift Peddie
February 11, 2009 at 1:46 am
Thanks for the reply, however as stated in my original post I have already tried that.
Anyone else have any other ideas? 🙁
February 11, 2009 at 6:24 am
6. Edit the Web.config file and ensure that there is only one instance of the following XML element structure:
No you did not you said installed Web.Config that article said edit and make sure only one authorization element is in your Web.Config.
The other is to run aspnet_regiis in your C drive.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Kind regards,
Gift Peddie
February 11, 2009 at 6:44 am
I did not say I installed the web.config file, it would be there already as part of the installation anyway. I said I have tried/checked the following items and listed it as one of them. By checking it I mean that I have made sure it contains only one instance of the stated element, as this is one of the most common responses to this query I have found on the internet. Therefore it can be ruled out.
I have also tried aspnet_regiis, but no joy.
February 11, 2009 at 4:47 pm
It may be related to the identity of SSRS application so you need to create new account for SSRS or use Network Service for SSRS.
If you are in IIS 6 you may to remove it and add it again this time click on details to enable all the features needed to run Asp.net.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply