Installing Reporting Server for Symantec Client Security 3.1 and Symantec AntiVirus 10.1

Article:TECH102047  |  Created: 2006-01-16  |  Updated: 2009-01-17  |  Article URL http://www.symantec.com/docs/TECH102047
Article Type
Technical Solution


Environment

Issue



This document describes how to install Reporting Server for Symantec Client Security 3.1 and Symantec AntiVirus 10.1.


Solution



About Reporting Server
Reporting Server is an optional program that you can use to create reports about your security products. The program uses a Web server to deliver information about Symantec Client Security or Symantec AntiVirus products in your network.

Reporting Server includes the following features:
  • Customizable home page with your most important reports
  • Pre-defined and customizable graphical reports with multiple filter options
  • Role-based user administration that is separate from the Symantec System Center console user administration
  • Optimized to support events from 100 computers to 50,000 computers
  • Supports Microsoft® SQL for storing events
You can connect to Reporting Server through the Symantec System Center console. You can also connect to Reporting Server through a Web browser that is installed on a computer that has access to your reporting server.


System requirements
This section describes the minimum system requirements that are needed to install Reporting Server.

Required communications ports and protocols
Reporting Server communicates over TCP ports 80 and 443. If you set up a database on a remote machine, you must create an alias and ensure that port number is open. The default for SQL Server is TCP 1433.

Operating system requirements
You can install Reporting Server on the following operating systems:
  • Windows 2000 Server/Advanced Server
  • Windows Server 2003 Standard/Enterprise with Support Pack 1 or higher

You must enable active scripting on your Web browser before using the reporting server from the Symantec System Center or your Web browser.

Disk space requirements
The amount of disk space that Reporting Server requires depends on the number clients that forward data to the server. The following examples show the recommended minimum disk space:
  • 1.5 GB disk space for 100 clients
  • 2 GB disk space for 1,000 clients
  • 40 GB disk space for 50,000 clients

RAM requirements
The amount of RAM that Reporting Server requires depends on the number clients that forward data to the server. The following examples show the recommended minimum amount of RAM:
  • 256 MB for 100 clients
  • 512 MB for 1,000 clients
  • 1 GB for 50,000 clients

Application requirements
The following additional applications are needed to run Reporting Server:
  • MSDE 2000 with Service Pack 4 (installable), or Microsoft SQL Server 2000 with Service Pack 1 or later (existing), or Microsoft SQL Server 2005 or later (existing)
    For a complete list of supported versions, read Supported versions of Microsoft SQL server for use with Reporting Server.
  • Internet Information Services 4.0 or later
  • Internet Explorer 5.5 with Service Pack 2 or later


Before you install
This section describes the decisions that you must make before you install Reporting Server.

Use MSDE or SQL
You can use an MSDE 2000 database or a Microsoft SQL Server with Reporting Server. MSDE database installations can support data for small to medium deployments up to Symantec Client Security 1,000 clients. You must have the Microsoft SQL Server Desktop Engine installed to use an MSDE database. If you do not have the Microsoft SQL Server Desktop Engine installed, you can install it during the Reporting Server installation. If you want to use MSDE for Reporting Server and you already use MSDE for another application, you must create a second instance for Reporting Server. For directions, read Installing Reporting Server on a second instance of MSDE.

Large deployments of over 1,000 clients should use an existing installation of Microsoft SQL Server 2000/2005. Microsoft SQL Server installations can support data for large deployments up to 50,000 Symantec Client Security clients. As a result, calculate about one reporting server installation for every 50,000 clients.


Note: Each reporting server only displays client data for the management servers that are associated with the reporting server.



Where to install Reporting Server
Administration is easiest if you install Reporting Server on a primary management server that also runs the Symantec System Center. This configuration is also preferred for testing. You can, however, install Reporting Server on any computer that is in a Symantec Client Security or Symantec AntiVirus server group.

You are not required to install Reporting Server on the computer that hosts the database. In larger deployments, administration may be easiest if you install Reporting Server on a computer that runs the Symantec System Center and use an existing Microsoft SQL database on a remote computer.

Existing installations of PHP
The Reporting Server installation uses PHP version 5.1.2.2. If you install Reporting Server onto a computer that already has PHP installed, Reporting Server will not work if the versions differ. If the existing version of PHP is not in use, then uninstall it before installing Reporting Server. If the existing version of PHP is in use by another program, then install Reporting Server onto a different computer.


Installing Reporting Server with MSDE
If you want to use MSDE for the reporting database, follow the directions in this section. If you already use MSDE for another application, you must create a second instance for Reporting Server. For directions, read Installing Reporting Server on a second instance of MSDE.

