Connectivity

Note: You can only use this function if you have Administrator rights.
  1. To set up the required connectivity definitions, select Security Settings (SES) and click the Connectivity tab.
  2. If no data source has been configured, the fields on the SunSystems Domain Database page are blank.
  3. To configure Microsoft SQL Server as the data source, complete the following fields:
    Type
    Select the platform type Microsoft SQL Server.
    Server
    Enter the name of the server.
    Database
    Enter the name of the data source.

    Application roles allow users to access data on the SQL Server only when they log on and access it using the relevant application, but without allowing the users to directly access the raw data in the SQL database tables using other applications or tools such as SQL Server Management Studio.

    An application role is created and this must be made available to any client application that needs access to data (such as a reporting tool). However, it can only be used by such a client if the user has already been authenticated by the security service, that is, using a user ID created in Security Console.

    The application role itself is secured by means of a password. Users do not need to know this password, but a system administrator installing a new application must know the password if the application is to be allowed access to data.

    Application Role Name
    Enter a name for the application role. Application Role Names are case sensitive and it is recommended not to use reserved SQL Server terms, for example Create.
    Password
    Enter a password for the application role. Your Application Role Password cannot begin with a number, and cannot include special characters such as ! ( ) , * : ; ? @ [ ] { } and so on.
    Last Updated
    This is automatically populated with the date when the application role was last updated.
  4. Save your changes.