Hi everyone. I am trying since yesterday to install and configure SSRS 2012 on SharePoint 2013. Although installation ends successfully and Service Application provisioning and configuration as well, when it comes to access “Reporting Services Site Settings” of any give site collection i get the following error :
An unexpected error occurred while connecting to the report server. Verify that the Reporting Services Service Application mapped to this web application is available OR the report server is available and configured for SharePoint Integrated mode. –> The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+msbin1). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: ‘<!DOCTYPE html>
<html>
    <head>
        <title>Could not find permission set named ‘ASP.Net’.</title>Â
Moreover when I try to access the “System Settings” of SSRS service via CA i get a 500 error with the same reason back in ULS.
Any help would be appreciated
Kyriakos,
Next I would ask you to double check your Claims to Windows Token Service Setup: http://support.microsoft.com/kb/2722087 and I would also double check the local security policy settings on each server in the farm with regards to the account you are running reporting services with, most likely the app pool account supporting Reporting Services – Security Settings > local Policies > User Rights Assignment > Replace a process level token. Next just double check the permissions on the SQL target and be sure they are correct also.
Â
Hi Rob. I use a separate apppool account for SSRS and I have set the kerberos constrained delegation end to end. I even downloaded a tool today from Microsoft checking kerberos delegation for SQL and all were “green”. But still the same annoying message.Â
You say SP1 for SQL can you run a discovery on post a version number for the RS server?
Kyriakos,
I am assuming you are using Kerberos. Are your Kerberos settings constrained from end to end? Also, I have found that the reporting services service application works best if you give it its own Application Pool and Application Pool Account that you can set the constrained delegation against, in case you have not already. I recently battled this same thing.
Rob
No patch for SP , SP1 for SQL. Configuration database version reported in the CA is 15.0.4420.1017
