SQL-Server Rights/Roles used with QC/ALM when using SQL-authentication:
There are two SQL-Server users in SQL-Server used by QC/ALM.
• The database administrative user (can be “sa” or a “proxy” or service user you create for the purpose) – often called something like “td_db_admin”. This user is used when in Site Admin and trying to CREATE, DELETE or UPGRADE a project (and it’s DB).
• The “td” user – this user is used day-to-day within project DB’s when QC/QC users work in QC.
Make sure “td_db_admin” has these Server ROLES (do not assign other roles):
(these roles are REQUIRED when CREATING, DELETING, or UPGRADING projects in QC)
OPTIONAL when doing upgrades – you need:
(this role is REQUIRED only when UPGRADING projects in QC)
Make sure “td” does NOT have any Server ROLES (do not assign other roles):
• (public) is OK
If you decide to use Windows Authentication, the WINDOWS-USER associated with the ALM Service on the ALM server must have the same rights in SQL-Server as we indicated for the "td_db_admin" user (above).