Not seen in the picture below – sorry.Īfter clicking the “Apply” button, a series of messages will be displayed on the bottom “Results” pane. Verify that all information is correct and click on “ Next“.īack to the “Reporting Services Configuration Manager” window, click on “ Web Service URL” and click on “ Apply“. In this case, my goal for installing SQL Server Reporting Services is to be able do run reports against the SCCM database so, I’m calling it CM_S01_SSRS, being CM_S01 the name of the SCCM database and SSRS the acronym for SQL Server Reporting Services. Select “ Сreate a new report server database.” and click “ Next“.
On the left-hand side menu, click on “ Database” and then on “ Change Database“. If you get an UAC prompt, just click on “ Yes“.Ĭhoose the SQL instance and click “Connect”. When the installation finished, click on “ Close” to exit the wizard.Ĭlick on the “ Start Menu” and search for “ Reporting Services Configuration Manager“. Leave the default service account and click “ Next“. Select “ Reporting Services – Native” and press “ Next“. Select “ Add features to an existing instance of SQL Server 2016“, choose the appropriate SQL Server instance and click “ Next“. That is covered in the article Install SQL Server 2016, which I believe you read before coming here. If you only get the Windows Firewall warning, never mind about it. If you get any warning you’ll have to click on the link corresponding to the warning, under the Status column. SQL Server setup will now check for updates.Īnd it will check if the computer is ready to resume the setup. If you want Microsoft Update to check for updates, check the corresponding checkbox and press “Next”. If you already have an instance of SQL Server installed, continue reading.īrowse to the location where you downloaded the SQL Server media and run SETUP.EXE.Ĭlick on “ New SQL Server stand-alone installation or add features to an existing installation“.
If you haven’t yet an instance of SQL Server 2016 installed, please read how to install SQL Server 2016. Install SQL Server 2016 Reporting Services I will then install, in a future post, the SCCM Current Branch Reporting Services Point so that I can run reports in SCCM!
In this article I will install SQL Server 2016 Reporting Services.
0 kommentar(er)
