When using a SQL authentication user for steps 2 and 3 of the RMAD portal installation wizard, you get an error stating:
Could not initialize the Recovery Manager Portal database on the SQL Server.
Make sure the access account you have specified has sufficient privileges on the SQL Server.
You have confirmed that the account does indeed have the required access, but it always fails.
In the install log, the following error stack appears:
Could not initialize the Recovery Manager Portal database on the SQL Server.
Make sure the access account you have specified has sufficient privileges on the SQL Server.
System.Data.SqlClient.SqlException (0x80131904): Cannot find the user '<username>', because it does not exist or you do not have permission.
Changed database context to 'RecoveryMgrPortal'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Setup.CustomAction.CaInitializePortalDatabases.ExecSqlQuery(Action`2 logInfo, String connectionString, String queries)
at Setup.CustomAction.CaInitializePortalDatabases.CreateDatabase(String connectionString, String databaseName, String serviceUserName, Action`2 logInfo)
at Setup.CustomAction.CaInitializePortalDatabases.InitializePortalDatabases(Session session)
ClientConnectionId:153f6744-d39f-47db-b7de-392a61479814
Error Number:15151,State:1,Class:16
CustomAction.InitializePortalDatabases(): Exit. Result Failure