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

Login failed for user sql1\guest #905

Open
eshess opened this issue Nov 7, 2024 · 0 comments
Open

Login failed for user sql1\guest #905

eshess opened this issue Nov 7, 2024 · 0 comments

Comments

@eshess
Copy link

eshess commented Nov 7, 2024

Docker host: Windows 11 Pro
MSSQL: mcr.microsoft.com/mssql/server:2022-CU9-ubuntu-20.04 (also tried latest but saw LDAP errors, downshifting to here cleared those)

Following the directions here I'm able to connect as SA and add Windows logons to the running instance within my container. However I'm unable to actually use integrated authentication to access it. My container is running on a Windows 11 workstation and attempting to connect to it using SSMS or Invoke-SqlCmd from the host machine, I get the error:

Login failed for user sql1\guest

If I kill firewalls and connect from a neighboring machine, I get this error instead:

2024-11-06 13:55:32.82 Logon       Error: 17806, Severity: 20, State: 14.
2024-11-06 13:55:32.82 Logon       SSPI handshake failed with error code 0x80090308, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The operating system error code indicates the cause of failure. The token supplied to the function is invalid   [CLIENT: 172.17.0.1]
2024-11-06 13:55:32.88 Logon       Error: 18452, Severity: 14, State: 1.
2024-11-06 13:55:32.88 Logon       Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. [CLIENT: 172.17.0.1]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant