Azure SQL Server/Database - How to Create and Connect to it for RPA LE

If you want to move your entire Azure instance from on-prem to the cloud, you must set up RPA LE following these steps:

Create an Azure SQL server

1. Navigate to the Azure homepage: https://portal.azure.com/#home 
2. Search and select SQL Servers in the search bar, then click Create.
3. Under Subscription, select the HAL 9000 subscription.
4. For the Resource group, click Create new and create a new Resource group with a relevant name.
5. Under Server name, give your SQL Server a name (e.g., rpacdatabases), then change the Location underneath it, if necessary.
6. Under Authentication, select SQL Authentication, then create the server admin credentials.
7. You may skip to the Review + Create step, then click Create to finalize the setup.

Create an Azure SQL database

1. In the overview section of your newly created SQL Server, click Create Database.
2. In the Basics tab, fill in the database name, RPACentralKeys, and leave all other fields with their default values unless storage requirements differ. In that case, configure the storage as per requirements.
3. Click Next: Networking to configure the networking settings.
4. In the Networking tab, enable the option to Add the current client IP address (ensure you're configuring this on the client machine where the database will be running/accessed)
5. Click Review + Create to finalize the database setup.
6. Repeat Steps 1-5 for the RPACentralWeb database.

Connect RPACentral to Azure databases

1. Run the RPACentral Installer and install the application.
2. After installation and the RPACentral website opens, fill in the required domain details.
3. On the RPACentral welcome screen, select Microsoft SQL Server.
4. On the Microsoft SQL Server screen, select By Username & Password, then click Next.
5. Fill in the previously set SQL Server Name created in Step 5 of this article’s Create an Azure SQL Server section.
6. Fill in the previously set credentials created for Username and Password in Step 6 of this article’s Create Azure SQL Server section.
7. Click Test Connection. If the test is successful, click Next to finalize the setup.
8. On the License page, enter your assigned RPACentral License.
9. Create a new botflow, publish the botflow, then run the botflow to ensure RPACentral works correctly.

Add More Users to Connect to Azure Database Server Using SQL Server Management Studio (SSMS) or Azure Data Studio (ADS)

1. Connect to your Azure Database in SSMS or ADS
2. Open a new query and execute the following script to create a new Server Login:
   USE master

CREATE LOGIN testLogin

WITH PASSWORD = '<Strong_Password_Goes_Here>';
3. After Creating the Server Login, execute the following script to create a Database User:
   USE <Database Name goes here>

CREATE USER [testLogin]

FROM LOGIN [testLogin]

WITH DEFAULT_SCHEMA=dbo;

ALTER ROLE db_owner ADD MEMBER [testLogin];
4. Connect RPACentral to Azure Database using the newly created user.