Issues installing Orion Platform using a RDS SQL instance back end

hallstev5

I am attempting to install Orion Platform on a new set of servers using a RDS instance back end.  I have a windows domain account for the authentication.  The configuration wizard fails after approximately 9%.  The error message is Can not add '%user account%' user to database 'SolarWindsOrion' where %user account% is the domain account that is being used to connect to the database. Looking into the Configuration Wizard Log file, the following error occurs more than once.  System.Data.SqlClient.SqlException (0x80131904): Could not obtain information about Windows NT group/user '%user account%', error code 0x54b.  The user account has "create any database privilege" in RDS, but doesn't have any other permissions like DBCREATOR due to AWS RDS restrictions.  The user account was able to create the SolarWindsOrion database.  The user account is also a regular domain user with no special permissions.

My question is, am I missing any permissions in RDS that are needed to install/configure the Orion Platform?  Am I missing any permissions for my user account needed to install/configure the Orion Platform?

mesverrum

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html

Haven't used AWS RDS but I've done a few others, you need to make sure your account has at least ALTER ANY LOGIN and probably ALTER ANY USER, not sure exactly how AWS doles those permissions out but that will get you past the point you are in.  

Generally speaking I would recommend you run the installer using the AWS Master account, and then when it gets to the part where it asks you which account to use to access the DB then you give it your AD account.  That's basically the same idea as running it as SA to begin and then telling it to create the solarwindsoriondatabaseuser in a traditional install.