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. ZEncrypted backups using Asymmetric key
Hello, I am creating asymmetric keys at the master level and at the database level. Asymmetric keys are showing in the security option, but when I am trying to take encrypted backup using asymmetric keys no keys are visible. I have already created an encrypted backup by using certificates, now I am trying to create an encrypted backup using an asymmetric key.
Digital event: Innovate Today with Azure SQL on May 4
Stay on the cutting edge of cloud-based database possibilities at our latest Digital Event. Join us for the Innovate Today with Azure SQL digital event and find out how to build an effective cloud database management strategy to respond to today’s changing business needs and tomorrow's opportunities. Register now to: Learn how to build intelligent apps across your data workloads using the latest digital innovations from Azure SQL and attend on-demand sessions on IaaS (infrastructure as a service) to PaaS (platform as a service) migration, optimizing performance, and SQL Edge. Watch Microsoft MVP and Microsoft engineering-led technical demonstrations of Azure SQL database services, including serverless compute and Hyperscale. Hear from real customers about how they are transforming their organizations using Azure SQL right now. Get the answers to your questions from Azure SQL subject-matter experts. Register now and attend this live digital event for a chance to win Surface headphones (five winners total). Winners will be selected at random. Innovate Today with Azure SQL Tuesday, May 4, 2021 10:00 AM-11:00 AM Pacific Time NO PURCHASE NECESSARY. Open to any registered event attendee 18+. Sweepstakes ends May 4, 2021. For Official Rules, see https://aka.ms/InnovateTodayAzureSQLsweepstakes.
Deploying a Dacpac using SQLPackage
Hi, I'm trying to use SQLPackage to deploy a Dacpac using AccessToken authentication. I'm using the following command... .\sqlpackage.exe /Action:Publish /SourceFile:Database.dacpac /TargetServerName:xxxx.database.windows.net /TargetDatabaseName:DatabaseName /AccessToken:xxxx The error message I'm getting is: Unable to connect to target server 'xxxx.database.windows.net'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server. Login failed for user '<token-identified principal>'. Any ideas what's wrong here?
