Configuring your Database prior to Installation
14
2. Find the local server in the directory tree.
3. Right-click on the local server, and select Properties. A Properties box displays.
4. Select the Security tab.
5. Under the Authentication heading:
•
If you are using SQL 2000, select theSQL Server and Windows option.
•
If you are using SQL 2005, select theMixed Authentication option.
6. Select OK.
Ensuring Settings for Unicode Character Sets are Correct in Oracle
Before you can successfully upgrade or install Web TimeSheet on Oracle, you must set the National Char-
acter Set to AL16UTF16.
If you plan to support multiple language scripts, you should set the Database Character Set to Use Unicode
(AL32UTF8).
Selecting Unicode Character Sets in a new Database
If you are creating a new database, you need to specify the correct Unicode character sets when you create
the database.
Selecting Character Sets Using the Database Configuration Assistant
To specify Unicode Character Sets using the Database Configuration Assistant:
1. Follow the wizard until you reach the Initialization Parameters page.
2. Select the Character Sets tab.
3. In the National Character Set field, select AL16UTF16.
4. If you want to support multiple language scripts, select Use Unicode (AL32UTF8) for the Database
Character Set.
Managing your SQL Server database
You can use SQL Server Management Studio Express to manage your SQL Server database. Down-
load it at: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-
94B8-5A0F62BF7796&displaylang=en http://www.microsoft.com/downloads/details.aspx?Family-
Id=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en.
