If Windows Authentication is going to be used,
do the following to configure a Windows Account as a db_owner of a
SQL Server database.
Prerequisites
- These instructions do
not apply to
the following installation scenarios:
- AgilePoint Server Service Account and the AgilePoint System User Account
must have the db_owner access privilege for the
database.
Navigation
- On the database server, click Start > All Programs > Microsoft
SQL Server [Version] > SQL Server Management
Studio.
- Navigate to the node of the SQL Server instance containing the workflow database.
Instructions
- On the workflow database node, right-click on Security and select
New User.
- Enter the User name and Login name of the user account that you wish to grant privileges to.
- Under the Database role membership group box, grant db_owner access.
- Click OK.
