Activating Windows Authentication - Security - Foundation 23.2 - Foundation 23.2 - Ready - Hyland RPA - external

Hyland RPA Security
Platform
Hyland RPA
Product
Security
Release
Foundation 23.2
License

Windows Authentication is enabled by default in SQL Server.

However, individual authentication is required for all users. Alternatively, authentication can be performed through Active Directory (AD) groups and managed through SQL Server Management Studio.

  1. In SQL Server Management Studio, in the left pane, expand [Server Name] | Security .
  2. Right-click Logins and then click New Login.
    The Login - New dialog box is displayed.
  3. Click Search.
    The Select User or Group dialog box is displayed.
  4. Click Object Types.
    The Object Types dialog box is displayed.
  5. Select the object types you want to see and then click OK.
    Note: Groups are disabled by default.
  6. Click Locations.
    The Locations dialog box is displayed.
  7. Expand the location where you want to search for objects, for example Entire Directory, find your AD group and then click OK.
    You now have a regular SQL Server Login, similar to those created for a single AD.
  8. Assign users and their privileges to the newly created login. See Role-Based Access to the SQL Server Database for more information.
    Any member of the selected AD group can now login to SQL Server and use the database.