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 in RPA by Hemant

recategorized Apr 2 134 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by Pratibha
• 2,520 points

Related Questions In RPA

0 votes
1 answer

How can I connect Robots to Orchestrator in UiPath?

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

answered Mar 11 in RPA by Abha
• 5,840 points
266 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 in RPA by Abha
• 5,840 points
120 views
0 votes
1 answer

Prerequisites for installing UiPath Orchestrator Server

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

answered Apr 2 in RPA by Anvi
• 5,880 points
40 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 in RPA by Abha
• 5,840 points
89 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 in RPA by Abha
• 5,840 points
30 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 in RPA by Abha
• 5,840 points
92 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 in RPA by Anvi
• 5,880 points
20 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 in RPA by Abha
• 5,840 points

edited Apr 2 by Abha 23 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 4 in RPA by Pratibha
• 2,520 points
18 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 in RPA by Pratibha
• 2,520 points
37 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.