- Host the Report Server catalog in a SQL Server instance on a separate box from your data sources (transactional, data warehouse, or line-of-business database) or at least make sure that a SQL Server instance can handle additional workload.. - To protect the catalog database, companies can deploy a SQL Server 2008 cluster. - If Windows authentication is being used between the Report Server and the SQL Server 2008, both Report Server and the SQL Server 2008 cluster have to be in either the same or in the trusted domains. - Both nodes of the SQL Server 2008 cluster must have an exact match and all hardware and software installed on a cluster must be supported.. - Report Server. - SQL Server Failover Cluster Report. - FIGURE 5.1 Deployment scenarios.. - hardware-based data replication or peer-to-peer replication in SQL Server 2008.. - The database mirroring functionality of SQL Server 2008 is another high-availability option.. - ReportServer Database SQL Server Failover Cluster. - SQL Server Management Studio (includes basic management tools). - Having both the database and the Report Server on the same machine might sound tempting on the financial front because SSRS is included with the SQL Server relational engine. - Each machine in the web farm runs SQL Server Reporting Services Windows service, which contains the Report Server web services, and the scheduling and delivery processor.. - For security reasons, SQL Server setup does not provide options to deploy SSRS with anonymous access to reports.. - Because the Report Server has web compo- nents, this option means that the SQL Server 2008 instance that hosts catalog data will also be running on the web server and there are no queries that cross boundaries of the web server.. - To provide public data (or snapshots with public data) to the SSRS catalog in this configu- ration, an administrator can use replication or SQL Server Integration Services to “copy”. - This book discusses some aspects of security extensions in Chapter 29, “Extending Reporting Services.” An example of a security extension is provided with SQL Server 2008.. - In this case, an application can collect, for example, a user’s SQL Server credentials and pass those credentials to a data source, thereby restrict- ing the user’s access to data.. - FIGURE 5.3 Internet deployment scenario.. - minimize their permissions on the Report Server. - Table 5.3 outlines hardware requirements for SQL Server 2008 installations.. - 1024x768 recommended for SQL Server graphical tools.. - 1024x768 recom- mended for SQL Server graphical tools.. - SQL Server 2008 and all of its components, including SSRS, are supported in virtual environments created using Hyper-V, provided of course sufficient CPU and RAM resources are allocated to the virtual machine and that the virtual machine runs an operating system supported by SSRS.. - The following operating systems are supported by SQL Server Enterprise/Developer Edition IA64:. - At least some components of SSRS are available in almost all editions of SQL Server 2008:. - Availability: Web farm support of Reporting Services Enterprise Edition paired with the Reporting Services catalog installed on a SQL Server 2008 cluster enables high- availability reporting solutions.. - Express Workgroup Standard Enterprise Data sources Local SQL Server. - SQL Server and Analysis Services. - Management Report Manager Supports SQL Server Management Studio and Report Manager. - This means that a company does not have to buy a separate license if SSRS is installed with SQL Server 2005 together on a single computer. - For scale-out (web farm) deploy- ments, each web server that runs Report Server must have a SQL Server license.. - You need access to an account with administra- tive privileges to run SQL Server 2008 Setup.. - Set up several Windows accounts to run SQL Server services, such as Report Server and SQL Server.. - Secure a computer on which you are planning to install SQL Server components. - On computers on which autoplay functionality is enabled, SQL Server 2008 Setup starts automatically when the install disc is inserted into (depending on the install media) the CD or DVD drive.. - FIGURE 6.1 SQL Server Installation Center.. - Splash.hta provides options to install additional components, such as SQL Server Upgrade Advisor and more. - To launch the SQL Server 2008 install, select Server Components, Tools, Books Online, and click the Samples link on the splash screen, or run <setup. - Select Installation from the leftmost menu of the SQL Server Installation Center (see Figure 6.1).. - Click New SQL Server Stand-Alone Installation or Add Features to an Existing Installation as shown in Figure 6.2. - The other options are largely for the installation of SQL Server’s relational engine or Analysis Services on a Microsoft Cluster Server (MCS) cluster.. - The configuration check also reports whether any problems may require attention prior to installing SQL Server. - FIGURE 6.2 Installation menu of the SQL Server Installation Center.. - FIGURE 6.4 Setup support files.. - The next step is the installation of the SQL Server support files (the files needed by SQL Server Setup). - They help SQL Server Setup install and update instances after the initial setup is complete. - Now you pick an edition of SQL Server or enter a product key. - In this step, Setup enables you to select SQL Server–related services to install without the need to specify details. - FIGURE 6.5 Setup support rules.. - FIGURE 6.6 Enter a product key.. - FIGURE 6.9 Instance configuration.. - This will add your user account as a SQL Server administrator for the database engine. - FIGURE 6.11 SQL Server configuration.. - FIGURE 6.12 Reporting Services configuration.. - TABLE 6.1 SQL Server 2008 Installable Groups of Components Component Group Explanation. - SQL Server Database Services. - Unless some unexpected error happens, you should have a working instance of SSRS deployed on your machine, along with SQL Server. - Report Server and ReportServerTemDB databases on the instance of the SQL Server database services installed during the same setup as SSRS. - To install Reporting Services, run SQL Server 2008 Setup, check Reporting Services on the Components to Install dialog box for TABLE 6.1 Continued. - Shared Components Includes SQL Server Management Studio, Configuration Manager, Profiler, Replication Monitor, and Books Online. - Using the Report Server. - If you are just starting with report development, we recom- mend practicing on a 32-bit platform, using SQL Server as a data source for your reports.. - We have used SQL Server 2005 product sample databases: AdventureWorksDB.msi and AdventureWorksBI.msi. - By default, both databases will be installed at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. - ptg When the wizard completes, attach databases using the SQL Server Management Studio. - FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Adventure Works_Data.mdf’. - FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Adventure Works_Log.LDF’. - Using the Report Server Project Wizard to Create a Simple Report. - Click the Windows Start button, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Business Intelligence Development Studio.. - If you do not see SQL Server Business Intelligence Development Studio as a selection, then, most likely, it was not installed. - In this case, run the SQL Server setup again and select Shared Features, Business Intelligence Development Studio.. - FIGURE 7.1 Creating a new Report Server project using the Report Server Project Wizard.. - you can retrieve data either from a web service or a flat file), an ODBC- or an OLE DB- compliant data source, SQL Server Integration Services (SSIS) package (you must select Shared Features, Integration Services during the install to see this selection), SAP NetWeaver BI, Hyperion Essbase, and Teradata.. - At this point, if you want to connect to other types of data sources, such as Oracle or Microsoft SQL Server Analysis Services, you can choose them here. - For the purpose of this exercise, leave this as Microsoft SQL Server for now.. - Localhost refers to the local computer, and you must have a default instance of SQL Server installed on your local machine to use localhost. - Alternatively, you can enter a name/instance combi- nation of a server, where an instance of SQL Server hosts an AdventureWorks sample database. - You can also browse for visible SQL Server instances by leveraging drop- down functionality.. - Because you are using SQL Server with Windows authentication, the default settings should suffice.. - If you were using SQL Server authentication, or another data source type that required a specialized user ID and password, you could enter it here or have Reporting Services prompt you for it. - FIGURE 7.2 Connection Properties dialog box.. - FIGURE 7.4 Design the Table dialog box.. - FIGURE 7.6 BIDS after completion of the Report Server Project Wizard.. - In this chapter, we discuss both Report Designer and Report Builder and the relation- ship between Report Designer, Visual Studio, and SQL Server Business Development Studio. - The first one is Microsoft SQL Server Report Designer, or simply Report Designer, integrated with Visual Studio. - Starting from SQL Server 2005, if you do not have Visual Studio installed, SQL Server setup installs the Visual Studio shell and labels it SQL Server Business Intelligence Development Studio under the Microsoft SQL Server program group.. - Visual Studio/SQL Server Business Intelligence Development Studio (BIDS) and Report Designer target the developer community.. - Is a part of the Microsoft SQL Server 2008 feature pack. - Just search for “SQL Server 2008 Report Builder 2.0.”. - FIGURE 8.1 New Project dialog box.. - FIGURE 8.2 Report Server Project template (an empty shell of a project).. - Leave Type as Microsoft SQL Server.. - FIGURE 8.3 Adding a new item.. - FIGURE 8.5 An empty report.. - FIGURE 8.6 New Data Source option.. - FIGURE 8.7 Data Source Properties dialog box.. - ptg FIGURE 8.8 Dataset Properties dialog box.. - FIGURE 8.9 Generic Query Designer.. - have on the report
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt