The setup of an SQL database as a profile database should be handled by the administrator.
It must be possible for all affected scan stations to connect to a shared MS-SQL server.
By default, Scan Client profiles are stored in a local access database that only allows one simultaneous access at most.
In addition to the profile distribution through the PROXESS Management Console, the PROXESS Scan Client offers the option of saving the profile management in a central SQL database. This enables simultaneous access to one Scan Client profile by multiple users. Possible users are Windows PCs or terminals (terminal server capability).
Warning information
|
|
The setup of an SQL database as a profile database should be handled by the administrator.
It must be possible for all affected scan stations to connect to a shared MS-SQL server.
|
1. Start the login dialog and click the 
or 
button.
2. Enter the administrator password for the PROXESS Scan Client.
3. The following dialog opens:
Fig.: Configuration dialog for establishing a database connection to the Scan Client profile management
| Data source |
Select between Access database and MS SQL database. Access database: This is the default setting. When the PROXESS Scan Client program is installed, an access database is automatically installed on the local PC and provided as the database to store the Scan Client profile data. Therefore, no other entries in the dialog box are required.
MS-SQL database: The dialog fields have to be completed to establish a connection to the SQL database where the Scan Client profile data are stored every time the program is started.
|
| Server name |
A list of all SQL servers published in the network is displayed. You can also enter the SQL server name. |
| Initial Catalog |
Select the name for the SQL database with which the Scan Link profiles are managed (e.g. ScanLink). The first time you do this, you can establish a new database with this dialog. Later you can connect to the existing database at any time. |
| User name |
User name for login to the MS/SQL server (provided with administrative rights) |
| Password |
Password for login to the MS/SQL server |
| Database names |
Select an arbitrary database name for the database in the MS/SQL server (e.g. ScanLink). The profile data of the PROXESS Scan Link will be stored in this database. |
| Create DB |
This lets you create the database in the MS-SQL server. The required tables and fields are created automatically. |
| Test |
Here you can test whether a connection to the database can be established with the entered login information. |
| OK |
Confirm your connection data with OK. |
| Cancel |
Cancel lets you exit the dialog without saving your entries or changes. |
4. Confirm your input with OK.
You will get the following message:
For the changes to the database connection to become active, PROXESS Scan Client will automatically close and has to be restarted.
5. Restart PROXESS Scan Client. Now existing Scan Client profiles are loaded onto your work station.
_________________________________________________________________________________________
Also see:
Locally distribute scan profiles
Distribute scan profiles via XML
Distribute scan profiles via PROXESS Management Console