Test Connection

Configure the permissions to test the connection to the SAP Sybase database. Access to all databases must be granted to this user.

1. Set the enable granular permissions configuration parameter to 1 as follows in the application debug page:

   Copy

   sp_configure enable_granular_permissions, 1

2. Log in using administrator credentials and create a new user on the managed system using the following command, where loginame is the login user on SAP ASE, password is the user-provided password, and username is the corresponding Database User:

   Copy

   use [databaseName]
   go
   sp_addlogin [loginname],[password]
   go
   sp_adduser [username]
   go

   Grant access to all databases to the newly created user.