Based Authentication in SQL Server

 

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:

  • Is this possible with SQL Server ?

  • The idea is to no longer include the username/password combination to connect to the Database Instance from the Server. This then would be replaced by a certificate where, ideally would hold all the login credentials (encrypted). So in simpler terms, every pc that will use the system will need to be issued a certificate to connect to the database.

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

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

    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.

    链接地址: http://www.djcxy.com/p/7732.html

    上一篇: 如何在运行时在.NET中将文件夹添加到程序集搜索路径中？

    下一篇: 基于SQL Server的身份验证