I am getting an error when running the Analysis Report. All the Capture, Replay and Analysis report is being run on my local machine where I am admin.
Version is: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64)
Error:\"*** Could not deploy package.\r\nUnable to connect to master or target server 'AnalysisLoad638508966386301168'. You must have a user with the same password in master or target server 'AnalysisLoad638508966386301168'.\r\n\r\n\"","Timestamp":"2024-05-10T00:10:49.8536002Z"}
DEA Information: 0 : DiagnosticEvent, 05/10/2024 00:10:49, Data: {"Message":"DacPac publishing failed.","Timestamp":"2024-05-10T00:10:49.8536002Z"}
DEA Information: 0 : MetricEvent, 05/10/2024 00:10:49, Data: {"IsSuccess":true,"Name":"Duration","StartTime":"2024-05-10T00:10:38.6649741Z","Value":11188.8286,"Operation":"PublishDacPac","Timestamp":"2024-05-10T00:10:49.8536002Z"}
DEA Error: -2146233088 : ExceptionEvent, 05/10/2024 00:10:49, Data: {"Code":-2146233088,"Message":"Failed to generate new analysis report.","Operation":"AnalysisModel","Properties":{"ProductVersion":"15.0.4365.2","Version":"2.6.61459.2","SchemaVersion":"1.3","CreatedDate":"5/9/2024 5:10:38 PM","IsSchemaUpgradeRequired":"False","ProgressPercentage":"6","ErrorCode":"1004","Id":"f7c9924a-c2a1-4ead-ab04-b7e1abb80ee7"},"Timestamp":"2024-05-10T00:10:49.8576002Z"}, Exception:
[Exception Info]:Microsoft.DEA.Common.Exceptions.DeaException, Message:Exception of type 'Microsoft.DEA.Common.Exceptions.DeaException' was thrown.
StackTrace: at Microsoft.DEA.BusinessLogic.Actions.PublishDacPac.Run()
at Microsoft.DEA.BusinessLogic.ActionDecorator.<>c__DisplayClass2_0.<Run>b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.DEA.BusinessLogic.Bootstrappers.NewAnalysisXEvents.<RunAsync>d__21.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DEA.BusinessLogic.Bootstrappers.NewAnalysisXEvents.<RunAsync>d__21.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.BootstrapperFactory.<StartWorkflowAsync>d__37.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.BootstrapperFactory.<CreateNewAnalysisBootstrapperAsync>d__28.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.UI.ViewModels.MainRegion.NewReportViewModel.<StartNewAnalysisAsync>d__113.MoveNext()
Thanks
Dilip