How to configure SQL server before installing UiPath Orchestrator

0 votes
How to configure SQL Server before installing UiPath Orchestrator as its a prerequisite for installing orchestrator?
Apr 2, 2019 in RPA by Hemant

recategorized Apr 2, 2019 4,045 views

1 answer to this question.

0 votes

Hello Hemant, select one of the following options through which Orchestrator can connect to the SQL Server database.

  1. Windows Integrated Authentication. For this option, a new login is required for the SQL Server as a service account. The service account should be a domain user whose password never expires. To create a new login in SQL Server Management Studio:
    • In the Object Explorer panel, navigate to Security > Logins.
    • Right-click the Logins folder and select New Login. The Login - New window is displayed.
    • Select the Windows Authentication option. The window is updated accordingly.
    • In the Login name field, type the user domain you want to use as a service account.
    • From the Default Language list, select English.
    • Click OK. Your configurations are saved.

      image

       
  2. SQL Server username and password. In this case, a SQL Server user is required. We strongly recommend not to use a sa account. To create a new SQL user in SQL Server Management Studio:
    • In the Object Explorer panel, navigate to Security > Logins.
    • Right-click the Logins folder and select New Login. The Login - New window is displayed.
    • Select the SQL Server authentication option. The window is updated accordingly.
    • Fill in the Login NamePassword, and Confirm Password fields appropriately.
    • Ensure that the Enforce password expiration and User must change password at next login options are not selected.

      image

Regardless of the type of user (domain or SQL) you want to connect to SQL Server, please note that you need to assign it the dbcreator Server Role BEFORE installing Orchestrator, as the database is created during this installation process.

If security restrictions do not allow the use of the dbcreator Server Role in the service account, create the empty database in SQL Server. The Windows installer connects to SQL Server to verify the existence of the database. After creating the database, you need to provide the user which connects to the SQL database with the db_owner user mapping role, as in the following screenshot:

image

If security restrictions do not allow you to use the db_owner user mapping role with the UiPath login, grant the following:

  • db_datareader
  • db_datawriter
  • db_ddladmin
  • EXECUTE permissions on any stored procedure in the UiPath database

The EXECUTE permission has to be granted by using the GRANT EXECUTE SQL command, as follows.

  • if Windows Integrated Authentication is used:
      USE UiPath
      GO
      GRANT EXECUTE TO [domain\user]
      GO
  • if SQL Server Authentication is used:
      USE UiPath
      GO
      GRANT EXECUTE TO [sql_user]
      GO

answered Apr 2, 2019 by Pratibha
• 3,690 points

Related Questions In RPA

+2 votes
1 answer

How can I connect Robots to Orchestrator in UiPath?

Hey Rakshit, for connecting Robots to Orchestrator, ...READ MORE

answered Mar 12, 2019 in RPA by Abha
• 28,140 points
21,134 views
0 votes
1 answer

How to install and configure Native Citrix on UiPath studio?

Hi Utkarsh, Native Citrix support enables you ...READ MORE

answered Mar 28, 2019 in RPA by Abha
• 28,140 points
3,703 views
0 votes
1 answer

Prerequisites for installing UiPath Orchestrator Server

Hi @Disha, prerequisites for installing Orchestrator Server ...READ MORE

answered Apr 2, 2019 in RPA by Anvi
• 14,150 points
2,357 views
0 votes
1 answer

How Elasticsearch Server can be used in uipath Orchestrator?

Hey @Misha, Elasticsearch is used to store messages ...READ MORE

answered Apr 2, 2019 in RPA by Abha
• 28,140 points
4,158 views
0 votes
1 answer

How can I install Orchestrator for Uipath through Windows Installer?

Hi @Harshit, for installing UiPath Orchestrator through ...READ MORE

answered Apr 2, 2019 in RPA by Abha
• 28,140 points
5,797 views
0 votes
1 answer

How to install UiPath Orchestrator on an Azure App Service platform?

Hey @Jason, to install UiPath Orchestrator on ...READ MORE

answered Apr 2, 2019 in RPA by Abha
• 28,140 points
2,879 views
0 votes
1 answer

What are the Software requirements for installing UiPath Orchestrator?

Hey @Megha, software requirements for installing UiPath ...READ MORE

answered Apr 2, 2019 in RPA by Anvi
• 14,150 points
1,625 views
0 votes
1 answer

What all Hardware requirements are there for installing UiPath Orchestrator?

Hey @Ajit, hardware requirements for installing UiPath ...READ MORE

answered Apr 2, 2019 in RPA by Abha
• 28,140 points

edited Apr 2, 2019 by Abha 1,756 views
0 votes
1 answer

How to create and manage Users in UiPath Orchestrator?

Hello Rashmi, you can follow these steps ...READ MORE

answered Apr 5, 2019 in RPA by Pratibha
• 3,690 points
4,631 views
0 votes
1 answer

How to create a Floating Robot in UiPath Orchestrator?

Hello Rajan, to create a Floating Robot ...READ MORE

answered Apr 5, 2019 in RPA by Pratibha
• 3,690 points
2,534 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP