Chapter 3 Installing the Repository

Authenticating databases

You must create a database to store the repository tables in the server.

When you install the authenticated version of SQL Anywhere, existing databases and new databases cannot be used with the authenticated server because these databases are not authenticated.

You have to perform the following actions to be able to use a database with the authenticated server.

Authenticate any new database

If you want to automatically authenticate any new database, you have to copy the contents of the script authdb.sql delivered with the repository under \Tools, into the file saopts.sql under \Script in the SQL Anywhere directory, on the server machine.

The authentication string included in this file will let you use any new database with the repository as soon as you create it.

Authenticate existing database

When you install the authenticated version of SQL Anywhere, you cannot use existing databases with the repository since they are not authenticated. However, you can authenticate these databases by executing the script authdb.sql delivered with the repository under \Tools. This will let you use the repository with any existing database.

To execute the authdb.sql script on an existing database:

1. Start Interactive SQL (dbisql.exe).
2. Type dba in the User ID box.
3. Type sql in the Password box.
4. Enter the data source name in the ODBC Data Source Name box.
5. Select the Database tab and click the Browse button.
6. Double-click the existing database in the file selection window, the file path should appear in the Database File box.
7. Click OK.
   
   The Interactive SQL window is displayed.
8. Open the script authdb.sql and execute it.
9. Close Interactive SQL.
   
   This should stop the server. Your database is now authenticated and you can start it to use it with the repository.

Copyright (C) 2007. Sybase Inc. All rights reserved.