To install Reporting Server and MSDE on the same computer
  1. Insert the installation CD and begin the installation process.
  2. On the splash screen, click Install Symantec Client Security or Install Symantec AntiVirus.
  3. On the splash screen, click Install Reporting Server.
  4. In the Welcome dialog box, click Next.
  5. In the License Agreement dialog box, check I accept the terms in the license agreement, and then click Next.
  6. In the Reporting Server Password dialog box, in the Password boxes, type the password for the Admin account, and then click Next.
    You will use these credentials to log in to the reporting server for the first time.
  7. In the Database Options dialog box, check Install Reporting Server using a database server on this machine, and then click Next.
  8. In the next Database Options dialog box, in the Password boxes, type the password to use for the sa account, and then click Next.
    The installation fails if you do not set a password.
  9. In the Ready to Install dialog box, click Install.
  10. Complete the installation.


Installing Reporting Server with Microsoft SQL
If you want to use a local Microsoft SQL database for the reporting database, follow the directions in this section. If you want to use a remote Microsoft SQL Server database for the reporting database, read the "Installing the reporting server and a remote Microsoft SQL Server database" section in chapter 4 of the Installation Guide. You can find the Symantec Client Security Installation Guide (scsinst.pdf) or the Symantec AntiVirus Installation Guide (savinst.pdf) in the Docs folder of the installation CD.

When you install Reporting Server and use an existing Microsoft SQL Server instance, you create a database on the Microsoft SQL Server instance. Before you install Reporting Server, Symantec recommends that you install a new instance of SQL Server that conforms to Symantec installation and configuration requirements. You can install a database in an older, existing instance, but the instance must be configured properly or your database installation will fail or not function properly. For example, if the authentication configuration is not set to Mixed Mode, your installation will fail. If you select a case-sensitive SQL collation your installation will fail.

When you install the instance of Microsoft SQL Server, select the following non-default features:
  • Do not accept the default instance name. Use Report or some other name.
    A database named Reporting is created in this instance when you install Reporting Server.
  • Set authentication configuration to Mixed Mode (Windows authentication and SQL Server authentication).
  • Set the sa password when you set Mixed Mode authentication. You will type this password when you install Reporting Server.
    The installation fails if you do not set a password.
  • (Microsoft SQL Server 2005 only) When you configure Service Accounts, select to start the SQL Server Browser at the end of setup.


Note: When you install the instance of Microsoft SQL Server, do not select a case-sensitive SQL collation. The reporting database does not support case-sensitivity.



To install Reporting Server and a local Microsoft SQL Server database
  1. Insert the installation CD and begin the installation process.
  2. On the splash screen, click Install Symantec Client Security or Install Symantec AntiVirus.
  3. On the splash screen, click Install Reporting Server.
  4. In the Welcome dialog box, click Next.
  5. In the License Agreement dialog box, check I accept the terms in the license agreement, and then click Next.
  6. In the Reporting Server Password dialog box, in the Password boxes, type the password for the Admin account, and then click Next.
    You will use these credentials to log in to the reporting server for the first time.
  7. In the Database Options dialog box, check Install Reporting Server using a database server on this machine, and then click Next.
  8. In the next Database Options dialog box, in the SQL Server Administrator Username box, type the name that is used for the server administrator account, which is sa by default.
    The installation fails if no password is set for the sa account.
  9. In the SQL Server Administrator Password box, type the password that is used for the server administrator account.
  10. In the Select which instance to use drop-down box, select the SQL server instance in which to create the reporting database, and then click Next.
  11. In the Ready to Install the Program dialog box, click Install.
  12. Complete the installation.


Configuring a server group to use the reporting server
If you installed the reporting server on a computer that runs a primary or secondary management server and the Symantec System Center, the server group is automatically configured to use the reporting server. If you installed the reporting server differently, you will have to configure the server group to use the reporting server.

To configure a server group to use the reporting server
  1. Start the Symantec System Center and unlock the server group that contains the computer that runs the reporting server.
  2. On the Tools menu, click Discovery Service.
  3. In the Discovery Service Properties dialog box, on the General tab, under Cache Information, click Clear Cache Now, and then click Close.
  4. Unlock your server group.
  5. Right-click your server group, and then click All Tasks > Reporting Configuration > Configure Reporting Server.
  6. In the Reporting Server Options dialog box, select the reporting server that you installed, and then click OK.


Logging in to the reporting server
You can log in to the reporting server by using the Symantec System Center, or you can log in from a supported Web browser. If you log in from a Web browser, use the following URL:

http://localhost/reporting

To log in to the reporting server
  1. In the Symantec System Center, expand Reporting, expand Reporting Servers, and then click on the reporting server that you installed.
  2. In the right pane, in the Login screen, in the User Name box, type admin.
  3. In the Password box, type the Admin password that you created during installation, and then click Login.
  4. First-time logins may take up to 30 seconds.




References
The following documents may be useful if you encounter problems during the installation:
The following documents show how to use reports and alerts with Reporting Server:
For more information about how to use Reporting Server, see the Reporting User's Guide (report.pdf) located in the Docs folder of the installation CD.



Technical Information
The default installation log file is :\Documents and Settings\\Local Settings\Temp\ReportingServerInstall.Log. If you have problems with installation, inspect the log file.




Legacy ID



2006111614103948


Article URL http://www.symantec.com/docs/TECH102047


Terms of use for this information are found in Legal Notices