while i run the analysis report, i hit the below error.
DEA Information: 0 : DiagnosticEvent, 07/27/2023 10:06:46, Data: {"Message":"SqlPackage.exe found from the Data-Tier Application Framework Installation path [C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe].","Timestamp":"2023-07-27T10:06:46.5630633Z"}
DEA Information: 0 : DiagnosticEvent, 07/27/2023 10:06:57, Data: {"Message":"Process C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe /Action:Publish /SourceFile:\"ExperimentationDatabase.dacpac\" /TargetDatabaseName:\"Analysisreport1638260492064800950\" /TargetServerName:\"SQL2019\" /Variables:\"DatabaseA\"=\"Areport1638260492064800950\" /Variables:\"DatabaseB\"=\"Breport1638260492064800950\" /Variables:\"ReportName\"=\"report1\" /Variables:\"DEAVersion\"=\"2.6.61459.2\" /Variables:\"SchemaVersion\"=\"1.3\" /p:BlockOnPossibleDataLoss=False completed with exit code: 1","Timestamp":"2023-07-27T10:06:57.8601219Z"}
DEA Information: 0 : DiagnosticEvent, 07/27/2023 10:06:57, Data: {"Message":"Process output: ","Timestamp":"2023-07-27T10:06:57.8601219Z"}
DEA Information: 0 : DiagnosticEvent, 07/27/2023 10:06:57, Data: {"Message":"Error occurred while running process. Command: \"C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe /Action:Publish /SourceFile:\"ExperimentationDatabase.dacpac\" /TargetDatabaseName:\"Analysisreport1638260492064800950\" /TargetServerName:\"SQL2019\" /Variables:\"DatabaseA\"=\"Areport1638260492064800950\" /Variables:\"DatabaseB\"=\"Breport1638260492064800950\" /Variables:\"ReportName\"=\"report1\" /Variables:\"DEAVersion\"=\"2.6.61459.2\" /Variables:\"SchemaVersion\"=\"1.3\" /p:BlockOnPossibleDataLoss=False\", Error:\"*** Could not deploy package.\r\nUnable to connect to master or target server 'Analysisreport1638260492064800950'. You must have a user with the same password in master or target server 'Analysisreport1638260492064800950'.\r\n\r\n\"","Timestamp":"2023-07-27T10:06:57.8601219Z"}
DEA Information: 0 : DiagnosticEvent, 07/27/2023 10:06:57, Data: {"Message":"DacPac publishing failed.","Timestamp":"2023-07-27T10:06:57.8601219Z"}
DEA Information: 0 : MetricEvent, 07/27/2023 10:06:57, Data: {"IsSuccess":true,"Name":"Duration","StartTime":"2023-07-27T10:06:46.5600638Z","Value":11300.780700000001,"Operation":"PublishDacPac","Timestamp":"2023-07-27T10:06:57.8611482Z"}
DEA Error: -2146233088 : ExceptionEvent, 07/27/2023 10:06:57, Data: {"Code":-2146233088,"Message":"Failed to generate new analysis report.","Operation":"AnalysisModel","Properties":{"ProductVersion":"15.0.4316.3","Version":"2.6.61459.2","SchemaVersion":"1.3","CreatedDate":"7/27/2023 10:06:46 AM","IsSchemaUpgradeRequired":"False","ProgressPercentage":"6","ErrorCode":"1004","Id":"23bba51e-7c76-4bb6-8b5f-5d3f34ef9d7a"},"Timestamp":"2023-07-27T10:06:57.8671206Z"}, 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()
yes. user is one of sysadmin
query
select r.name as Role, m.name as Principal
from master.sys.server_role_members rm inner join master.sys.server_principals r on r.principal_id = rm.role_principal_id and r.type = 'R'
inner join master.sys.server_principals m on m.principal_id = rm.member_principal_id
where m.name = 'SQL2019\labuser'
result
Role Principal
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
sysadmin SQL2019\labuser
(1 row affected)
here is the sql error log
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2023-07-27 09:51:48.040 Server Microsoft SQL Server 2019 (RTM-CU21) (KB5025808) - 15.0.4316.3 (X64)
Jun 1 2023 16:32:31
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hyper
2023-07-27 09:51:48.040 Server UTC adjustment: 0:00
2023-07-27 09:51:48.040 Server (c) Microsoft Corporation.
2023-07-27 09:51:48.040 Server All rights reserved.
2023-07-27 09:51:48.040 Server Server process ID is 4244.
2023-07-27 09:51:48.040 Server System Manufacturer: 'Microsoft Corporation', System Model: 'Virtual Machine'.
2023-07-27 09:51:48.040 Server Authentication mode is MIXED.
.
.
.
.
.
.
2023-07-27 09:52:29.120 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 09:52:29.120 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'AnalysisReport1638260483477650960'. [CLIENT: <local machine>]
2023-07-27 09:52:39.120 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 09:52:39.120 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'AnalysisReport1638260483477650960'. [CLIENT: <local machine>]
2023-07-27 10:04:34.430 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 10:04:34.430 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'Analysisreport2638260490716048968'. [CLIENT: <local machine>]
2023-07-27 10:04:44.440 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 10:04:44.440 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'Analysisreport2638260490716048968'. [CLIENT: <local machine>]
2023-07-27 10:06:47.800 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 10:06:47.800 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'Analysisreport1638260492064800950'. [CLIENT: <local machine>]
2023-07-27 10:06:57.800 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 10:06:57.800 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'Analysisreport1638260492064800950'. [CLIENT: <local machine>]
2023-07-27 10:09:24.220 Logon Error: 18456, Severity: 14, State: 38.
2023-07-27 10:09:24.220 Logon Login failed for user 'SQL2019\labuser'. Reason: Failed to open the explicitly specified database 'Analysisreport2638260493630376443'. [CLIENT: <local machine>]
2023-07-27 10:09:34.230 Logon Error: 18456, Severity: 14, State: 38.