In this article you will learn the process or requirements for SQL credentials during Orion Configuration wizard to connect the application with SQL server and logic behind the process .
Stage # 1.
In the configuration wizard 1st step , we need to use a "sa" account (recommended) the logic behind that is the "sa" account is the member of sysadmin role , & therefore "sa" & sysadmin roles are the members of dbcreator server role by default.
In the meantime you can also use the Windows authentication account (as far as that account is a member of dbcreator server role).
The reason we use high privileged account on the 1st step so we can access the SQL server without any security issues and as mentioned the sa account is a member of dbcreator server role by default (who have privileges to create a new database within SQL server)
Stage # 2
Now in the 2nd step of configuration wizard you simply select to create a new database (SolarWindsOrion) name of the orion database. Or an existing migrated Database
Stage # 3
Finally in the 3rd option you have to create a new "SQL authentication account" called "SolarWindsOrionDatabaseUser" the logic behind to create this account (it is just a public account that have read/write access to the Orion database) and nothing other then that, for day to day activities.Its not feasible as security point of view to use the "sa" account to access the Orion database,as this account has far more privileges and therefore not suitable in a day to day scenario.
I have already created SQL account for Orion where i can use it in configuration wizard ?
So if you do have already 3rd option account created you can simply use that account while connecting to the SQL Database on 1st step