Fun with SSRs Article 1-Report service configuration

The report service is a component of Microsoft sqlserver Business Intelligence. With the help of the report service, you can create a variety of reports, whether simple or complex, at the same time, the system provides the subscription function to facilitate users to subscribe to reports. In addition, developers can easily integrate an SSRs report into their own winform or webformProgram.

This article describes how to configure the report service after the report service is installed. Through this article, you will have an understanding of how to build and configure the analysis service instance locally.

SQL Server's report Service supports local mode from 2008. That is to say, if you want to install the report service, you do not need to install IIS separately in the operating system, the Local Mode of the report service saves the trouble of installation and configuration by using IIS similar to Mini.

After the analysis service is installed, first confirm that the Data Engine service and report service have been started. We recommend that you disable these services when you do not need them. Each Service consumes a certain amount of CPU and memory resources.

Open Reporting Services Configuration Manager. Connect to the installed Report Server instance. All post-installation configurations of the report service are performed in this tool.

Click the Web Service URL in the list on the left to configure the service address.

Generally, you can use the default settings here. Click Apply directly.

After setting, you can see that the yellow warning block has disappeared. You can see the processing steps in result.

After the Web Service URL is configured, click Database Configuration to support the database of the Report Server. Click Change Database.

Select create database.

Select the server where the database is located.

Specify the database name.

Authentication information.

Summary information.

Start generating the database. The tool will generate the corresponding database script based on the settings in the Wizard just now and then deploy it to the target server.

Generation is complete. The databases to be supported by the running of the report service are all generated here.

After the database is created, create a report management address.

Click the report manager URL on the left. Click Apply directly according to the default settings.

The report management address is created.

Next, open the report service address. If you are not sure about the address, return to the report service address page and click the shortcut on the right.

Before entering the report page, you are prompted to enter the verification information.

We recommend that you use the local administrator account to log on. (In my windows 8 + SQL Server 2012 environment, even if my account has the right administrator permission, a permission error is prompted, check the network and use the original Administrator Account to log on)

The following page is displayed, indicating that the report service is successfully configured.

As mentioned above, if you use the Administrator account every time, it is quite troublesome, so configure the corresponding permissions for your account.

The first is the permission to log on to the management interface. Log On with the Administrator account and click site settings.

Click security on the left side, and click New role assignment.

Enter the name of your current Administrator Account in group or user name. Then circle "System Administrator" below ".

Click "OK" and then click "home" in the upper left corner of the page to return to the home page. Click "folder Settings" to ensure that your administrator account has the publish and browse functions.

Click new role assignment.

Enter your Administrator name in group or user name, circle all the permissions below, and click OK.

In this way, using your administrator account to log on to this administrator interface and subsequent release and browsing will not be difficult.

 

Now, the configuration of the report service is complete. The configuration method described in this article focuses on the simple and fast configuration of local development. The actual production environment and the SSRs deployment in moss may be slightly different. For specific methods, refer to Microsoft's documentation.

The next article describes how to create a simple report.