什么是SPN设置？ [英] What is SPN settings?

问题描述

我正在尝试了解有关SPN的更多信息。究竟是什么？如何设置，编辑，删除它？

解决方案

它用于向Active Directory注册SQL Server服务帐户。这通常在服务器重启时自动完成。

如果你需要使用kerberos身份验证，这将被使用 - 主要是当你需要使用链接服务器进行双跳时。

此链接应该有所帮助：

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/register-a- service-principal-name-for-kerberos-connections？view = sql-server-2017

https://www.mssqltips.com/sqlservertip/2955/register-a-spn-for-sql-server-authentication -with-kerberos /

这里讨论了如何手动设置或管理它。

https://social.technet.microsoft.com /wiki/contents/articles/717.service-principal-names-spns-setspn-syntax-setspn-exe.aspx

I'm trying to learn more about SPN. What exactly it's for? How do I set, edit, remove it?

解决方案

It is used to register your SQL Server service accounts with the Active Directory. This is normally done automatically on server restart.

This will be used if you need to use kerberos authentication -mainly when you need to do a double hop using a linked server.

This link should help:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections?view=sql-server-2017

https://www.mssqltips.com/sqlservertip/2955/register-a-spn-for-sql-server-authentication-with-kerberos/

This talks about how to manually set it or administer it.

https://social.technet.microsoft.com/wiki/contents/articles/717.service-principal-names-spns-setspn-syntax-setspn-exe.aspx

这篇关于什么是SPN设置？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！