I would like to connect to an Azure SQL DB from Excel VBA without using credentials. I'm going to execute stored procedures from VBA etc. I can create a data connection manually in Excel- without entering credentials! I can create a connection via VBA - setting the authentication to "ActiveDirectoryInteractive" and then entering credentials and approve in the Authenticator-app. What to do?? Info: I have checked the https://www.connectionstrings.com/azure-sql-database/ . I'm not admin on the Azure SQL

Connect to Azure SQL from Excel VBA - without credentials

I would like to connect to an Azure SQL DB from Excel VBA without using credentials. I'm going to execute stored procedures from VBA etc.

I can create a data connection manually in Excel- without entering credentials!
I can create a connection via VBA - setting the authentication to "ActiveDirectoryInteractive" and then entering credentials and approve in the Authenticator-app.

What to do??

Info: I have checked the https://www.connectionstrings.com/azure-sql-database/. I'm not admin on the Azure SQL