Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] Integrated Windows Authentication #4938

Closed
william-msft opened this issue Sep 20, 2024 · 1 comment
Closed

[Bug] Integrated Windows Authentication #4938

william-msft opened this issue Sep 20, 2024 · 1 comment
Labels
needs attention Delete label after triage untriaged Do not delete. Needed for Automation

Comments

@william-msft
Copy link

Library version used

msal-net

.NET version

I'm trying to access prod db, from SAW using AME account, using Connect to Production SQL Server | Container Apps TSG (eng.ms) and get these errors:

TITLE: Connect to Server
------------------------------
 
Cannot connect to capps-sql-japaneast.database.windows.net.
 
------------------------------
ADDITIONAL INFORMATION:
 
Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).
Error code 0xparsing_wstrust_response_failed
There was an error parsing the WS-Trust response from the endpoint. 
This may occur if there are issues with your ADFS configuration. See https://aka.ms/msal-net-iwa-troubleshooting for more details.
Enable logging to see more details. See https://aka.ms/msal-net-logging. (Microsoft SQL Server, Error: 0)
 
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-0-database-engine-error
 
------------------------------
BUTTONS:
 
OK
------------------------------

image

I can't find what Error 0 corresponds to.

Scenario

Other - please specify

Is this a new or an existing app?

None

Issue description and reproduction steps

  1. Open SQL Management Server using AME account with SAW
  2. Connect to database, as show in screenshot. This produces error.

Relevant code snippets

No response

Expected behavior

No response

Identity provider

Microsoft Entra ID (Work and School accounts and Personal Microsoft accounts)

Regression

No response

Solution and workarounds

No response

@william-msft william-msft added needs attention Delete label after triage untriaged Do not delete. Needed for Automation labels Sep 20, 2024
@william-msft william-msft changed the title [Bug] [Bug] Integrated Windows Authentication Sep 21, 2024
@bgavrilMS
Copy link
Member

bgavrilMS commented Sep 23, 2024

Please reach out to SQL team first. Let's not discuss about AME on GitHub.

@bgavrilMS bgavrilMS closed this as not planned Won't fix, can't repro, duplicate, stale Sep 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs attention Delete label after triage untriaged Do not delete. Needed for Automation
Projects
None yet
Development

No branches or pull requests

2 participants