SQL Server中的登录验证问题 [英] Login authentication problem in SQL server
问题描述
我有一个疑问。对你们所有人来说也许非常愚蠢但对我来说现在它非常大。
有人告诉我在sql中为我的系统启用sql身份验证。所以我启用了。
现在我怀疑的是我是否可以在所有客户端系统中启用该身份验证。我在使用sql express 2014而没有安装任何服务器管理工作室。所以我现在必须做的。是否有必要在其系统中启用该身份验证。如果是,那我该怎么办呢?
我尝试过:
我在网上搜索但没有为我的问题找到合适的解决方案
I Have one doubt. Maybe very silly for you all. But for me it is very big now.
Someone told me to enable sql authentication in sql for my system. so I enabled.
Now what my doubt is can I have to enable that authentication in all my clients systems. There i am using sql express 2014 and not installed any server management studio. So what I have to do now. Is this necessary to enable that authentication in their systems also. If yes then how can I do that?
What I have tried:
I searched in net but not find suitable solution for my problem
推荐答案
在客户端你不必以任何方式启用身份验证。
您的客户必须选择登录sql:
a)Sql身份验证(然后他们必须提供sql用户和密码)
b)Windows身份验证(然后提供windows用户登录sql)
In the clients you dont have to enable authentication in any way.
Your clients have to options to login in the sql:
a) Sql authentication (and then they have to provide an sql user and a password)
b) Windows authentication (and then the windows user is provided to login in the sql)
这篇关于SQL Server中的登录验证问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!