Overview and Installation – SQL Server Reporting Services 2012 - Learning SQL Server Reporting Services 2012 - page 29

Installation choices and notes
Since this installation is just for working with basic reporting services and savoring
the features of SharePoint Integration by a single user on a single machine, the same
service account was used for all of the services. During installation, the username and
password chosen are of the author on this particular custom environment, as it makes
meaningful screen capture easier. It is not a recommended practice to make public the
security arrangement, except for a demo environment such as the one used here.
If you want to customize, you may want to choose the locations for the data and log
iles but for this topic, however, the default locations are adequate. However, for a
production environment, this is not recommended; you may have to choose proper
locations for data and log files, preferably not on drives with operating system files.
Windows authentication was chosen for both the database engine as well as all the
services to keep it simple. Also, to make it simple, the current user of the machine
was made the sysadmin . If necessary, one may add, other SQL Server administrators
using the related Database Engine page or the Analysis Services page. While
configuring the database engine, the defaults were used for data directories, but
these can be customized as well.
Regarding the choices for the Reporting Services configuration mode, there are three
possible choices from two different modes—Native mode or SharePoint Integrated
mode. For Reporting Services with SQL Server 2012, the choice of Native mode was
made and most of the Report Builder reports deploy them to the Report Server.
The installation should proceed as described, without any problem. The order in
which the various software items were installed closely follows the installation
steps in the hands-on exercise, but is simply listed here:
• SQL Server 2012 (x64) Enterprise Evaluation
• Configuration of Reporting Services 2012 in Native mode
• Installation of SharePoint 2010 Server Enterprise Evaluation
• Installation of Reporting Services in SharePoint Integrated mode
Configuring SQL Server Reporting Services
In this section, we will consider configuring the Reporting Services in Native mode
as against configuring in SharePoint Integrated mode. It may be useful to remember
that Reporting Services SharePoint Integration provides two ways to work with
reports (for details, refer to the link at http://msdn.microsoft.com/en-us/
library/cc281311.aspx and Hands-on exercise 10.3).