After the setup support fi les are installed, you must select which SQL Server 2008 fea-tures to install . If you have a remote server running SQL Server available to host the report server databases, you need only install Reporting Services and the Management Tools . You can install the Business Intelligence Development Studio (BI Dev Studio) and Client Tools Connectivity on the same computer if you plan to use it for report development, or install these features later on a separate computer .
Important If you confi gure Reporting Services to use a remote server running SQL Server, your account needs permission to create and access databases on that server .
In this procedure, you continue the installation of SQL Server 2008 by selecting the SQL Server 2008 features to install .
Install SQL Server 2008 features
1. On the Feature Selection page of the SQL Server 2008 Setup wizard, in the Features list, select the Database Engine Services, Analysis Services, Reporting Services, Business Intelligence Development Studio, Client Tools Connectivity, SQL Server Books Online, and Management Tools – Complete check boxes .
Install SQL Server 2008 features
The Feature Selection page of the wizard looks like this:
o The Database Engine Services feature is required to host the Reporting Services databases . If another instance of SQL Server 2008 is on your computer or is available on a remote server, you can ignore this selection .
o The Analysis Services feature is required to complete the procedures in Chapter 7 If you intend to skip that chapter, you can ignore this selection .
o The Reporting Services feature is the focus of this book, of course; therefore, it is a required selection on this page .
o You use the BI Dev Studio to build reports and report models in the chapters of Part II, “Developing Reports,” so it is also a required selection .
o The Client Tools Connectivity feature includes the components and network libraries that Reporting Services uses for Open Database Connectivity (ODBC) and Object Linking and Embedding Database (OLE DB) connectivity when executing report queries .
o SQL Server Books Online is not required, but it is useful to install on your com-puter as a reference tool . Alternatively, you can refer to SQL Server Books Online at http://msdn.microsoft.com/en-us/library/ms130214(sql.100).aspx .
o The Management Tools – Complete feature includes SQL Server Management Studio with the necessary tools for managing the report server . This feature is required to complete the procedures in Chapter 11, “Securing Report Server Content,” and Chapter 12, “Performing Administrative Tasks .”
The default location for installation of the SQL Server 2008 features is C:\Program Files
\Microsoft SQL Server, but you can choose a different location if you prefer . 2. On the Feature Select page, click Next to continue .
3. On the Instance Configuration page, shown here, keep the default selection of Default Instance .
Alternatively, you can select Named Instance and specify a name for the instance . You can also change the root directory of the instance from the default of C:\Program Files
\Microsoft SQL Server .
Notice the directory for Reporting Services is C:\Program Files\Microsoft SQL Server
\MSRS10 .MSSQLServer . This naming convention makes it much easier to identify where Reporting Services files are found in the SQL Server root directory as compared to previous versions of Reporting Services . You need to know this location if you want to change configuration files later or to review logs, which are covered in Chapter 12 . 4. On the Instance Configuration page, click Next to continue .
5. On the Disk Space Requirements page, confirm that you have enough disk space on your computer to install the selected features, and click Next to continue .
6. On the Server Configuration page, in the Account Name drop-down list, select NT AUTHORITY\NETWORK SERVICE as the service account for SQL Server Agent, SQL Server Database Engine, SQL Server Analysis Services, and SQL Server Reporting Services .
The Server Configuration page looks like this:
7. In the Startup Type drop-down list for SQL Server Agent, select Automatic .
SQL Server Agent must be running to configure schedules for caching, snapshots, and subscriptions .
Note Microsoft recommends that you establish separate service accounts for each service . In this book, your computer is assumed to be a development environment contained within a single computer, so you can safely use NT AUTHORITY\NETWORK SERVICE, which is a low-privilege account and satisfies the minimum security requirements .
If you plan to use a domain account for each service, you can click Use The Same Account For All SQL Server Services . A dialog box displays, in which you can provide the account name and password for all services in a single step . Otherwise, for each service, you need to select Browse in the Account Name drop-down list and locate an account .
8. On the Server Configuration page, click Next to continue .
9. On the Database Engine Configuration page, shown here, click Add Current User to add your user account as a SQL Server administrator:
Note If you prefer to use a different data directory for your SQL Server 2008 databases, you can click the Data Directories tab to specify an alternate location .
10. On the Database Engine Configuration page, click Next to continue .
11. On the Analysis Services Configuration page, click Add Current User, and then click Next . If you did not install Analysis Services, skip to step 12 .
Note If you prefer to use a different data directory for your Analysis Services 2008 databases, you can click the Data Directories tab to specify an alternate location .
12. On the Reporting Services Configuration page, shown here, select Install The Native Mode Default Configuration .
The option to install the native mode default configuration appears only when you install Reporting Services in the same instance that hosts the Database Engine and the account running Setup has permissions to access and create databases on that instance . Otherwise, you must use the Install, But Do Not Configure The Report Server option .
Important If you are installing Reporting Services 2008 on a computer that is already running Reporting Services 2005 and uses the default port 80 for the virtual directories ReportServer and Reports, you must choose the Install, But Do Not Configure The Report Server option to prevent Reporting Services 2008 from blocking access to Reporting Services 2005 .
If you know now that you want to implement SharePoint integrated mode, you can instead select Install The SharePoint Integrated Mode Default Configuration . This option does not require you to have SharePoint installed on your computer, but the report server is not available until you install SharePoint and finish configuring the report server to work in SharePoint integrated mode, as explained later in this chapter .
Note It’s very easy to change the configuration settings if you change your mind, so don’t worry too much about your choices at this point . The main consideration to keep in mind when configuring a report server for native mode or SharePoint integrated mode is to plan to redeploy the content if you later want to switch to the other mode . Therefore, you should decide which mode to support before you start deploying reports to the report server . You might set up two evaluation computers to try out each mode before deciding which configuration to install in your production environment .
13. On the Reporting Services Confi guration page, click Next . 14. On the Error And Usage Reporting page, click Next . 15. On the Installation Rules page, click Next .
16. On the Ready To Install page, click Install .
Installation might take up to an hour, especially if you followed the steps in this procedure to install all the features required to complete the procedures through-out this book .
17. On the Installation Progress page, click Next . 18. On the Complete page, click Close .
19. Close the SQL Server Installation Center window .