Extended events in Azure - Object cannot be added to the event session

Question

I am trying to create Extended Events on an Azure SQL DB. I have followed the instructions of the below Azure documents:

http://andreas-wolter.com/en/1804-tracing-with-extended-events-in-azure-sql-database/

https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/03/13/extended-events-capture-step-by-step-walkthgrough/

I am successfully created Extended events session. When I tried to start my session, I am getting below error message .

> TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

ADDITIONAL INFORMATION:

The target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", encountered a configuration error during initialization. Object cannot be added to the event session. The operating system returned error 5: 'Access is denied. ' while creating the file 'https://xxxxxxxxxxxxxxxx.blob.core.windows.net/Container/FileName_0_132028925297100000.xel'. (Microsoft SQL Server, Error: 25602)

Please note that I have created container using azure portal and I am able to upload files from portal.

Please suggest me to resolve the error.

Answer 1

As Per my past experience , I also faced the same issue. And that cause because of case sensitive of Storage URL or container name. Please validate again with your URL. Might be it resolve your problem.