asked on

Sharepoint 2013 Ent Migration Issue - Error 500 SSRS

Installations.
1.      SQL Server 2012 Standard SP1
a.      SQL Server Reporting Service Native
b.      SQL Server Reporting Service for SharePoint
c.      SQL Server Reporting Services Ad-In for SharePoint
d.      SSRS Configured (web service and report web site)
2.      SharePoint 2013 Server
a.      SSRS Service Running
b.      SSRS Server Application Configured.

Issues:
1.      Error 500 when browsing to systems Settings for SSRS Service application from Central Administration
2.      Same error when configuring SSRS from front end web application

Troubleshooting done

1.      Repaired SQL Server 2012
2.      Removed SSRS for SharePoint Ad-In and re installed
3.      Reconfigured SSRS service application and services multiple times.
4.      Downloaded SQL Server 2012 SP1 again and tried to repaired SQL Server

Findings
1.      Folder missing : 15\WebServices\Reporting (SSRS for SharePoint with SP 2013 and SQL 2012 should have this folder) instead the folder got created on 14\Webservices\Reporting
2.      SharePoint is looking for SSRS web services under ‘15\WebServices\Reporting’ which is missing
3.      Research found this is becase SQL Server 2012 SP1 not installed
4.      Verified the SQL Server 2012 version, its 11.0.2100. it should 11.1.3000.0 or higher. http://blog.randomdust.com/index.php/2013/01/ssrs-sharepoint-2013-and-sql-2012-standard-edition/

Need any help. This has been a huge issue. We had a consultant working on this and they can't figure it out.

ASKER CERTIFIED SOLUTION

Walter Curtis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SBSWIZARD

ASKER

Thanks. Went through most of this with Microsoft.

At this point, we think we may have moved on to an IIS issue which I am waiting for them to call me back on.

But that link surely does help.

Walter Curtis

Glad that helped and thanks!