First published on MSDN on Aug 06, 2018
Authored by rajsell@microsoft.com
Overview
The Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. Th...
Updated Feb 21, 2023
Version 9.0
Blog Post
Hello,
I am unable to capture a trace using DEA. Every time I run it against my production server, I see this error in the logs
onEvent, 12/20/2023 13:54:03, Data: {"Code":-2146232060,"Message":"SQL Exception occurred while starting trace on the server","Timestamp":"2023-12-20T13:54:03.6737577Z"}, Exception:
[Exception Info]:System.Data.SqlClient.SqlException, Message:For target, "package0.event_file", the parameter "filename" passed is invalid. Target parameter at index 0 is invalid
Cannot alter the event session 'DEAXEventsCapture_testtrace', because it does not exist or you do not have permission.
My account is sysadmin on target server and also sql server service account has full permissions on the Log folder.
Please let me know how can I fix this issue.
Regards,
Anoop