订阅

UiPath AI Center

UiPath AI Center

2. Configure Database

Overview

This step entails creating the necessary databases that will be used by the AI Fabric installer.

❗️

注意

  • This step creates a database and a login/user. To complete this step you need credentials that allow for these actions. In SQL server, this is the dbcreator role and the ddladmin role respectively.
  • The same AI Fabric databases (the databases created by this step) cannot be used in multiple AI Fabric instances.

Configure

  • Open Powershell in Administrator role.
  • Download the script here, for example using Powershell:
wget https://raw.githubusercontent.com/UiPath/ai-customer-scripts/master/database/createDatabases.ps1 -outfile "createDatabases.ps1"
  • You can familiarize yourself with the script options by entering:
get-help .\createDatabases.ps1 -full
  • The default parameters will work for most scenarios:
# If SQL Server can be accessed through Windows Authentication then:
./createDatabases.ps1 -sqlinstance "DESKTOP-LOUPTI1\SQLEXPRESS" -windowsAuthentication "Y"

The parameter sqlinstance is just the SQL Server name. This is exactly what you enter in the Server name field when you are using SQL Server Management Studio. For example:

  • As mentioned in the result of get-help .\createDatabases.ps1 -full, this script will create a login/password pair and four databases (suffix can be passed as an extra parameter to the script) where that login is a user. The script will output the login name (default aifadmin) and a randomly generated password to the console. It will also save a file with the login as the name of the file and the file contents as the password.

Please keep this login and password handy as they will be necessary when filling out the configuration screen in step 5. Run the AI Fabric Application Installer.

🚧

Common Sources of Error in the Downstream Installer from this step

Make sure that SQL Server Authentication mode is enabled.
Make sure the linux machine provisioned in step 1 has been added to the approved IP list of SQL Server.
Make sure that in firewall rules allow for inbound connections to port 1433 (the default port for SQL server)

Manual Configuration

The Databases and Roles can also be created using the following manual script. Modify the password field for the new login aifadmin but do not add single or double-quotes for the password:

--Create Databases:

create database ai_deployer;
create database ai_trainer;
create database ai_helper;
create database ai_pkgmanager;
create database ai_appmanager;

USE [master]
GO
CREATE LOGIN [aifadmin] WITH PASSWORD=N'Admin@123!'  -- (Change the Password as per your requirement )
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- create the user on the target database i.e ai_deployer for the login
USE [ai_deployer]
GO
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- add the user to the desired role
USE [ai_deployer]
GO
ALTER ROLE [db_owner] ADD MEMBER [aifadmin]
GO

-- create the user on the target database i.e ai_helper for the login
USE [ai_helper]
GO
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- add the user to the desired role
USE [ai_helper]
GO
ALTER ROLE [db_owner] ADD MEMBER [aifadmin]
GO

-- create the user on the target database i.e ai_trainer for the login
USE [ai_trainer]
GO
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- add the user to the desired role
USE [ai_trainer]
GO
ALTER ROLE [db_owner] ADD MEMBER [aifadmin]
GO

-- create the user on the target database i.e ai_pkgmanager for the login
USE [ai_pkgmanager]
GO
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- add the user to the desired role
USE [ai_pkgmanager]
GO
ALTER ROLE [db_owner] ADD MEMBER [aifadmin]
GO

-- create the user on the target database i.e ai_appmanager for the login
USE [ai_appmanager]
GO
CREATE USER [aifadmin] FOR LOGIN [aifadmin]
GO

-- add the user to the desired role
USE [ai_appmanager]
GO
ALTER ROLE [db_owner] ADD MEMBER [aifadmin]
GO

9个月前更新


2. Configure Database


建议的编辑仅限用于 API 参考页面

You can only suggest edits to Markdown body content, but not to the API spec.