Is it possible to logon to, for example, a SQL server database using a domain account from a windows server container (either hyper-v or regular container)? As I understand you can't domain join the container itself (neither server Core nor server Nano base image). Does it matter if the host is domain joined?
The Local Security Authority (LSA) is a protected system process that authenticates and logs users on to the local computer.
Windows containers cannot be domain joined, but many Windows applications that run in Windows containers still need AD Authentication. To use AD Authentication, you can configure a Windows container to run with a group Managed Service Account (gMSA).
Windows authentication means the account resides in Active Directory for the Domain.
For those that really need domain authentication in SQL Server containers, There is a solution from Windocks that has domain authentication by default. The SQL Server containers use the domain accounts specified in the default instance in each container. So if you had an account named \ that had access to the default SQL Server instance, then will also have access to the container. Sa specific to each container is also available. See the Windocks site about Docker SQL Server containers for more information.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With