在执行Windows桌面登录时联合到SQL Server [英] federate to SQL server while doing a windows desktop login

问题描述

We have a SQL server which acts as a user data source for some of the SSO services for internal consumption.

Now, we are in the process of introducing Active Directory.


Post this, we expect that whenever a user logs into a windows desktop, he is directly authenticated / authorized with a active directory
when the user credentials are not present in the active directory, 
then, it should federate to the SQL server (containing the other users) and do the authentication / authorization. 
Is this possible?? 

推荐答案

嗨Darshan，

Hi Darshan,

是的，这是可能的。

根据您的方案，您需要将客户端SSO服务的连接字符串设置为Windows身份验证模式。此外，您的SQL Server需要设置为Windows身份验证模式，并确保托管SQL Server的服务器已加入
Active Directory。

Per your scenario, you need to set connection string for client SSO services to windows Authentication mode. Also, your SQL Server need to be set to windows Authentication mode, and make sure that the server which hosting SQL Server has been joined into Active Directory.

有关详细信息，请参考：

For more details, please refer:

通过Windows身份验证连接

最好的问候，

将

这篇关于在执行Windows桌面登录时联合到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！