Azure SQL programmatic access
I work with a team of statisticians who would like to programmatically access an Azure SQL database via R/R Studio without human interaction. Access is setup currently with Microsoft Entra with MFA. The team ideally want to run their R script and connect to the database, without having to be there to enter their login credentials and MFA, can this be done via a key or SAS token? What is the best or recommended method to do this? Thank you. ZSSIS & Azure SQL Managed Instance with MFA
We've been testing out Azure SQL Managed Instance and created SSIS packages to run against it. We set connections using the ADO.Net connection manager and all worked well. We recently had to apply MFA to all logins and this is causing issues within SSIS as there is no MFA option for logins like there is in SSMS. We can connect if we use SQL Server Authentication but we'd rather not do that. When using Active Directory Integrated Authentication, all of our test connections fail and the package will not run locally. In SSMS, there is an integrated authentication with MFA option and that works from within SSMS. How can we use SSIS and connect to the database using Windows Authentication when MFA is required?
Azure Logic App: SQL trigger on When Row Is Update is not working
Hello Experts, I'm using the "When a row is updated" SQL connector in my logic app workflow. I turned on change tracking on the Azure SQL DB and the table in question per requirements. The connector connects to the SQL instance okay, but never triggers when a row is updated. No errors or indications to troubleshoot. Has anyone been able to get this to work? Thanks, -Sri
"AuthDBContextConnection" appsettings.json connecting to Azure VM SQL
Hi Community I'm trying to create a simple login/registration web app using ASP.NET Core Web App in Visual Studio 2019. I'm having difficulty of connecting to my MS SQL running as IaaS in Azure. In the appsettings.json file, there's a connection string already indicated but the format I'm using isn't working properly. Like to check if this format is correct: "AuthDBContextConnection": "Server=DNSName_Azure;Database=MVCAuthDB;Trusted_Connection=True;MultipleActiveResultSets=true;User ID=username;Password=password" Also, using Packet Manager Console to push the tables/data to the database. Highly appreciate your responses. Note: Tested to connect in VS -> Tools > Connect To Server > and it is working; port 1433 is open NSG
