Creating a database in Microsoft SQL Server for use with Journyx Timesheet - Journyx, Inc.

Support
Creating a database in Microsoft SQL Server for use with Journyx Timesheet

 
  1. Install Microsoft SQL Server

    • Install SQLSrvr 6.5 (include TCP network support).
    • Make sure service is running with system account.
    • Don't run the exec service.

  2. Register Database Server Via Enterprise Manager

    • Select 'Start- Programs- Microsoft SQL Server 6.5- SQL Enterprise Manager' to bring up the enterprise manager control program.
    • Register your server with user 'sa' and the installed password for 'sa'.
    • Default is no password.

  3. Create Database Device

    • Expand server icon to display sub-tree for this DB server.
    • Select 'Database Devices'.
    • Right-click and select 'create new'.
    • Name the device file (eg: jtimdev).
    • Fill in the initial device size
      Initial size should be set at 100 MB
    • Unless you are a SQL administrator, leave all other options on this screen at default.
    • Select 'create now' to create.

  4. Create Database

    • Select 'Databases'.
    • Right-click and select 'new database'.
    • Fill in the database name (eg: jtimedb).
    • Select the database device you created earlier.
    • Select a log device and size if you want logging.
    • Select 'create now' to create.

  5. Create Database User
    Please Note: Journyx strongly recommends that you do not use the default 'sa' account that is built in to SQL.

    • Select 'Logins'.
    • Right-click and select 'new login'.
    • Fill in the desired login name (eg: jtimeuser) and password.
    • Left-click on the 'permit' column for the database created earlier to enable this user to manage your jtime database.
    • Select 'add' to create the user. You will be asked to confirm the password.
    • Once the user is created, select 'close' to exit the user creation panel.
    • Select 'Databases' and exand it.
    • Select the newly created database name and right click.
    • Select 'Edit'.
    • Left-click on 'Permissions' tab.
    • Mark the checkbox for each permission for your new jtime user.
    • Click 'OK'.
    • At this point the database is setup and ready to be used by Journyx Timesheet. You can exit the enterprise manager program.

  6. 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 pane 1 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.

  7. Finally, select 'OK' to complete configuration of this DSN.

  8. Complete Journyx Timesheet Configuration