gpt4 book ai didi

sql-server - 在 MSSQL (linux docker) 上为本地 Windows 用户创建登录

转载 作者:太空狗 更新时间:2023-10-29 12:10:28 26 4
gpt4 key购买 nike

是否可以为在 Windows PC(无 Active Directory)上作为基于 linux 的 docker 镜像运行的 MSSQL 创建一个 Windows 用户登录?

CREATE LOGIN [PC-NAME\LocalUser] FROM WINDOWS

如果是,docker 镜像需要哪种配置才能执行此操作?目前我收到以下错误:

Windows NT user or group 'PC-NAME\LocalUser' not found. Check the name again.

最佳答案

MS Docs: Configure SQL Server 2017 container images on Docker

Eugene_Resnick Aug 18, 2017 Anyway to connect to the DB without using SA? Either a local account on the Windows host or through a gMSA on the host containers domain? LuisBosquez Aug 23, 2017

@Eugene_Resnick Integrated Authentication is still not supported on SQL Server on Linux. You can create a new login and connect to it like a regular installation of SQL Server. In fact, we recommend at least changing the SA password after it was first provisioned.

关于sql-server - 在 MSSQL (linux docker) 上为本地 Windows 用户创建登录,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/46786639/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com