Sharepoint Reporting services SQL feature install

Paul Walsh
Paul Walsh used Ask the Experts™
on
Hi All,

Hope someone can help. Half way through a 2010-2013 SharePoint Migration. I have run the SPtest against the old database and it has come up with a few error. One of which being that reporting services is not configured. I have been looking at the guide here: https://docs.microsoft.com/en-us/sql/sql-server/install/install-reporting-services-sharepoint-mode-for-sharepoint-2013?view=sql-server-2014 

Which says the SQL feature needs installing before enabling within SharePoint, I have the install files for SQL 2014. When I run them I do not get the SharePoint reporting options, either when running a fresh sql install or adding new features.

What am I missing?

Cheers,
Paul
SQL-Install.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Did you installed SQL SSRS - Reporting Services component? If yes, you need to start the SSRS Reporting services Configuration Manager and to configure that server in "SharePoint Mode" - please see details here:
https://docs.microsoft.com/en-us/sql/sql-server/install/install-reporting-services-sharepoint-mode-for-sharepoint-2013?view=sql-server-2014
Paul WalshSystem Administrator

Author

Commented:
Hi,

The URL posted is the same as the one I am looking at. To install SQL SSRS is this a separate option during the SQL install. When I ran the installer I selected all of the options. As per the article it states to run the installer again and add in the Reporting Services - SharePoint. As per the screen grab I do not have this as an option. Have I used an incorrect installer? I can see that reporting services is installed on the server as I can run reporting services configuration manager, is there some setup I need to perform or should I move onto stage two - setup within SharePoint? I have tried running the command it states in SharePoint Powershell - Install - SPRSService. I receive the exact error message it reports, but I cant see where it states what to do if you do get the error.

Sorry to be a pain I am obviously missing something.

Cheers,
Paul
Paul WalshSystem Administrator

Author

Commented:
I think I have answered my own question. I haven't installed it yet, but do you mean the add on provided by Microsoft that isn't part of the original installer - SQL Server 2014 Reporting services for sharepoint?

Cheers,
Paul
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

lcohanDatabase Analyst

Commented:
Which version/edition of SQL are you using as source for your install? In your screenshot you selected "Reporting Services native" already and I believe you can only have one SSRS per server - either "native" OR "Sharepoint" mode  up to SQL 2014 so if "native" is there already....
Since SQL 2016 you can have both Integrated (SharePoint) and Native side by side and more details about that are here:
https://whitepages.unlimitedviz.com/2016/03/ssrs-2016-integrated-native-mode/

Regardless - can you please try search on that server "Reporting Services Configuration Manager" and see if you have one already installed/configured in native mode?
Database Analyst
Commented:
From here:
https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/where-to-find-the-reporting-services-add-in-for-sharepoint-products?view=sql-server-2016

"SQL Server 2014 (12.x) Reporting Services Add-in for SharePoint Products
To download and install the add-in see the Microsoft Download Center:
Microsoft® SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint
The SQL Server 2014 (12.x) version of the add-in is also available in the SQL Server 2014 (12.x) Installation wizard:
On the Feature Selection page of the setup wizard, select Reporting Services Add-in for SharePoint Products
"
Paul WalshSystem Administrator

Author

Commented:
Hi,

I was using SQL 2014 express. I’m not back in the office until Tue now but I can let you know the exact version no then. Assuming that native reporting services has been already configured, I am guessing my only option is to scrap the install and start again? On the fresh install is it better to use the same installer I have, not install reporting services and then install the add on?

Thanks for your help,
Paul
lcohanDatabase Analyst

Commented:
If I'm not mistaken that SharePoint integration feature you are looking for is not available in SQL 2014 Express if we take for granted the list of supported features from Microsoft:

https://docs.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-2017&viewFallbackFrom=sql-server-2014
Paul WalshSystem Administrator

Author

Commented:
Hi,

Apologies for the delay on getting back to you. As it turns out the Reporting Services where not correctly configured within SQL or SharePoint. Only the Add in was installed. The Add in was all I needed to proceed with the migration. Incidentally SQL Express does not support the reporting services. the SQL 2014 ISO I Downloaded from Microsoft also didn't have the options required.

Thanks for all your help.

Cheers,
Paul

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial