When you install reporting servers from the Symantec AntiVirus installation splash screen, several defaults are set automatically. For example, the reporting server is installed in the default directory x:\Program Files\Symantec\Reporting Server\. The reporting server also creates a default database that is named Reporting. If you want to install a reporting server and change the defaults, an existing MSDE or Microsoft SQL Server 2000/2005 installation must exist on the local or a remote computer.
Table 4-3describes the settings that you can change. Table 4-3 Reporting server installation settings
Description Default
Setting
Default installation folder. x:\Program
Files\Symantec\Reporting Server
Table 4-3 Reporting server installation settings(continued)
Description Default
Setting
Non-English Symantec AntiVirus client operating systems that report to Symantec AntiVirus management servers that run English operating systems. This option only applies to the network environments that have the Symantec AntiVirus clients that run operating systems based on certain European, Cyrillic, and Asian languages (i.e. Polish, Russian, and Chinese). These clients must also report to Symantec AntiVirus
management servers. The client operating system distribution must be homogeneous. If the correct language is not selected, the reports may contain translation errors. The installation dialog box contains the complete list of languages. Operating System Default
Language option
Name of the SQL server and instance.
To specify a default local instance, type the host name only. To specify a named local MSDE or Microsoft SQL Server instance, type
<host_name>\<instance_name>. To specify a default remote Microsoft SQL Server instance, type <alias> or
<alias_IP_address>. To specify a named remote Microsoft SQL Server instance, type <alias>\<instance_name> or <alias_IP_address>\ <instance_name>. Default (no instance name)
Database Server
Name of the database to create. Reporting
Database Name
99 Installing reporting
Table 4-3 Reporting server installation settings(continued)
Description Default
Setting
Name of the user account to create.
The user account has a standard role with read and write access. Reporting
Database User Name
Data source name (DSN) of the database.
The DSN is used for ODBC communications. Reporting
Database DSN name
Note:When you specify local host, type the host name only. Do not use the local host conventions of dot, (local), 127.0.0.1, and so forth.
To install reporting servers with non-default settings
1
Insert the installation CD, and then display the \Reporting\Reporting directory on the CD.2
Double-click setup.exe3
Follow the installation prompts to complete the installation.Uninstalling reporting servers
When you uninstall reporting servers, all Symantec components are uninstalled. However, you have the option to not uninstall MSDE and Microsoft SQL Server database and backup files. For all installations, the database backup files are located on the computer that runs the reporting server. The default directory is x:\Program Files\Common Files\Symantec Shared\Reporting
Agents\Win32\Backup\. You can, however, disable backing up to this directory, which you may want to consider if you are running Microsoft SQL Server 2000/2005. For MSDE installations, the database files are located in x:\Program Files\Microsoft SQL Server\MSSQL\Data\. The file names are Reporting.mdf and Reporting_log.mdf.
The procedures that you perform to uninstall the reporting server vary depending on your goal.
Table 4-4 Uninstallation goals and procedures
Procedures Goals
Do the following:
■ Use the Windows uninstaller to uninstall the reporting server and do not select to remove the database.
■ Reinstall the reporting server. Uninstall and reinstall reporting
server and use the existing MSDE or SQL server database
Do the following:
■ Use the Windows uninstaller to uninstall the reporting server and select to remove the database. ■ Reinstall the reporting server.
Uninstall and reinstall the reporting server and create a new MSDE or SQL server database
Do the following:
■ Use the Windows uninstaller to uninstall the reporting server and select to remove the database. ■ Manually delete the reporting server database
backup files. Uninstall the reporting server and
keep MSDE
Do the following:
■ Use the Windows uninstaller to uninstall the reporting server and select to remove the database. ■ Use the Windows uninstaller to uninstall Microsoft
SQL Server Desktop Engine.
■ Manually delete the reporting server database backup files.
Uninstall the reporting server and MSDE
Do the following:
■ Use the Windows uninstaller to uninstall the reporting server and select to remove the database. ■ Use the administrative user interface to delete the
reporting server database and log files. ■ Manually delete the reporting server database
backup files if you are backing them up with the reporting server database backup agent. Note:You can also backup the database with the Microsoft SQL Server management software. In this case, you would delete the backups with the management software.
Uninstall the reporting server when using Microsoft SQL Server
When you uninstall a reporting server, your management groups and servers are still associated with the uninstalled reporting server. If you install a new reporting
101 Installing reporting
server, be sure to associate the management groups and servers with the new reporting server by using the Symantec System Center.
To uninstall a reporting server and keep the database
1
On the Windows taskbar, click Start > Settings > Control Panel.2
In the Control Panel window, double-click Add/Remove Programs.3
In the Add/Remove Programs dialog box, click Reporting Server.4
Click Change.5
In the wizard, click Next.6
In the Program Maintenance dialog box, check Remove, and then click Next.7
In the Remove the Reporting Server dialog box, do one of the following:■ To keep the database, uncheck Remove database during uninstall, and then click Next.
■ To remove the database, check Remove database during uninstall, complete the SQL Administrator boxes, and then click Next.
8
Complete the uninstallation. To uninstall MSDE1
On the Windows taskbar, click Start > Settings > Control Panel.2
In the Control Panel window, double-click Add/Remove Programs.3
In the Add/Remove Programs dialog box, click Microsoft SQL Server DesktopEngine.
4
Click Remove.5
Complete the uninstallation.To manually delete reporting server MSDE database files after uninstalling MSDE
1
Browse to the following directory:x:\Program Files\Microsoft SQL Server\MSSQL\Data\.
2
Delete Reporting.mdf and Reporting_log.ldf. To manually delete reporting server database backup files1
Browse to the following default directory or the directory that contains your files if you changed the default:x:\Program Files\Common Files\Symantec Shared\Reporting Agents\Win32\Backup\
To manually remove (drop) a reporting server MSDE database
1
Display a command prompt.2
Typeosql U -sa -S (local), and then press Enter to log in to the MSDE server.3
In the password prompt, type the sa password, and then press Enter. The cursor does not move when you type the password.4
In the OSQL command shell, typedrop database reporting, and then pressEnter.
5
Typego, and then press Enter.6
Typeexit, and then press Enter to exit the OSQL command shell.103 Installing reporting