Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Next, click the New button in the SharePoint menu and select SQL Server Reporting Services Service

Application as shown in Figure 12-20.

Figure 12-20. Creating a new SSRS Service Application

Enter a name and Application Pool to be used for this Service Application. From the manageability

perspective, it is a good idea to give them both the same name. As can be seen in Figure 12-21, mine is

named Professional SSRS 2012 Service Application for both. Depending on your security needs, change

appropriately. I used the default security settings for the SharePoint managed account. Scroll down and

set the database server, name, and authentication details appropriately. Last but not least, choose the

Web Application Association. In this case, there is only one web application to associate with. Click OK

to save your settings. After a few minutes, you should see a screen stating that your new service

application has completed successfully.