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.
SBSWIZARDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter CurtisSharePoint AEDCommented:
Been there, done that. Lost two weeks of my life because of SSRS. This link was the answer to how to set it up and get it working correctly:

http://blogs.msdn.com/b/biblog/archive/2012/12/04/installing-and-configuring-sql-reporting-services-on-sharepoint-2013.aspx

It appears that from SQL 2012 SP1 everything has changed and all documentation is out of date. I like the way the SP integration now works, but as I said, took me two weeks of following documentation etc.. and this is the third version of SSRS I have deployed over the years and about the 20 deployment in different environments. But that article worked. Wish I would have found it first!

Hope that helps

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SBSWIZARDAuthor Commented:
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 CurtisSharePoint AEDCommented:
Glad that helped and thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.