Support
Microsoft SQL Server 7.0 with Timesheet

Please Note: This page contains information for use with Timesheet 4.x only. Timesheet 5.x users should refer to the Timesheet 5.0 and External Databases page.

1. Install MSSQL Server
   • Install SQLSrvr 7.0 (include TCP network support).
   • Make sure service is running with system account.
2. Create Database
   • Expand server icon to display sub-tree for this DB server.
   • Select 'Databases'.
   • Right-click and select 'new database'.
   • Fill in the database name (eg: jtimedb).
   • Fill in the initial size
     Initial size can be estimated by multiplying 1.2MB by the number of timekeepers you will have over the course of the year and adding 6MB to that number. This does not take into account the size of expense records, so if your paradigm is to have 1:1 time to expense records, for example, you will want to double the size.
   • Unless you are a SQL administrator, leave all other options on this screen at default.
   • Click OK to create the database
3. Create Database User
   Please Note: Journyx strongly recommends that you do not use the default 'sa' account that is built in to SQL.
   • Expand server icon to display sub-tree for this DB server.
   • Expand the SECURITY folder
   • Select 'Logins'
   • Right-click and select 'NEW LOGIN'.
   • Fill in the desired login name (eg:jtimeuser).
   • Under Authentication, be sure that GRANT ACCESS is selected
   • Change the method to SQL Server Authentication and fill in the desired password.
   • Change the Default Database to be jtimedb or whatever you named your SQL database
   • Click the Database Access tab
   • Select the jtimedb (or whatever you named it) by checking the box to the left of the name
   • Grant the user db_owner right to this database
   • Click OK to add this user.Ê You will be prompted to confirm the password.
   • At this point the database is setup and ready to be used by Journyx Timesheet. You can exit the enterprise manager program.
4. Create ODBC Data Source
   • Select 'Start- Settings- Control Panel' to bring up the control panel.
   • Double-click on 'ODBC' to bring up the ODBC Data Source Administrator.
   • Select the 'System DSN' tab to bring the list of System Data Sources in view.
   • Select 'Add' to create a new data source. This will bring up a list of ODBC client drivers. Select the 'Microsoft SQL Server Driver' and click on 'Finish' to create the DSN. This will bring up a panel to setup the DSN.
   • Fill in the Data Source Name (eg: jtimedsn). This is the name you will give to the Journyx Timesheet configuration page to allow connection to this data source.
   • Fill in the 'Server' with the name of the SQL Server host. If Journyx Timesheet is installed on the same host as MS SQL Server, then you can choose '(localhost)'.
   • Depending on which SQL Server ODBC Driver you have installed, you need to complete setup in one of these two ways:
     • Method One (there's an 'Options' button):Select 'Options' and fill in the database Name with the name you created earlier (eg: jtimedb).
     • Method Two (there is no 'Options' button, but rather a 'Next' button):
       • Select 'Next'.
       • Select 'SQL Server authentication'.
       • Make sure 'Connect to SQL Server' is checked.
       • Fill in db administrator user name and password.
       • Make sure that 'Change the default database to' is checked and then select the new database.
       • Left-click 'Next' twice.
       • Left-click 'Finish' to complete setup.
       • Now click 'Test Data Source' to verify the setup.
       • If the test was successful, left-click 'OK'; otherwise, verify your settings and try again.
5. Finally, select 'OK' to complete configuration of this DSN.
6. Complete Journyx Timesheet Configuration
   The DSN name, database user and password are then used to configure Journyx Timesheet to use this new data source. Using the example above, the values are:
   • DSN Name: jtimedsn
   • Database user: jtimeuser

Continue Journyx Timesheet installation instructions