SSRS Cannot Connect to HTTPS SharePoint 2010 401 Unauthorized
I have configured SSRS and the SharePoint integration and everything works fine without SSL turned on. I can create reports in SSRS (BIDS) and connect to SharePoint lists and they run. I can create reports through SharePoint document libraries and they run perfectly fine. As soon as I turn on "require SSL" in IIS for my SharePoint site I start running into problems. Suddenly I can no longer use localhost in my datasource connections in BIDS of course so that causes problems. As soon as I switch it to my public https:// URL I can no longer get it to work. I receive a 401 unauthorized error. I have tried adding an "execution account" to SSRS which didnt appear to help. I tried specifying credentials other than just Windows Authentication through the SSRS data source and that gives me another error saying that the addon doesnt support anything other than Windows Authentication. I tried connecting through Report Builder 3.0 through the web from a remote box and I get the same errors. using SharePoint 2010 Foundation and SQL Server 2008 r2 on Windows Server 2008 r2.
October 11th, 2012 11:06am
Hi Carson757, The issue may occur due to the mismatch of the certificate and the SharePoint Web Application URL. In other word, the localhost host name in the URL of SharePoint site cannot be validated by the certificate. Here, I suggest that you create a new SharePoint Web Application and specify a URL whose host name matches the certificate. Please refer to the following steps: 1. Click Internet Explorer-> Internet Options-> Content-> Certificates. 2. Make sure the certificate is installed in the Trusted Root Certification store. 3. Double click the certificate. In the Certificate dialog box, click the Details tab, and copy the value of the certificate Issuer. 4. Open SharePoint Central Administration, create a new web application, select Use Secure Sockets Layer (SSL) option, and specify the public URL by using the certificate issuer as the host name. 5. Open IIS Manager, edit Bindings of the new site, and speicify the certificate for it. 6. Create a site collection for the SharePoint Web Application. In this way, we should be able to use the new SharePoint site as a SharePoint List data source. Hope this helps. Regards, Mike Yin Mike Yin TechNet Community Support
October 18th, 2012 3:34am