Converting an existing CPM system to use OS authentication

  1. Leave the AppServer parameter RelationalOSAuthMode set to the default of 0 (OFF). The applications to continue to run as they have, for example, requiring a user name and password.
  2. Add the OS authenticated sign-ins and user names to Microsoft SQL Server.
  3. Start Architect and assign a role and a security profile to each user.
  4. After ALL users have been created in Microsoft SQL Server and have a role and a security profile, set the RelationalOSAuthMode and Impersonation Level parameters to 1 (ON). All users can now run the applications without having to specify a user name and password.