如何设置SQL 的SPN及 Command
上一篇 /
下一篇 2016-05-24 14:45:41
/ 个人分类:SQL
SPN Command:
setspn -A MSSQLSVC/<servername>.<domainname>:STAGE <SQL RUNING ACCOUNT>
setspn -A MSSQLSVC/<servername>:STAGE <SQL RUNING ACCOUNT>
setspn -A MSSQLSVC/<servername>.<domainname>: <dynamic port> <SQL RUNING ACCOUNT>
setspn -A MSSQLSVC/<servername>:<dynamic port> <SQL RUNING ACCOUNT>
setspn -A MSOLAPSVC.3/<servername>.<domainname>:STAGE <SQL RUNING ACCOUNT>
setspn -A MSOLAPSVC.3/<servername>:STAGE <SQL RUNING ACCOUNT>
setspn -A MSSQLSVC/<servername>.<domainname>:1433 <SQL RUNING ACCOUNT>
setspn -A MSSQLSVC/<servername>:1433 <SQL RUNING ACCOUNT>
setspn -A MSOLAPSVC.3/<servername>.<domainname> <SQL RUNING ACCOUNT>
setspn -A MSOLAPSVC.3/<servername> <SQL RUNING ACCOUNT>
如何检查是不是设置成功:
if'KERBEROS'in(SELECTauth_schemeFROMsys.dm_exec_connections)
print'Kerberos is enabled'
else
print'Could not found any Kerberos connection'
--Kerberos is enabled, setup OK
--Could not found any Kerberos connection: Setup error
收藏
举报
TAG: