SQL Server Roles and Permissions required for day-to-day working with TopTeam

Overview

In this document, you will learn which SQL Server Roles and Permissions are required in the TopTeam SQL Server database for day-to-day working with TopTeam.

Who should read this?

  • TopTeam Administrators
  • Database Administrators

Prerequisites

You must have Administrative permissions to grant SQL Server Roles and Permissions to SQL Server Logins.

Step 1. Configure SQL Server Login

Step 1.1. Create SQL Server Login

wpid28424-media_1478600575451.png

wpid28419-media_1478600087715.png

NOTE: You can also use an existing Login.

Step 2. Configuring Database Roles for Login

wpid28420-media_1478600125559.png

Step 3. Configuring Permissions for TopTeam Database Schema

wpid28421-media_1478600152311.png

wpid28422-media_1478600195728.png

Use this SQL Server Login in TopTeam Application Server or TopTeam Web Server to connect to the TopTeam SQL Server database.

wpid28423-media_1478600259958.png

Revised: November 24th, 2016