All Questions
Tagged with sql-server azure-active-directory
136
questions
0
votes
0
answers
60
views
Connect to Azure SQL Server using windows credentials [duplicate]
I'm trying to connect to Azure SQL using on-prem AD account, which is synched to Azure AD.
I am able to connect using the SSMS when I run as a different user but programmatically it doesn't work.
It's ...
0
votes
1
answer
57
views
Login failed for user identified principal
With the following code (context WPF .Net Core app) and a user properly created in the database CREATE USER [<user principal name>] FROM EXTERNAL PROVIDER;
I can login in the user to the Azure ...
0
votes
0
answers
427
views
Connecting to Azure SQL Database with Entra ID and no password from Python app
I hope you can help me as I have been struggling for some days with this issue.
We have an Azure DB where we store data and through which we have some models that runs in python that interact with it. ...
0
votes
1
answer
50
views
Azure Directory Authentication doesn't work when the application is released while it works in Visual Studio
I have the following connection string to connect to a Datamart server.
@"Server=datamartservername; Authentication=Active Directory Interactive; Encrypt=True; Database=dbname";
It works ...
0
votes
1
answer
254
views
How can I use Passwordless authentication via JDBC through Azure Pipelines?
My goal is to use Service Principals for authentications instead of passwords in my Azure environment.
In my Azure Pipelines I have a database migration script that I'm struggling to get working with ...
4
votes
1
answer
5k
views
Azure Active Directory - Universal with MFA "missing" from SSMS authentication options
I am trying to connect to from SSMS/VS 2022 to a database hosted on Azure. When trying to login via either application, the authentication option "Azure Active Directory - Universal with MFA"...
0
votes
0
answers
190
views
Error connecting Power Apps to SQL Server using Azure AD Integrated authentication (The server is not currently configured to accept this token)
I have 2 tenants: Tenant 1 (@tenant1.org) and Tenant 2 (@tenant2.org). I have a Azure AD group (Group1) in Tenant 1 which has all users in Tenant 1. All users in Tenant 2 are added as guests in the AD ...
1
vote
1
answer
772
views
Failed to connect to Azure SQL Database using ODBC Driver 17 with Authentication=ActiveDirectoryMsi
I was trying to connect the Azure Container Instance to my Azure SQL Database using Azure Active DIrectory User Managed Identity. But I can't establish a connection using ODBC Driver 17.
Error Message:...
0
votes
1
answer
86
views
ASP.Net Application which uses SQLProvider and MemberShip Fails to connect to DB when using Azure Managed Identity
When migrating from sql server authentication to Azure Managed Identity we are facing the below login issue
Exception information:
Exception type: SqlException
Exception message: Login failed for ...
1
vote
1
answer
4k
views
Azure Data Studio 'login failed for user '<token-identified principal>' with MFA Support authentication
While trying to set up access for a user to access a SQL Server via Azure Data Studio, they are receiving the following error message:
'login failed for user '<token-identified principal>'
The ...
0
votes
0
answers
47
views
Connect to SQL with Azure.entity without DbContext
I have a .NET back-end with Entity Framework connecting to an Azure database DSL Server with azure.entity as mentioned here: https://learn.microsoft.com/en-us/azure/app-service/tutorial-connect-msi-...
0
votes
1
answer
92
views
Regarding Azure Active Directory Authentication for SQL Server
In our project we need to implement Active Directory authentication for SQL Server. The project is using the .NET framework, and we are making use of Entity Framework. We are making use of Active ...
0
votes
1
answer
844
views
Service Account authorisation Microsoft Azure SQL
I'm trying to access an Azure SQL based instance from my on-prem application. This access needs to be a Service Account (eg: non-interactive login). I've done this on multiple clouds but am ...
1
vote
2
answers
592
views
Connect Azure DB using "Active Directory Password" from SSIS
Using visual studio 2022, i want to connect to Azure - Dynamics CRM Database by Active Directory Password.
I configured a new connection using ADO.NET option and when i click "test connection&...
1
vote
1
answer
1k
views
How Add Azure AD Groups in Azure SQL Database
I want to add an azure AD group to sql server database, I was searching some helps in microsoft learn but I could only add individual AD users to databases. I would like create a group in Azure AD and ...