Configuring your Database prior to Installation
13
CHAPTER 3
Configuring your Database prior to Installation
Before installing or upgrading using the Oracle or SQL Server database platforms, you may need to com-
plete some configuration.
Configuring SQL Server Authentication
If you are using a SQL Server database, and:
•
You are installing orupgrading Web TimeSheet using an existing SQL Server instance, and
•
You connect to this instance using a login name and password specific to SQL Server (rather than
using Windows authentication).
then configure SQL Server as follows:
1. Open the SQL Server Enterprise Manager from the Start menu.
Do I need to pre-configure my database?
Pre-configuration may not be required if you are upgrading an existing Web TimeSheet database in
place (that is, if you are not moving the data to a new database during upgrade). Refer to the table
below for more information.
If you plan to move your data to a new database, you will need to override the Web TimeSheet install-
er. Contact Replicon Support for information on how to do this.
Database
Type
Type of Configu-
ration
This configuration is REQUIRED...
Refer
to...
SQL Server
Configuring SQL
Server authentica-
tion
•
If you are using a new database for Web
TimeSheet (either when installing or when mov-
ing data to a new database during an upgrade),
AND
•
If you connect using a SQL Server-specific login
name and password (instead of Windows
authentication)
page 13
Oracle
Ensuring Settings
for Unicode Char-
acter Sets are Cor-
rect
• In all cases. The settings specified must be used
for Web TimeSheet installation to be successful.
page 14
Configuring an Or-
acle schema
•
If you are using a new database for Web
TimeSheet (either when installing or when mov-
ing data to a new database during an upgrade)
page 15
Ensuring Oracle
Data Provider
(ODP) connectivity
•
If you are using a new database for Web
TimeSheet (either when installing or when mov-
ing data to a new database during an upgrade),
AND
•
If you are using Windows
page 16
Installing the
ODP.NET driver
•
If you do not yet have ODP.NET 2.0 installed
page 17
