Urgent Please: Cannot publish Reports to the Sharepoint Integrated  - Reporting Services Login
Hi, Sharepoint 2010 / SQL Server 2008 R2 The user I am using in BIDS to deploy the reports has Admin permission to the site collection and databases. Reporting Services Login prompt all times and I cant go ahead to publish the reports. I ve reviewed my deployment properties - http://msdn.microsoft.com/en-us/library/bb283155(SQL.90).aspx The same test works to my dedicated server (Sharepoint and SQL Server in the same machine) but not to the enviorement bellow: Server 1 - SSED, SSAS, SSRS, Sharepoint Web Front (minimal installation) Server 2 - Sharepoint Server 2010 (SSRS Sharepoint Integration Mode) Ive read all the discussions and articles I couldnt find anything conclusive. Please, any clues?! Thanks in advance, Alex Berenguer
July 24th, 2012 10:54am

Hi There Thanks for your posting. This happens sometime if Anonymous is On for the web application. Turn it off from Central Admin site for this web application and try deploying again using BIDS. If you are trying to deploy to Central Admin site. Have you enabled SSRS feature in that site collection? The feature is not enabled on Central Admin site by default when you install SSRS. You might do this from the Site Settings -> Site Collection Features link. Activate the Reporting Services feature please have a look yourself for more information you can have alook on this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0f64e613-c834-486f-9281-6e9201f4f0f9/ http://social.msdn.microsoft.com/Forums/en-CA/sqlreportingservices/thread/5dae7e15-baf3-499a-b3ea-4549c2133fbc I hope this will help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 6:53pm

Hi Syed, thank you so much for your help. I have already spent many hours in order to solve this issue but nothing so far. The Web Application I created to test it has a Business Intellicente Center as Site Collection. The Report Services features is running on it. I checked it. Thanks. Follow more details I ve discovered: Here's the scenario: I have a Web Front End (WFE) server, and an Application Server (AS) in a Sharepoint 2010 Farm. The configuration database, content database, etc.. are located on a clustered SQL 2008 R2 instance on another set of machines. I have installed SQL 2008 R2 Reporting Services w SP1 on the AS. I have installed the SQL 2008 Reporting Services Add-In for Sharepoint 2010 on the WFE. I have gone through all the configuraiton settings, set the SPNs for the service accounts, etc... The Excel Services with external data, for example, is working fine. When the reporting services integration is set to "Trusted Account", I can deploy reports to the server with no problem, EXCEPT that I can't deploy data sources that use "Windows Authentication" as their credentials, which is desirable for our implementation. When I switch the reporting services instance to "Windows Authentication", I can no longer deploy projects to the report server. When I go to deploy the reports, I continually get a "Reporting Services Login" prompt, showing the server it is being deployed to, and requesting a username and password. No combination of username and password works. Here's a fun little bit for you too, if I continue to try to login to the server, I will eventually (after hitting the GPO threshold) lock out my account from Active Directory. This I found out after nearly creating a set of tracks down my scalp all day today trying to figure out what was happening to my sharepoint sites while I was debugging this.... So it seems that it is trying to authenticate my login credentials through BIDS, but is unable to do so. Also, when I attempt to "Manage Datasource" directly through the Sharepoint interface I am getting 401 errors. I appreciate any assistance. Thanks a lot. Alex Berenguer
July 24th, 2012 9:44pm

Hi everyone, We were able to solve the problem by setting the right SPNs to the accounts for Reporting Services and changing the rsconfig file to listen to Kerberos authentication. Thanks everyone! Alex BerenguerAlex Berenguer
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 1:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics