Hello Justin,
I have reviwed the logs and it seems the setup failed on 2 places.
Firstly on SQL Permission issue for for local account 'STEWARD\MICROSOFT$DPM$Acct'.
<Snip>
[17/07/2023 12:53:27 PM] Information : Configuration Post SQL Service Start. Add local user account to SysAdmin
[17/07/2023 12:53:27 PM] * Exception : Ignoring the following exception intentionally => System.Data.SqlClient.SqlException (0x80131904): Cannot drop the login 'STEWARD\MICROSOFT$DPM$Acct', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
Secondly on creating the Report Databases.
ClientConnectionId:638d4487-d49f-46da-8286-9dd82745fa12
Error Number:15151,State:1,Class:16
[17/07/2023 12:53:28 PM] Information : Using WMI namespace '\\STEWARD\root\Microsoft\SqlServer\ReportServer\RS_SSRS\V16\admin'
[17/07/2023 12:53:28 PM] Information : found instance 'SSRS'
[17/07/2023 12:53:28 PM] Information : Starting Service:SQLServerReportingServices on machine:STEWARD flag restart:True
[17/07/2023 12:53:29 PM] Information : Generating script to create new RS databases
[17/07/2023 12:53:29 PM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Invoke SQL Api GenerateDatabaseCreationScript
at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.InvokeMethodHelper(ManagementObject targetObject, String methodName, Dictionary`2 arguments, ManagementBaseObject& outputObject, Int32 resultToIgnore)
*** Mojito error was: ReportServerConfigFailed; 0; None
So, request you to check and follow below mentioned things on MABS Server.
- Open SSMS, check for local account 'STEWARD\MICROSOFT$DPM$Acct' and give sysadmin permission to this account
- Secondly Open SSRS and create a report database manaully and use below mentioned configuration.
- Service Account: ‘Use built-in account’ should be Network Service
- Web Service URL: ‘Virtual Directory’ should be ReportServer_MSDPMINSTANCE(make sure that the URL is getting open without any errors)
- Database: DatabaseName should be ReportServer$MSDPMINSTANCE
- Web Portal URL: ‘Virtual Directory’ should be Reports_MSDPMINSTANCE(make sure that the URL is getting open without any errors)
Then again try to run the MABS Setup and hopefully it will work without any errors.