What are the required SQL Server permissions to install Timetracker for DevOps Server?

Question

When installing Timetracker, I get the error, below, when I run the 7pace Timetracker for DevOps Server Configuration Tool:

Initializing ...OK

Setting up the extension ...OK

Setting up the legacy extension ...OK

Patching the web.config file ...OK

Creating the database ...OK

Creating the website ...ERROR

Error message:

Could not get access to the database users

InnerException: User does not have permission to perform this action.

Could not get access to the database users

InnerException: User does not have permission to perform this action.

Can you help?

Answer 

If a user does not have sufficient permissions to create a user on SQL server and to add this user to the Timetracker database Configuration Tool, the error you described, above, will display.

To successfully complete the installation of Timetracker, the user making the SQL connection should have access to the following:

sys.database_principals 

sys.sysusers

sys.syslogins

tables in SQL Server. 

Additionally, this user should have permissions to Create Logins in SQL Server.

Please note: These permissions are required only for the configuration step, and can be reduced, if necessary, after successful setup.