E-Notebook SQL 12.0 Desktop Database Installation Guide.pdf

(678 KB) Pobierz
E-Notebook SQL 12.0 Desktop Database Installation Guide
E-Notebook SQL 12.0 Desktop Database
Installation Guide
1127462002.011.png 1127462002.012.png
E-Notebook SQL 12.0 Desktop Database Installation Guide
Page 2 of 19
1127462002.013.png 1127462002.014.png
 
E-Notebook SQL 12.0 Desktop Database Installation Guide
1. Introduction
This document describes the steps required to create and configure the CambridgeSoft E-
Notebook SQL 12.0 Desktop database on a desktop or workstation computer. There are
two main components to the installation:
¾ Create and configure the E-Notebook database and client on a computer with SQL
Server Express Edition with Advanced Services
¾ Configure the E-Notebook client on remote systems to connect to the database
2. Database System
2.1.
Software requirements
Operating system version: Windows XP Pro SP2/SP3 or Windows Vista Business
SP1/SP2
Operating system architecture: 32 bit
Microsoft Office: Office XP SP3, Office 2003 SP3, Office 2007 SP1
CambridgeSoft Applications: SKU with ChemDraw ActiveX control and E-
Notebook client
SQL Server version: SQL Server 2005 Express Edition with Advanced Services SP3
(as installed by the CambridgeSoft version 12 Installation Wizard)
.Net Framework: .Net Framework 2.0 SP2
Page 3 of 19
1127462002.001.png 1127462002.002.png
 
E-Notebook SQL 12.0 Desktop Database Installation Guide
2.2.
Database Creation and Configuration
2.2.1. Create and share E-Notebook data folders (optional)
By default the Database Setup Wizard will place all the database and configuration files
in (subfolders of): [AppData]\CambridgeSoft\E-Notebook\12.0\
On Windows XP this will be:
C:\Documents and Settings\All Users\Application Data\CambridgeSoft\E-Notebook\12.0\
On Windows Vista this will be:
C:\ProgramData\CambridgeSoft\E-Notebook\12.0\
Note that the [ AppData ] folder is by default hidden on the Windows OS. Users might
prefer to have the E-Notebook database and configuration files in a special ‘data’ location
if you plan on sharing your database since some of the folders need to be shared over the
network in that case. The example below will use a ‘data’ hard drive.
You can create the data and configuration folders in advance before running the Database
Setup Wizard but if you have not so, the Wizard will automatically create any specified
folders that do not exist.
Create three folders:
¾ Database – will contain the actual SQL database and is not shared.
¾ Structure Index Files – will contain the index files that are used for
structure searching. This folder needs to be shared over the network with
read/write permissions if you are going to allow other E-Notebook users to
connect to your database.
¾ Configuration File – will contain the information to allow the E-
Notebook client to connect to the database. This folder needs be shared
over the network with read permissions if you are going to allow other E-
Notebook users to connect to your database.
Page 4 of 19
1127462002.003.png 1127462002.004.png
 
E-Notebook SQL 12.0 Desktop Database Installation Guide
Right click the ‘Structure Index Files’ folder and from the context menu select
‘Sharing and Security’ on Windows XP. On Windows Vista (with the share
wizard turned off) select ‘Share…’ and click ‘Advanced Sharing’. Check ‘Share
this folder’ and type a network ‘Share name’.
Windows XP
Windows Vista
Click the ‘Permissions’ button.
Click ‘Add…’ and select all the users and/or user groups that will be using E-
Notebook. <OK>
Select the users or user group and in the ‘Permissions’ section check ‘change’ and
‘read’. <OK>
Page 5 of 19
1127462002.005.png 1127462002.006.png 1127462002.007.png 1127462002.008.png 1127462002.009.png 1127462002.010.png
 
Zgłoś jeśli naruszono regulamin