Articles in this section

See more

Permission & Roles needed to install Leapwork

Avatar
Praveen Kumar
  • Updated
Follow

Permission for installing Leapwork (Studio, Controller or Agent)

You must have full administrative access to the Windows computer you wish to install or upgrade Leapwork on. Full administrative privileges are essential because installation requires access to the Windows registry and Windows System folders.

If you are trying to install software on a computer in a corporate or networked Windows environment but do not have the necessary privileges, you will need to contact your system administrator to install the software for you. These rights are not required to run Leapwork once it is properly installed.

SQL Database Permission Required to Setup the Enterprise Edition 

As a first step, Leapwork creates a database and tables in MS-SQL after connecting to it, so it's essential to use an MS-SQL server during the installation phase.

To access & manage SQL infrastructure download SQL Server Management Studio (SSMS). SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases.

The database user must have the dbcreator role in MS-SQL. Members of the dbcreator fixed server role can create, alter, drop, and restore any database.

mceclip1.png

 

Please note : MS SQL (version 13), 2017 (version 14), 2019 (version 15), Azure SQL is also supported.

Once the database and tables are created and/or migration is completed, dbcreator access from the MS-SQL server can be removed.

Leapwork Enterprise installation, for SQL Server the dbcreator is a highly privileged permission and database administrators in an organization will often be reluctant to give this permission.

In this scenario, the below approach can be used where the dbcreator role is not required.

The SQL Server database administrator can create the two blank databases (e.g., Assets & Report) and grant the db_owner access to SQL user created to use during Leapwork installation to connect the databases.

Steps to create blank databases.

Step 1 - Open SQL SSMS (SQL Server Management Studio)

Step 2 - Go to Databases > right-click > New Database.d1.png

Step 3 - Name the Database and select the Owner (the SQL user created for Leapwork) for the database.

d2.png

If the owner not selected in the above step, later db_owner role can also be mapped from SSMS (SQL Server Management Studio)

Step 1 – Open SSMS

Step 2 - Go to Security – Logins – User

Step 3 - Right-click on the user – Properties, map the db_owner role to the databases created as shown in the below image.

d3.png

We can also use the below SQL Query in SSMS for creating a database & assigning the db_owner role.

create login username with password = 'Password'
go
create database Report
go
use Report
go
create user username for login username;
go
EXEC sp_addrolemember 'db_owner', 'username'
go
create database Asset
go
use Asset
go
create user username for login username;
go
EXEC sp_addrolemember 'db_owner', 'username'
go

 

If you require further clarification, please contact our Priority Support.

Related articles

Comments

0 comments

Please sign in to leave a comment.