Eprs_Admin
asked on
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 ?
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 ?
You can check in SQL server configuration manager.
If not installed you have to run sql server setup and add the reporting service in existing installation.
ASKER
Can you show me how to find out if the reporting services are installed ?
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.
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.
ASKER
I have 2 SQL 2014 machines in a AG.
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.
ASKER
...ok SSRS are installed on this and nowhere else.
Good. Then now start Reporting Services Configuration Manager to check if is already configured or not.
ASKER
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 ?
Which server name is more clever to put in the primary, secondary or Listener name of AG ?
More clever should be to install SSRS in a dedicated server and let the SQL Server to be in dedicated servers as well.
ASKER
ok I know what you mean, but I will go for the second in the AG, because it always standby.
Yes, that's the best option with your current configurations.
ASKER
ok, do you have a manual to configure the SSRS ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.