Avatar of SBSWIZARD
SBSWIZARD
Flag for United States of America 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.
Microsoft SharePointMicrosoft SQL ServerSSRS

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Walter Curtis

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes