Hi All,
We have a client, who has SharePoint 2013 Foundation and SQL server 2014. The requirement is to built SSRS reports in SharePoint integrated mode.
Servers available and Steps followed during installation
Server A : SQL Server 2014 with SP1 , which hosts Database Engine and SSRS services
Server B : SharePoint Server Foundation 2013 , with reporting services for SharePoint add-in installed in the same server
We also tried installing the binaries in the Server A, as per the microsoft blog
https://technet.microsoft.com/en-us/library/bb677365(v=sql.105).aspx#bkmk_Computer2_ToinstallaSharePointwebserverfontendontheSSRSserver
In Services on Server, the SSRS Service is up and running. Successfully created SSRS Service Application also.
But when i click on "System Settings or Manage Jobs" inside the newly created Service Application
------------------------------------
Sorry, something went wrong
The remote server returned an error: (500) Internal Server Error.
TECHNICAL DETAILS
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 8670119d-21c1-60ca-b08d-81edf3b9c337
----------------------------------
Based on the correlation ID:
06/18/2015 05:09:36.01 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Monitoring
nasq Medium
Entering monitored scope (Request (GET:http://sharepoint:100/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=5bc1ed00-5e87-42e1-9fd8-709a011c1ee8)). Parent No
06/18/2015 05:09:36.01 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Logging Correlation Data
xmnv Medium
Name=Request (GET:http://sharepoint:100/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=5bc1ed00-5e87-42e1-9fd8-709a011c1ee8)
8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.02 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Authentication Authorization
agb9s Medium
Non-OAuth request. IsAuthenticated=True, UserIdentityName=, ClaimsCount=0
8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.05 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Logging Correlation Data
xmnv Medium
Site=/ 8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.13 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Database
ahjqp High
[Forced due to logging gap, cached @ 06/18/2015 05:09:36.06, Original Level: Verbose] SQL connection time: 0.161542877656238 for Data Source=sharepointdb\igrsp;Initial Catalog=SharePoint_AdminContent_c91894e9-888e-4e84-a576-8f477821aceb;Integrated Security=True;Enlist=False;Pooling=True;Min
Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][SharePoint_AdminContent_c91894e9-888e-4e84-a576-8f477821aceb]
8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.13 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation General
g3qe High
[Forced due to logging gap, Original Level: Verbose] GetServerRelativeUrlFromUrl(http://sharepoint:100/_admin/ReportServer/ReportingServicesSystemSettings.aspx,True,False)
8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.22 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Database
ahjqp High
[Forced due to logging gap, cached @ 06/18/2015 05:09:36.13, Original Level: Verbose] SQL connection time: 0.137238112665157 for Data Source=sharepointdb\igrsp;Initial Catalog=SharePoint_AdminContent_c91894e9-888e-4e84-a576-8f477821aceb;Integrated Security=True;Enlist=False;Pooling=True;Min
Pool Size=0;Max Pool Size=100;Connect Timeout=15;Application Name=SharePoint[w3wp][2][SharePoint_AdminContent_c91894e9-888e-4e84-a576-8f477821aceb]
8670119d-21c1-60ca-b08d-81edf3b9c337
06/18/2015 05:09:36.22 w3wp.exe (0x2A28)
0x16A0
SharePoint Foundation Web Controls
ad9g2 High
[Forced due to logging gap, Original Level: Verbose] QoS data point list: []
8670119d-21c1-60ca-b08d-81edf3b9c337
--------------------------------------------------
Event Viewer
The Execute method of job definition Microsoft.ReportingServices.SharePoint.SharedService.Service.DoWorkTimerJob (ID 4e9e0de6-6912-4a5c-b50f-58c0ff82fc8b) threw an exception. More information is included below.
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 PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>IIS 8.5 Detailed Error - 500.19 - Internal Server Error</title>
<style type="text/css">
<!--
body{margin:0;font-size:.7em;font-family:Verdana,Arial,Helvetica,sans-serif;}
code{margin:0;color:#006600;font-size:1.1em;font-weight:bold;}
.config_source code{font-size:.8em;color:#000000;}
pre{margin:0;font-size:1.4em;word-wrap:break-word;}
ul,ol{margin:10px 0 10px 5px;}
ul.first,ol.first{margin-top:5px;}
fieldset{padding:0 15px 10px 15px;word-break:break-all;}
.summary-container fieldset{padding-bottom:5px;margin-top:4px;}
legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;}
legend{color:#333333;;margin:4px 0 8px -12px;_margin-top:0px;
font-weight:bold;font-size:1em;}
a:link,a:visited{color:#007EFF;font-weight:bold;}
a:hover{text-decoration:none;}
h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0'.
----------------------------------------------------
PLease help in this issue , to fix it .
Thanks in advance
Karthikanandh