About this task
Follow these steps to start the SQL Server Reporting Services Configuration Manager.
Procedure
-
Start Report Server Configuration Manager. The Report Server Configuration Connection dialog box appears.
Note: If the Report Server Configuration Connection dialog box does not appear, you do not have SQL Server Reporting Services installed. For more information see Installing SQL Server Reporting Services for SQL Server 2019 and SQL Server 2017
- In the Server Name field, click Find to navigate to the appropriate server.
-
In the Report Server Instance field, select the correct SQL Server software instance name. Click Connect.
Figure 1. Instance selection
-
In the Report Server Status pane, verify Started is in the Report Service Status entry.
Figure 2. Report Server Status
-
In the left pane, click Service Account. Verify Virtual Service Account is in the Use built-in account field and click Apply. The outcome of the action appears in the Results window.
Note: SQL 2019 uses a Virtual Service Account in place of ReportServer.Figure 3. Service Account
-
In the left pane, click Web Service URL. The warning icon indicates that the report server Web Service is not yet configured.
Figure 4. Web Service URL
- Verify ReportServer is in the Virtual Directory field, accept the default values, and click Apply. The outcome of the action appears in the Results window.
-
In the left pane, click Database.
Figure 5. Report Server Database
-
In the right tab, click Change Database.
Figure 6. Change Database
-
In the Action tab, select Create a new report server database. Click Next.
Figure 7. Database Server Connection
-
In the Database Server tab, complete the following:
- In the Server Name field, type the name of the unified ADX server, or the database server if this is a split ADX. If you are using a SQL Server named instance other than MSSQLSERVER, add the SQL Server instance name in this format: computername\instancename.
- From the Authentication Type list, select one of the following:
-
Current User - Integrated Security if you logged in to the computer with the Administrator account. The Username and Password fields are dimmed.
-
SQL Server Account if you logged in to the computer with a user in the Administrative group. This selection is required on the web or application server of a split ADX with the Metasys Advanced Reporting System.
-
- If you selected SQL Server account, specify the username and password for the SQL server administrator (sa) account.
- Click Next.
-
In the Database tab, complete the following: (Figure 8):
- Specify ReportServer is in the Database Name field. If you use a SQL Server named instance other than MSSQLSERVER, add the instance name to the database name in this format:
ReportServer_<instancename>.
- Select Native for the Report Server Mode.
- Click Next.
Figure 8. Specify Database Name
- Specify ReportServer is in the Database Name field. If you use a SQL Server named instance other than MSSQLSERVER, add the instance name to the database name in this format:
-
In the Credentials tab, complete the following:
- From the Authentication Type list, select SQL Server Credentials.
- In the Username and Password fields, type the user name and password you created in Step 4 of Creating a new SQL Server user. (The recommended user name is SSRSServiceAccount). For a split configuration, type the appropriate SA account and password.
Figure 9. Credentials Dialog Box
-
Click Next. Review the summary details, and click Next to create a new report server database.
Figure 10. Database Confirmation
- The configuration process begins and completes in a few minutes. Make sure the result for each configuration step is a success. If any configuration is not successful, go to http://msdn.microsoft.com/en-us/library/ms159135.aspx for Reporting Services troubleshooting.
-
Click Finish on the completion screen. The configured Report Server Database screen appears.
Figure 11. Completion Window
-
In the left pane, click Web Portal URL.
Figure 12. Web Portal URL
-
The warning icon indicates that the Report Manager virtual directory name is not yet configured. In the Virtual Directory field, accept the default value or type a name, and click Apply. The outcome of the action appears in the Results window.
Note: The configuration of SQL Server software for the Metasys Advanced Reporting System is complete.