????? ?????? ?? ??? ?????? ?????? Kerberos ??? ????? ????? ???? ??? ???? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 909801 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

???? ??? ??????? ????? ?????? ?? ??? ?????? ?????? Kerberos ?????? ?????? Microsoft Windows ??? ????? ????? ???? ??? ???? Microsoft SQL Server 2005.

??????? ????

???? SQL Server 2005 ?????? Kerberos ???? ??? ????? ??? Windows ?????? ??? ???? ????? (SSPI) ??? ??????? ?????? Windows ????????? ????? ?? ?????? SQL. ??? ???? SQL Server ???? ??????? ?????? Kerberos ??? ???? ????? ??? ??? ???? ??????? SQL Server SSPI ??????? ?? ???????? ?????? ????????. ??? ??? ?? ???? ??????? SQL Server Kerberos ???? ??????? ?????? Windows NTLM ????????. ?????? ??????? ?? ???????? ??????? ?????? Kerberos ????? ?? ?????? NTLM. ??? ?? ???? ????????? ??????????? ????? ?????? ?? ?? ??????? ?????? Kerberos ????????? ???????.

???????? ?????? Kerberos ? ???? ?????? ?? ?? ????? ???? ?????? ???????:
  • ??? ?? ???? ?? ?? ?????? ? ????? ??????? ??????? ??????? ?? ???? Windows ??? ?? ????? ??????? ????? ???.
  • ??? ?? ??? ????? ?????? ??? ???? ????? (SPN) ?? ???? ?????? "Active Directory".
  • ??? ????? ???? SQL Server 2005 TCP/IP ??????????.
  • ??? ??? ?????? ??????? ????? SQL Server 2005 ???????? ???????? TCP/IP. ??? ???? ??????? ????? ??? ???????? TCP/IP ?? ???? ????? ???????????? ??????. ?? ????? ????? ??????? "tcp:" ?? ????? ??????? ?????? ??????? ??????? ???????? TCP/IP.

????? ????? SPN ?? ????

???? ????? SPN ?????? ??? ???? SQL Server ???? ????? ????? ????? ??? SPN ??? Windows ???? ??? ????? ???? ???? ??????.

??? ???? ??????? ?? SPN ??? ?????? ??? ?? ?????? SPN ????? ??????? ???? ??????. ????? ?? SPN ???????? ???? TCP/IP ???? ????????? ??????. ??? ??? ?? ?????? SPN ?? ???? ????? SSPI ?????? ??????? SPN. ????? ?? ??? ??????? ?????? Kerberos.

??? ????? SQL Server ??? ???? ?????? ?????? ?? ??? ???? ????? ???? ?????? ???????? ????? SPN ?? ??????? ?????? ??? ??? ????? ??????:
MSSQLSvc / FQDN: tcpport
??????FQDN ?? ??? ?????? ?????? ??????? ?? ??????. tcpport ?? ??? ?????? TCP/IP.

???? ??? ????? ??? ???? TCP ?? SPN ? ??? ????? SQL Server ???????? TCP/IP ???????? ??????? ?? ???? ??????? ?????? Kerberos. ????? ??? ??????? ??????? ?????? ????????. ???????? ??? ???? ??? ?????? ????? SPN ???????? ??? ??? ????? ?????? ??? SPN ???? ????? ????? ???????? ????? ????? ??????.

???? ?????? ?????? ?? ???? ????? ???? ??? ??? ???????? ???????? ?????? SPN. ????? ??? ??? ??? ????? ???? SQL Server ??? ???? ??? ?????, ?? ???? ????? ???? SQL SPN ??????. ??? ?? ???? ??? ?????? ?????? ?? ??? ???????. ??? ????? ?? ???? ???? ????? ??????? ??????? ?? ??? "???????" ??? ????? Windows:

??? ?????: ???????
???? ?????: MSSQL $ InstanceName
??? ?????: (2)
????? ?????: 26037
???????: Date
?????: Time
????????: N/A
???? ?????????: ComputerName
?????:
???? ????? ????? ????? ?????? SQL ?? ?????? ??????? ??? (SPN) ?????? ??? ???? SQL Server. ???: 0x54b. ?? ???? ????? ?? ????? SPN ???????? ????????? ??? ?????? ??? NTLM ????? ?? Kerberos. ??? ????? ???????. ?? ????? ??? ??? ??? ??? ???????? ??????? ?? ??? ???? ?????? Kerberos.
????? ?? ?????????? ???? "????????? ??????" ?? http://support.microsoft.com.

??? ?? ????? ??? ??????? ??? ????? SPN ????? ??? ???? ????? ???? ??????? ?????? Kerberos? ??????. ?????? ?? SPN ???? ??????? ???? SetSPN.exe ??????? ?? ????? ????? Microsoft Windows 2000 Server. ??? ?????? ??? ????? ????? ?? ????? ??? Microsoft Windows Server 2003. ??? ????? ????? ????? ????? ?? Windows Server 2003 ?? Microsoft Windows Server 2003 Service Pack 1 (SP1).

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? Windows Server 2003 Service Pack 1 ????? ????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
892777????? ??? Windows Server 2003 Service Pack 1
????? ??????? ??? ?????? ??? ??? ?????? SPN ?????:
?A SetSPN MSSQLSvc/<computername>. <domainname>: 1433 <accountname>
?????? ??? SPN ??????, ??? ???? ??? ?? SPN ??? ????? ????. ?? ???? ??? ?????? ???? ??? ?? ????? ????? ??????. ??? SPN ??????, ????? ??????? ???? SetSPN.exe ?? ????? ??????? - D.

????? ?????? ?? ??????? ?????? Kerberos

??? ??????? ????? ?? SQL Server 2005 ????? ??????? SQL ???????? ??????? ?? SQL Server ????? Studio:
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
??? SQL Server ?????? ?????? Kerberos ????? ???? ??? ??? ??? ???? "KERBEROS" ?? ???? auth_scheme ?? ???? ???????.

?????

????? ?? ?????????? ???? ???????? ??????? ?? Microsoft SQL Server 2005 ????????:
  • ????? ??? ?????? ???????
  • ????? ????? ?????? Kerberos ??? ?? ??? SQL Server ??? ?????? ?????? ??? ??????

???????

???? ???????: 909801 - ????? ??? ??????: 09/?????/1427 - ??????: 2.3
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
????? ??????: 
kbmt kbsql2005connect kbinfo KB909801 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????909801

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com