Azure Extended Event Target File

1
votes

I'm trying to setup Extended Events session on an Azure SQL DB. I've followed the instructions of the following Azure document: Event File target code for extended events in SQL Database

I'm getting the following error message:

Msg 25602, Level 16, State 1, Line 90 The target, "XXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXX.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event session. (null)

The session is created but cannot be activated. I'm not sure if it's a permissions error, or if I'm misunderstanding which fields are which.

It should be noted that I am able to create containers and load files to those containers in the target blob storage using my own user credentials, and running the PowerShell script actually creates the container and SAS policy with no issues.

The problem only occurs when I try to start my session.

Any suggestions?

1
azureazure-sql-databaseextended-events

1 Answers

0
votes

Change the type of the storage account to General Purpose and it will work. I faced that error myself and created an article here with the solution.