Kbase 91443: New SQL Database Access
| Autor |
Tatiane Koslinsky - CAT |
| Acesso |
Público |
| Publicação |
21/09/2017 |
|
Menu: Environment > SQL Database Access > New SQL Database Access
Click 'New' to register the database, then select the company, enter the logical name below and click 'Save'.
Back to the 'SQL Access Database' screen, enter:
a. Server host;
b. SQL connection port (-ServerType SQL);
c. User and password.
Note:
The user entered must have DBA permission in the database. For this reason, we recommend you use the 'sysprogress' user.
To each parameter entered, click 'Save' or press ENTER. Execute this procedure for all databases with SQL access from the progress-ds.xml file.