Loading...

Quick tip: SQL Server Management Studio 19 supports AAD service principal authentication

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
JOPX on Microsoft Business Applications and Azure Cloud
JOPX on Microsoft Business Applications and Azure Cloud

Share post:

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...

5 months ago

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...

8 months ago

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...

9 months ago

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...

9 months ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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...

2 years ago

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...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy