Quick tip: SQL Server Management Studio 19 supports AAD service principal authentication
If you're using SQL Server Management Studio 19, you'll be pleased to know that it supports AAD service principal authentication. This quick tip highlights the support for AAD service principal authentication in SQL Server Management Studio 19, which is a welcome feature for those working with managed instances or Azure SQL databases.
This authentication mechanism eliminates the need for SQL Server logins and the associated hassle of managing passwords. Instead, users can use service principal authentication to access their databases securely and easily. The author of this blog post outlines the steps to set up AAD authentication in SQL Server Management Studio 19 and provides useful tips to ensure a seamless setup process.
So, if you're looking for a hassle-free authentication experience when accessing your managed instances or Azure SQL databases within SQL Server Management Studio 19, give AAD service principal authentication a try by following the steps outlined in this post.
The post Quick tip: SQL Server Management Studio 19 supports AAD service principal authentication originally appeared on jopx.blogspot.com.
Published on:
Learn more
Related posts
Using AI for Content Moderation with Azure SQL Database
Learn how to harness the power of AI in content moderation with Azure SQL Database through the creation of stored procedures and the encapsula...
Azure SQL Database Elastic Jobs preview refresh
The Azure SQL Database Elastic Jobs preview has received a significant "refresh", including several capabilities requested by customers. Among...
Creating a Kubernetes Application for Azure SQL Database
Modern application development requires overcoming several challenges, including selecting a front-end stack, data storage and processing from...
New Azure SQL Database free offer
If you're looking for a fully loaded Azure SQL serverless database, you'll be thrilled to learn about the new Azure SQL Database free offer. T...
Change Tracking in Azure SQL Database
For those looking to track changes in their Azure SQL Databases, there are two options available: Change Tracking and Change Data Capture. Thi...
Migrating On-Premises databases to Azure SQL Database: Everything you need you know
Are you considering migrating your on-premises databases to Azure SQL? If so, this article is a must-read, as it covers everything you need to...
Allow Azure Services and resources to access this server – How it works in Azure SQL Database?
When creating an Azure SQL Database, one of the initial options you'll come across is the "Allow Azure Services and resources to access this s...
Maximizing Azure SQL Database performance with a globally distributed Redis write-behind cache
For those looking to leverage Azure SQL Database for high-performance data storage, this post explores the potential of using a globally distr...
Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022
Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 have recently announced enhancements to their JSON text processing capabili...
Azure SQL Database Ledger
In this special episode, Pieter Vanhove joins Sarah and Michael to provide insights into the latest feature of Azure SQL Database Ledger. This...