Creating database users in Microsoft SQL Server

These are the two different modes of user authentication for CPM applications that access Microsoft SQL Server databases:

• Database authentication. An ID and password must be specified every time the CPM application is started. The database authenticates the user.
• Operating system (OS) authentication. The users are authenticated by the operating system when they first log in. A separate login is not required.

These are the two primary benefits of operating system authentication:

• Ease of maintenance. The systems administrator needs to maintain only the user names; the individual users maintain their own passwords.
• Ease of use. When an authenticated user logs into their computer, that user does not need to log into CPM as a separate activity.

If you intend to use database authentication for your CPM applications, see Create database-authenticated users. If you intend to use operating system authentication for your CPM applications, see the Create authenticated users section.