SQL Server中基于证书的身份验证 [英] Certificate-Based Authentication in SQL Server

问题描述

目前，我正在为我当前的项目而苦苦挣扎.我的任务是将对基于用户名/密码的身份验证/连接的使用替换为SQL Server(2014)，并将其替换为基于 Certificate的Authentication/Connection .所以可能我的问题是:

currently i'm struggling with my current project. I was tasked to replace the use of Username/Password based Authentication/Connection to SQL Server (2014) and replace it with a Certificate based Authentication/Connection one. So probably my questions are:

1. SQL Server可以吗?

1. Is this possible with SQL Server ?

• 这个想法是不再包含用户名/密码组合以从服务器连接到数据库实例.然后，将其替换为证书，该证书在理想情况下将保存所有登录凭据(已加密).因此，用更简单的术语来说，每台将使用该系统的PC都需要获得一个证书才能连接到数据库.

如果可能的话，这是全部或一台计算机的单一证书-一份证书吗?

If possible, is this a Single Certificate for All or One Computer - One Certificate ?

希望在这里获得一些好/不好的意见.谢谢

hoping to get some good/bad opinions here. thank you

推荐答案

我们在说什么证书来自Active Directory网络或网页中使用其SSL证书进行身份验证的根证书颁发机构?还是仅出于此目的而生成的证书?哪种语言/程序正在尝试使用证书进行授权.我假设使用C#，但我只是想确定一下.

What Certificate are we talking about One coming from a Root Certificate Authority In an Active Directory Network or a webpage using its SSL Cert to Authenticate back into the SQL Server? Or is this a Certificate that was generated solely for this purpose? What language/program is trying to Use the Certificate to Authorize. Im Assuming C# but I just want to make sure.

这篇关于SQL Server中基于证书的身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！