Create authenticated users

The first step to establishing user security is to create user sign ins within Microsoft SQL Server and to give the users access to CPM. A DBA must perform this step to have sufficient access to Microsoft SQL Server to create other users and grant them access. If your DBA performs this step, inform the DBA that the users must be defined and given access to the database.

Before you begin, identify which users will be administrators. Administrators must be added to the authorized database and the production database

You can use Microsoft SQL Server Management Studio in the Microsoft SQL Server program group on your server. Only the Microsoft SQL Server Management Studio procedure is documented here.

To allow automatic authentication:

• Set up authenticated user sign ins in Microsoft SQL Server and add the users to the desired database.
• Switch AppServer to OS authentication mode.