Creating an Extended Event in a SQL Managed Instance

Question

Creating an Extended Event in a SQL Managed Instance

DanielP

SSCrazy

Points: 2320
More actions
February 25, 2021 at 6:14 pm

#3850208

Recently moved our environment to SQL 2019 Managed Instance from SQL 2017 environment. Trying to re-setup the Extended Event we had running to capture Deadlocks but having issues using an Azure Data Blob for storing the Extended Event file.
The initial creation finally worked but when trying to start it get the following error:
"The target,....", encountered a configuration error during initialization. Object cannot be added to the event session. The operating system returned error 86: "The specified network password is not correct".
How to add the network password when creating the event?
Thanks,

Daniel
February 27, 2021 at 1:41 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

DanielP SSCrazy Points: 2320 More actions · Answer 1

I forgot to create the new Credential in SQL for the new Azure Storage Blob. Once I added it, I was able to create the Extended Event.

But now getting an error that the "File exists and t hat the SQL Server service account has access to it.".

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

The service account that SQL Server is running under must have access to the folder where you expect the Extended Event session to write to. It's nothing about creating the Extended Event itself. It's all about the network configuration and security settings externally.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

DanielP SSCrazy Points: 2320 More actions · Answer 3

In Managed Instance, what is the Service Account? Not the same as a regular instance where you setup the accounts and have control over it.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 4

Oh crud. Sorry. I totally missed that this was a managed instance. I actually have never set up Extended Events on MI. I've done it multiple times on Azure SQL Database, but I think it might be a little different. The issue is still one of permissions, but the solution is different.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

DanielP SSCrazy Points: 2320 More actions · Answer 5

I found an article that states to create a 'Scope' Credential but I think this applies only to Azure SQL Database. The workaround I have is to use Microsoft Azure Storage Explorer and download the file locally and then able to open it up and view the data. Not ideal as just viewing the data in SSMS.