SQL2014 Reporting Services

Hi Experts,

I have a SQL2014 AG cluster running.
Another monitoring tool called IDERA is installed on my Monitoring Server to send reports.
But I have to configure the reporting service.

How to find out, if the reporting services are installed ?
And how to install and configure it ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
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.

Deepak ChauhanSQL Server DBACommented:
You can check in SQL server configuration manager.
0
Deepak ChauhanSQL Server DBACommented:
If not installed you have to run sql server setup and add the reporting service in existing installation.
0
Eprs_AdminSystem ArchitectAuthor Commented:
Can you show me how to find out if the reporting services are installed ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Deepak ChauhanSQL Server DBACommented:
Please see in the image. Here i have installed multiple but you need only one.

reporting-SRV.JPG
1
Vitor MontalvãoMSSQL Senior EngineerCommented:
How many servers do you have? The Reporting Services might be installed in another machine.
By the way, that is the recommendation, to install SSRS in a different machine from SQL Server. Anyway you can check in all SQL Server instances if there's any database named ReportingServices since that is the name from the SSRS database. If you find none then means no SSRS is installed.
1
Eprs_AdminSystem ArchitectAuthor Commented:
I have 2 SQL 2014 machines in a AG.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
My question was about all servers in your infrastructure. Reporting Services might be installed in another server but yes, you can start to search for it in those 2 MSSQL machines.
0
Eprs_AdminSystem ArchitectAuthor Commented:
...ok SSRS are installed on this and nowhere else.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Good. Then now start Reporting Services Configuration Manager to check if is already configured or not.
0
Eprs_AdminSystem ArchitectAuthor Commented:
ok the SSRS are installed on both servers.

Which server name is more clever to put in the primary, secondary or Listener name of AG ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
More clever should be to install SSRS in a dedicated server and let the SQL Server to be in dedicated servers as well.
0
Eprs_AdminSystem ArchitectAuthor Commented:
ok I know what you mean, but I will go for the second in the AG, because it always standby.
1
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, that's the best option with your current configurations.
0
Eprs_AdminSystem ArchitectAuthor Commented:
ok, do you have a manual to configure the SSRS ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check this step-by-step tutorial.
0

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
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 SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.