Automation Suite’s Step 4 Permission to provision SQL
I am curious about the differences between the two below.
Does this mean that I have to choose whether I already have an ms-sql server installed or whether I want to install a new one?
Provision Database
The Installer will be able to create the necessary databases. Make sure the credentials the installer will use have permission to create databases on your SQL
Bring your own Database
You are responsible for setting up and configuring the databases
With either option you do need a existing SQL server installed.
Provision Database option is the easiest for cases where the account you use to connect to SQL during the install has the permissions to create databases in in SQL.
Bring your own is an option where you don’t have an account with permissions to create the databases and you have to ask your SQL administrator to pre-create the databases for you.
The installer will create the databases in the database server automatically as part of the installation. The user account provided to the installer during the installation must have rights to create databases on the server (e.g. dbcreator server role)
The installer will not create the databases in the database server during installation. You will need to create the databases manually before running the installer. The names of the databases to be created can be found here: Automation Suite - Configuring Microsoft SQL Server (uipath.com)