Create Reporting Services Service Application in SharePoint

The Reporting Services service application must be running in one of the application servers, then only the reporting service feature can be used in SharePoint Integrated Mode.

The following steps must be executed to successfully create and configure the Reporting Services service application.

Verify the Reporting Services SharePoint service is installed and started

Go to SharePoint Central Admin Site
Go to System Settings Section and click on "Manage Service on Server"
In the Services Listing page look for the service "SQL Server Reporting Services".
If you did not see the service in the manage services page, then use the PowerShell command to install and start the service. By default this will be automatically installed and started during the installation of Reporting Service installation in Application Server. So no need run these steps unless you could not find the service in the Mange services page.
- Install-SPRSService (Run this PowerShell command to install the SQL Server Reporting Services Service).
- Install-SPRSServiceProxy (Run this PowerShell command to install the SQL Server Reporting Services Service Proxy).
- Get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance (Run this PowerShell command to Start the SQL Server Reporting Services Service).

Once the verification is completed and ensured that the SQL Server Reporting Services Service is running then we can create the service application.

Create Reporting Services Service Application

Go To SharePoint Central Admin Site
Go to Application Management Section and click on "Manage Service Application".
In Manage Service Application click on "New Menu"
Click on "SQL Server Reporting Services Service Application" that brings up the new service application screen as in the following.
Specify a Unique Name in Create Service Application Screen.
Create a new web Application pool Service Application by selecting the option "Create new application Pool" and specify the application pool account.
Specify the Database Server and Database name
Specify the Authentication method to the database. If you don't want to use the service application's application pool account for connecting to database then use the stored credentials option.
Specify the Web Application Association
Click "Ok" to create the Service Application
Wait for the operation to complete
After completion it will show a success message and link to provision the subscription and alerts.
Ensure the Service Application Shows up in the Manage Service Application Page

Now the service application is ready to use in the SharePoint Farm.