????? ??????? ????? ????? "????? ????? ???? SSPI"

?????? ????????? ?????? ?????????
???? ???????: 811889 - ??? ???????? ???? ????? ????? ??? ???????.
??? ??? ?? ????? "??????? ???????"? ????? ?? ??????? ??????? ???????? ???????? ????????? ?? ?????? ??? ??????? ??????? .
????? ???? | ?? ????

??? ???????

?? ??? ??????????? ??? ??????
assets folding start collapsed
???? ?? ??? ?????? ??????? ?????? ??? ????? ???? ????? ????? "????? ????? ???? SSPI" ?????? ??????? ?????. ?? ????? ????? ????? ??? ??? ????? ?????? ???????:
  • ??????? ? Microsoft SQL Server.
  • ??????? "?????? ????????".
  • ??? ??????? ?????? Kerberos ?????? ??????? ??????.
??? ????????? Kerberos ???? ?????? ???????
?????? ????? SQL Server ??? ??????? ???? ?????? ?????? ???????? ???????? ??? ?????? Windows ???? ???????? ??????? ????? ??? ??????? ?????? SQL Server. ????? ?????? ??? ?????? Windows ????????? ???? ?????? SQL Server. ?????? ????? SQL Server ?????? ??? ??????? ????? ??? ????? ??? ?????? ????? ????????? ?? ??????? ??? ??? ???????? ??? ????????? ???????:
  • NTLM ??? "??????? ??????? ???????" (?? ?????? "????? ???? ??? ??????" [SSPI])
  • NTLM ??? ???? ????? TCP/IP ???????? SSPI
  • ?????? Kerberos ??? ???? ????? TCP/IP ???????? SSPI
????? ???? ??? ?????? (SSPI) ?? ?????? ?? ?????? ????? ??????? Windows ???? ???? ??????? ?????? ???????? ??? ?? ???? ????? ???????? ??????? ??? ???? ??????? TCP/IP. ?????? ???? SSPI ????? ??????? ???? ????? ????? Windows ???? ??? ????? ??? ???? ?????? ?? ??????? ??? ??? ??? ?? ???? ????? ???? ???? ?? ?????? raw ???? ?? ????????.

??? ????? ????? "????? ????? ???? SSPI" ??? SSPI ?????? ?????? Kerberos ?????? ??? TCP/IP ??????? Kerberos ?? ???? ????? ???????? ??????? ?????? ??? ?????? ???????? ??? ????????? ?????? ???? ???? ?????? SQL Server ?????.
????? ?????? "????? ???? ??? ??????" ?????? NTLM ?? Kerberos
?????? ?????? Kerberos ???? ?????? "??? ?????? ???????" (SPN). ?? ???? ???????? SPN ?????? ???? ?????? ?? ?????? ??? ???? ?? ???? ????. ???? ?? SPN ????? ??? ????? SQL ?? ????? SMTP. ???? ???? ???? ?????? ?????? ?? ???? ??? ??? ??? ????????? ?????? ?? SPN ?????.

SPN ? SQL Server ????? ?? ??????? ???????:
  • ???????????: ???? ??? ?????? ??? ???? ?? ??????. ??? ?????? MSSQLSvc ? SQL Server.
  • ??????: ??? ?? ?????? ?????? ??????? ??? DNS ????????? ?????? SQL Server.
  • ??????: ??? ?? ??? ?????? ???? ??? ??????? ??????.
??? ???? ??????? SPN ?????? ????? ??????? ?????? SQL Server ??? ???:
MSSQLSvc/SQLSERVER1.northamerica.corp.mycompany.com:1433
????? SPN ????? ??????? ?????? SPN ??? ???? ???? ??? ??????. ??? ?????? ?? ???? SPN ??? ???? ???.

????? ?????? ?????? ????? SQL Server ??? ??????? ??? ??????? ?????? ???????? ??????? ? SQL Server? ?????? ????? ????????? ???????? ??? ?????? ????? ?? DNS ???? ???? ???? ????????? ???? ???? ?????? SQL ?????? ???????? ???? ??????? ?????? ????? ????????? WinSock. ?????? ??? ???????? ?????? ????? ????????? ???????? ???????? gethostbyname ? gethostbyaddr ?????? ????? ????????? WinSock. ??? ??? ??? ??? ????? ??? ?????? ?? ????? IP ??? ????????? ???? ???? ?????? SQL Server? ?????? ????? SQL Server ????? ?? DNS ???? ???? ???? ?? ???? ????????? ??? ??? ????????? ?????? ?????? ????????.

????? ???? ?????? ????? SQL Server ??? ?????? ?? DNS ???? ???? ???? ????????? ???? ?????? SQL Server? ??? ??????? DNS ??????? ?????? SPN ???? ?????????. ????? ?? ???? ??? ?????? ????? ?????? ??? ?????? ?? ????? IP ?? DNS ???? ???? ???? ?? ???? WinSock ?????? ????? SQL Server ?????? SPN ??? ???? ????? ????????? ???? ?????? SQL Server.

??? ???? ??????? ??? ???? SPNs ???? ???? ?? ???? ?????? ????? SQL Server ?????? ??? ??? ?? DNS ???? ???? ???? ??? ???:
  • MSSQLSvc/SQLSERVER1:1433
  • MSSQLSvc/123.123.123.123:1433
  • MSSQLSvc/SQLSERVER1.antartica.corp.mycompany.com:1433
  • MSSQLSvc/SQLSERVER1.dns.northamerica.corp.mycompany.com:1433
????? ???? ?????? SQL Server SPN ??? ????? ???? ???????? ??? ????? ????? SSPI ????? ?? SPN ?? ???? ?????? "Active Directory"? ??? ???? ??? SPN ?? ????. ??? ?? ??? ????? SSPI SPN? ?? ??? ????? ?????? Kerberos. ??? ??? ??????? ???? SSPI ???????? ??? ??? ?????? NTLM ?????? ?????? ???????? ?????? NTLM ????? ???? ???. ??? ??? ?????? ????? SQL Server SPN ???? ???? ?? ??? ?????? ??? ??????? ????????? ????? ??????? SPN? ??? ??. ???? ??? ????? ????? ???? "????? ????? ???? SSPI". ??? ??? ???? ??? ??????? SQL Server ???? ???? ????? ????? ??????? ?? ??? ?????????. ??? ???? ???? ????? ??????? ?? ???? ??? ??????? SQL Server. ???? ???? ?????? ???????? ??????? SPN ?????? ???? ???? ?????? ???? ?? ??? ???? ?? ????? Spn ??????? ???????? ??? ?????. ????? ???? ??? ????? ?? SPN ??? ????? ???? ???.

?? ?????? ??????? ???? ???? ?????? Kerberos ????? ????? DNS ???? ??? ???? ???????. ????? ?????? ?? ??? ??????? ??? ?????? ??????? ???????? ?????? ???????? Ping ???? ???????. ??? ??????? ??????? ????? ????? ?????? ?????? ??? ????? IP ?????? ???? ???? ?????? SQL Server (??? ???? ??? ????????? ???? ?????? SQL Server ?? SQLServer1):
ping sqlserver1
?????? ?? ??? ??? ??? ?????? ???????? Ping DNS SQLServer1 ???? ???? ????? ?????? ????? ??????:
????? ????? ping-a ????? Ip
??? ???? ??????:
C:\>ping SQLSERVER1

Pinging SQLSERVER1 [123.123.123.123] with 32 bytes of data:
	
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
	
Ping statistics for 123.123.123.123:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum =  0ms, Average =  0ms
C:\>ping -a 123.123.123.123
	
Pinging SQLSERVER1.northamerica.corp.mycompany.com [123.123.123.123] with 32 bytes of data:
	
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Reply from 123.123.123.123: bytes=32 time<10ms TTL=128
Ping statistics for 123.123.123.123:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum =  0ms, Average =  0ms

C:\>
??? ????? ????? ????? ping-a ????? Ip ???? ?????? DNS ???? ???? ???? ????????? ???? ?????? SQL Server? ?????? ???? ???? ?????.
????? ??? ?????? ??????? ?? SQL Server
??? ??? ??????? ?????? ?? ?????? Kerberos ???????? SQL Server. ?? SQL Server? ????? ????? ???? SQL Server ??? ??? ????????? ???????: ???? ?????? ???? ?? ???? ?????? ???? ?? ???? ?????? ????. ??? ??? ????? ???? ???? SQL Server? ???? ????? ????? SPN ?????? ?? ?? "Active Directory" ???????? ??????? ??????????????? API. ?? ???? ??? ???? ?????????? ??? ??????? ?????? ????? ?? "???? ???????":

??????: MSSQLServer EventID: 19011 ?????: ??????? SuperSocket: (???????????): ??? 8344.

????? ?? ????????? ???? ?? ????????? ??? ???? ??????????????? ? ????? ??? ???? Microsoft ?????? ??? ???:
http://msdn2.microsoft.com/en-us/library/ms676056.aspx
??? ????
??? ??? ?????? ???? SQL Server ??? ???? ?????? ??????? ??? ???????? ????? SPN ??????? ?? ?????? Kerberos ????? ?? ????????? ???? ?????? SQL Server. ??? ???? ??? ??? ?????? ???? SQL Server ??? ???? ???? ?? ??? ???? ????? ??? ???? ?????? ????? SPN ?? ???? ??????? ???? ??? ???? ???? ?????? ??????? ?????? ???? ?? ????? ????? Spn ?????? ???. ?? ???? ??? ???? ????? SPN? ??? ???? ??? ?? ????? ?? SPN ??? ????????? ???? ?????? SQL Server. ??? ??? ??????? ???????? ???? ????? ???? ????? ???? SQL Server? ??? ????? SPN ????? ??? ?????? ?????? ????? ?????? ???? ??? ?? ???? ???? ?????? SPN ??????.

??? ???? ?? ?? ?????? ???? ????? ???? ?????? ???? SQL Server (???? ??????? ???????)? ?? ???? ????? ???? ????????? ???? ?????? SQL Server SPN ?????? ??. ????? ??? ????? SPN ?????? ????? ????????? ???? ???? ?????? SQL Server ??? ??? ???? ??????? ?????? Kerberos ??? ??????? ????? ??????? ?????? SQL Server. ???? ??? ?????? ??? ??? ?????? SQL Server ??? ???? ?????? ???? ?? ??? ???? ?????? ????. ??? ????? SPN ?????? ????? ?????? ????? SQL Server ??? ??? ????????? ????????. ?? ???? ????? SPN ??? ????? ????????? ?? ?? ???? ????? ???? ????????? ???? ?????? SQL Server ???????? ???? ?????? ??????. ??? ?? ???? ???? SPN ???? ???? ???? ????? ??? ????? ????????. ???? ???? ??? ?? ???? ???? SQL Server ???????? ???? ??? ?? ????? ???? ????????? ???????? ???? ?????? ??????.
?? ??? ??????????? ??? ??????
assets folding end collapsed

?? ?????

?? ??? ??????????? ??? ??????
assets folding start collapsed
???? ??? ????? ??????? ?????? ?? ?? ???? ????????? ????? ?? ?? ????? ?? ????? SSPI.

???? ?? ??????
???? ?? ?? ?????? ???? ???? ?????? ??? ??????? ?? ?????? ???? ????? ???? ????????? ???? ?????? SQL Server. ??? ?? ???? ???? ???? ????? ????? ?????? ?? ??????.
  1. ??? ?????? ?? ??? ???? ????? ????? ?????? ??? Windows ???????? ??? ???? ?????? ????? ?????? ????? ??? ????? ???? SQL Server. ??? ???? ??????? ?? ???? ????? SSPI ?? ???? ??????? ???????:
    • ?? ????? ???? ????.
    • ?? ????? ???? ?????? ??????. ??? ???? ????? ??? ????? ????? ???? SQL Server ??? ????? ???? ??????.
  2. ??? ????? ?????? ????? ?????? ????? ?? ?? ?????? ????? ?????????? ???? ???? ?????? SQL Server? ?????? ?? ????? ????? ??? ????????.
  3. ???? ?? ?? ??? ??? ?????? ???? ????? ???? ?????? ????? ?????? ???? ??????? ??????? ?? ??? ??????. ??? ????? ? SSPI ?????.
  4. ??????? ?????? ????? ??????? ?????? ?? ??????? Active Directory ?????? ????????? ??? ??? ????? SQL Server.

    ?????? '???? ????? ?? ???????' ?? ????? ??? ????? ??? ????? ?????? ???????? ?? ???? SQL ????? ??? ???? SQL ???? ??? ?? ??????? ???? ?????? ??? ????? ??????????? (???? ????? ???????????) ???? ?????? ?????? Windows.
  5. ??????? ????? ?????? ??????? "??????? ??" ?????? ???????? ???????? (SetSPN.exe) ?? Windows 2000 Resource Kit. ?????? ????? ???? Windows 2000 ?? Windows Server 2003 ?????? ????? ?????? ???? ??????? ?????? ???????? ?????? ?? SPN ???? ?? ??????? ??? ???? ?????. ? SQL Server? ??? ?? ???? ???? SPN ???? ???. ??? ????? SPN ??? ????? ???????? ????? ???? SQL Server ??????? ?? ???? ??????? ????? ????????? ??? ??? ????? SQL Server ???????? ???? ?????? ??????. ??? ??? ?????? SQL Server ????? ????? ?????? ???????? ???? ?????? ??????? ??? ????? SPN ????????. ??? ???? ??? ??? ?????? ???? ???? ???? ????? SQL Server? ?? ????? ???? ?????? ?????? ???? ??? ???????? ???? ????? SQL Server? ??? ????? SetSPN.exe ?????? ??? ?????? ????? Spn? ???? ???? ????? SPN ????. ????? ?? ?????????? ???? ??????? "????? ???? ??????" ?? ??? SQL Server 2000. ?????? ????? ????? ??? ???? Microsoft ?????? ??? ???:
    .aspx http://msdn2.microsoft.com/en-us/library/aa905162 (SQL.80)
    ????? ?? ????????? ??? ????? ????? Windows 2000? ????? ??? ???? Microsoft ?????? ??? ???:
    http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/default.mspx?mfr=true
  6. ???? ?? ?? ??? ???? ????? ????? ???? ????. ?? ????? ?????? DNS? ????? ????? WINS? ????? Hosts? ?????? Lmhosts. ????? ?? ????????? ??? ????? ?? ????? ????? ? ??????? ??????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    169790????? ??????? ????? TCP/IP ??????? ?????
  7. ????? ?? ????????? ??? ????? ??????? ????? ?????? ? ????? ???? ??????? ?? "Active Directory"? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    291382??????? ????????? ??? Windows 2000 DNS ? Windows Server 2003 DNS
    224196 ????? ???? ???? ????? ???????? ? Active Directory ????? ???? RPC ?????? ??? ???? ????
????? ???? SQL Server ?????? ????? Spn ???? ???? ??????? SQL Server
?????? ???? SQL Server ?????? ????? Spn ???? ????? ??? ????? ??????? ?????? ??????? ?????? ?? ???? ?????? "Active Directory". ??? ??? ????? "????? servicePrincipalName" ???? "??????? servicePrincipalName" ????? ???? SQL Server.

????? ??? ??? ?????? ?????? ???????? ?????? ?????? ???? ???? Active (ADSI) ?? ?????? ???????? LDP ?? ?? ????? LDAP 3 ??????? ???? ?????? ?????? ?????? ??????? Active Directory ???? ??? ????? ???? ?? ???? ????? ?????. ?? ????? ??? ???????? ????? ????? Windows Server 2003 ????? ??????? Microsoft Windows 2000 Server? Microsoft Exchange Server 2003 Microsoft Exchange 2000 Server? ?? ?? ?? Windows ??????. ?? ???? ?? ????? ?? ?? ???????? ???? ???? ?? ???? ????? ?????? ?????? ??????? Active Directory ???? ??? ????. ????? ??? ?????? ??? ???????? ???????.

?????? ???? ???????? ???????? ????? ???????? ????? ??? ??????? SQL Server? ??? ????? ?????? ?????? ????? ?? ????? ?? ???? ?? ????? ?????? ???? ?????? ???? ??????.

?????? ???? SQL Server ?????? ????? Spn ???? ????? ???? ??????? ???????:
  1. ???? ??? ??? ?????? ???? ??? ?????? ??? Adsiedit.msc? ?? ???? ??? ?????.
  2. ?? ADSI Edit ?????? ????????? ?? ?????? [??????? ??????]? ?? ?????? DC = ???????????? ?? ?????? CN = Users? ???? ????? ?????? CN = ??? ??????? ?? ???? ??? ?????.

    ???????
    • ??? ?????? ????? ????? ???? ??????.
    • ??????????? ????? ????? ???? ???? ???.
    • ??? ?????? ?? ???? ???? ?????? ???? ????? ???? ????? ???? SQL Server.
    • ??? ??? ?????? ???? "?????? ??????" ???? ????? ???? SQL Server? ??? ?????? ?? ???? ???? ?????? ???? ??????? ?????? ?????? ??? Microsoft Windows.
    • ??? ??? ?????? ???? ?????? ???? ???? ????? ???? SQL Server? ??? ?????? ???? ???? ????? ?????? ??????.
  3. ?? CN = ??? ?????? ????? ???? ??????? ???? ??? ???? ?? ????? ???????.
  4. ??? ???? ? ???? ??? ?????.
  5. ?? ??????? ?????? ???????? ????? ???? ?? ?? ???? ????? ??? ??????? ????????.

    If ???? ?? ??? ????? ???? ??? ?????? ?? ?? ?????? ????.
  6. ??? ??????? ????????? ???? ??? ????? ?? ???? ??? ?????.
  7. ?? ????? ????? ???? ??????? ???? ??? ????? ?? ????? ???????.
  8. ??? ????? ? ???? ??? ??? ?????? ??? ?? ????? ??? ?????? ??? ?? ???? ?? ?? ??? ????? ????? ???????? ???????? ??????? ??? ??????:
    • ServicePrincipalName ???????
    • ????? servicePrincipalName
  9. ???? ??? ????? ???? ????? ??? ??????? ADSI Edit ?????? ????????.
?????? ??? ??????? ???? ???????? ???? ???? ?????? Active Directory? ???? ????? ????? ??????? ? Microsoft.

??? ???? ??? ?? ??? ???? ????????????????????????? ?????? ??? ???? ???? SQL ??? ????? ?????? ???????:
  • ???? ????? ???? ???? ??????.
  • ???? ??????? ???????? SQL Server.
?? ??? ?????????? ?? ??? ??? SPN ? SQL Server ???? ??? ?????? ?? ????? ???????? Active Directory. ?? ????? ??? ?? ????? ??????? ????? SQL Server.

????? ?? ???? ?? ???:
  • ???? ????? SQL ??????? ?????????? ?? ??????: ?????? A ? b ????.
  • ?????? ?????? A ?????? ???? ???? ?????? A ? B ???? ?????? ?????? ???? ?????? ??????? b.


?? ???? ?? ???:
  1. ???? ?????????? ????? ??? ?????? A ?????? SPN SQL ?? ???? ???? ?????? A ????? ??? ??????? ???..
  2. ???? ?????????? ????? ????? ??? ?????? B ??? ?????? A ????? ??????? ????.
  3. ???? ?????????? ????? ????? SPN ?????? ?? ?? ???? ???? ?????? A ????? ????? ????? ??????? ??? ???? a.
  4. ??? ????? SPN ?? ???? ???? ?????? A ???? ??????? ??? ?? ?????? ??? ??? ???? ?????? ??????? b.
  5. ??? ??? ????? ??? ?????? B? ????? ???? ?????????? ????? SQL SPN ?? ???? ?????? ??????? b. ??? ??? ?????? SPN ?????? "? ????" ?? ???? ?????? SPN.
  6. ??? ???? ??? ?????? ???? ???? ?????? A ?????? ??? SPN (?? ?????? 3) ????? ?????? ??????? B ???? ?? ????? ???????? "?????? ?????". ??????? ???????? ?? ?? SPN ???? ?? ???? ????? SQL ?? ?????? ??? ?? ????? ???? ?????? ??????? ????? ??????????.

?????? ?? ????? ??? ??????? ?? SQL Server 2012.
???? ?? ?????? ??????
?????? ?? ??? ????????? ???????? ??? ????????? ??? ??? ???? SQL ?????:
  1. ?? ??? ??? ?????? Kerberos ??? ????? ????????? ???????? ??? ???? ??????? Windows 2000 ???? ???? Windows Clustering ??? ??? ??? ?????? Service Pack 3 (?? ????? ????) ????? ??????? Windows 2000. ???? ?? ???? ?? ?????? ???????? ?????? SSPI ??? ???? ?????? ???????? ?? SQL Server. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    235529??? ?????? Kerberos ??? ??? ?????? ???? ????? ??? ???? ??????? Windows 2000
  2. ???? ?? ?? ?????? ??? ??????? ?? Windows 2000 Service Pack 1 (SP1). ?? ??? ???? ?? ????????? ??? ??? ?????? Kerberos ??? ??????? ???? ????? ??? ???? ??????? Windows 2000? ???? ??? ??? ??????? ?????? ?????? ?? ???? ????? Microsoft ?????:
    267588??? ??? ????? ????? "????? ????? ???? SSPI" ??? ??????? ? SQL Server 2000
  3. ??? ???? ??????? ??? ??? ?????? ???? ??????? ???? ????? SQL Server ?? SQL Server ???? ??? ?? ???? ????? ?????????? ??? ???? ???? ?????? ???? ??????? ??????? ?? ????? "????? ??????? ? Microsoft" ???????:
    239885 ????? ????? ?????? ?????? ????? ??????? ???? ???? ?????? SQL Server
  4. ???? ?? ?? ?????? ???? ??????? ???? ????? SQL Server ???? ???????? ????????. ??? ??? ?????? ???? ??? ???? ?? ?????? "????????? ????????"? ???? ??????? "????? ????? Windows ????? ??????" ?? "??? SQL Server" ?????? ??? ????? ????? ?? ???????? ???? ??? ?? ???? ??? ??????:
    .aspx http://msdn2.microsoft.com/en-us/library/aa176564 (SQL.80)
???? ?? ???? ??????
???? ?? ?????? ??? ??????:
  1. ???? ?? ?? ???? ??? ?????? NTLM ???? ???? ???? ????? ??? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? ???? ????? Microsoft ?????:
    269541???? ????? ??? ??? ??????? ? SQL Server ???? ????? ????? ??????? ???? ??? ?????? ? Windows NT LM: "????? ????? ???? SSPI"
  2. ????? ?? ??? ??? ?????? ????? ???????? ??????? ??????. ??? ?? ????? ?????? ??? ?????? ???????? ?????? ???????? ??????? ??????? ????? ?????? ?? ????????? ??? ?? ????? ?????? ??? ??????? ????? ???? ???? ???? ??????? ?????? ???????? ??????? ??????. ????? ?? ????????? ??? ????? ????? ?? ??? ??? ?????? ????? ???????? ??????? ??????? ???? ??? ??????? ??????? ??? ???? ??????? ?? "????? ??????? ? Microsoft":
    242536??? ?????? ????????? ??? ????? ?????? ??? ?????? ?????? ???????? ??????? ??????
  3. ?????? ?? ?????? ???????? ??? ?????? ???????. ??? ???? ???????? ??????? ????? ??????? ?? ????? ??? ?????.
  4. SSPI ?????? ??? ???? Security.dll. ??? ??? ?? ????? ??? ???? ?????? ??? ?????? ??? ?????? ?? ??? ??????? ??? ??? ????? ?? ??? SSPI ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? Microsoft ????? ???????:
    253577???: 80004005-?? ???? ????? ?????? ????? ODBC MS SQL Server ???? SSPI
  5. ??? ??? ???? ??????? ??????? ??? ?????? Microsoft Windows 98? ??? ????? ?????? ?????? ????? Microsoft ??? ????????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? ???? ????? Microsoft ?????:
    267550?????: "??? ?? ???????" ??? ??????? SQL server ??? TCP/IP
???? ?? ?????? ???????? ???? ??????
??? ????? ?????? ???? ?????? ???????? (CNU) ?? Microsoft Data Access Components (MDAC) ???? ???????? ?????? ??????? ?????? ????????? ???? ?????? SQL Server. ????? ??????? ?????? ???????? MDAC Cliconfg.exe CNU ?????? ???????:
  1. ??? ??? ??????? ???????????? ??????? ????? ????? ??????? ????? MDAC. ?? ????????? ?????? ?? MDAC? ????? ????? ???????? "???????". ?? ????????? ?????? ?? MDAC? ???? ????? ???????? ???? ?? ???? ?? ???? ?? ???? ??????? ??? ??????? ??? SQL Server. ??? SSPI ????? ??? ??? TCP/IP? ????? ??????? ????? ????????? ??? "??????? ??????? ???????"? ????? ?????.
  2. ???? ?? ????? ???????? ????? ????? ?? CNU ?????? ?? ?? ??? ????? ????? ?????? ?????? ???? ????? ???????. ??? ?? ????? ??? ?????? ????? ???? ?? ????????? ?????? ????? ??? ????????? ??????? ? SQL Server. ????? ?????? ?? ??? ?? ???? ??? ???? ????? ???????? ?????? ?? ??? ??? ????? ??????.
  3. ??? ?? ??? ????? ????? ???????? ?????? ??? CNU? ?? ?????? ????? ???????? ?????? ???? ??? ??????? ??. ??? ????? ??? ??????, ??? ???? ????? ????? ?????????? ?????????? ????? ????? IP ???????.
????? ??? ?????? ??????? ? SQL Server ??????
????? ?? ????????? ??? ????? ????? ??? ?????? ??????? ? SQL Server ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
319723????? ??????? ?????? Kerberos ?? SQL Server
????? ???? ??? ?????? (SSPI) ?? ??????? ????? ??????? Microsoft Windows NT ?????? ???? ??? ????????? ??????? Kerberos? ????? ???? ???????? ???? ??? ?????? NTLM. ???? ?????? ??? ????? ???? ??????? ??? ????? ?????? ??? ???? Windows. ?????? Kerberos ????? ??? ??? ???? ??????? Windows 2000 ????? ????????? ???? ????? ??? ????? ?????? Kerberos ????? ?????? "???? active Directory".

SSPI ?????? ??? ???????? TCP/IP ???? ??? ??????? ???????? ?????? Windows. ?????? Windows ???? ???? ??????? ????? ??? ?? ?????? ????????. ?? ??? ??????? SSPI "??????? ??????? ???????" ?? ??????? ????? ????????????. ????? ????? ???? ??????? ?? ???? ????? ??????? ??????? ?? ???? ???????? ???? TCP/IP.

??? SQL ????? ???? ?????? ???????? ?????? ???????? ??? ???? ????? TCP/IP ???????? ???? ????????? ???? ???? ?????? SQL Server? ?????? ????? ???? ????? ???? SQL Server API SSPI ?????? ??????? ??????. ???? ???? ????? ???? SQL (Dbnetlib.dll) ?????? ?????? ??????????????????????? ??????? ?? "???????" ??????? ????????? . ??? ?????? ???? ?????? ???????? ?????? ??????? ???????. ?? ??? ??????? ????? ???? ??? ?????? ??????? ?????? NTLM ?? Kerberos ??? ????? ????????? ???????? ??? Windows. ????? ???? ?????? Windows ????? Kerberos ??? ??? ??? ????????? ?????? ???? ???? ?????? SQL Server SPN ???????? ??????? ???? ????. ????? ?????? Windows NTLM ???????.

?????? ???? ?? ?? ??? ?? ?????? ???? ???? "????" ???? ????? ?? ?? ????? SQL Server (MSSQLServer? SQLServerAgent? MSSearch). ????? ?????? ???????? ?????? ?? ???? ??????? ?? ???? ????? ????? (KDC).
?? ??? ??????????? ??? ??????
assets folding end collapsed

??? ??????? ???? ???? ??? ??????? ?? Microsoft (CSS)

?? ??? ??????????? ??? ??????
assets folding start collapsed
??? ???? ?????? ??? ??? ??????? ???????? ????? ??????? ??????? ???????? ?? ??? ???????? ??? ????????? ??????? ???? ???? ??? ??????? ?? Microsoft (CSS).

?????? ??? ????? ????? ?? ??? ??????? ?? Microsoft ????? ??????? ???????? ??? ?????? ?????? ????? ??? ???? Microsoft ?????? ??? ???:
http://support.microsoft.com/contactus/?ws=support
  1. ????? ????? sqldiag ?? SQL Server. ????? ?? ????????? ?????? ??? ?????????? ???? ??????? "sqldiag ??????? ????????" ?? SQL Server ??? ??? ????????.
  2. ?????? ???? ???? ????? ??? ??????.
  3. ???? ???? ??????? ??? ?????? ???? ?? ???? ??????? ? SQL Server? ?? ???? ????? ??????:
    net start > started.txt
    ???? ??? ????? ?????? ??? ???? Started.txt ?? ?????? ??? ???? ?????? ?????.
  4. ??? ??? ????? ??????? ??? ????? ??????? ?????? ??? ???? ????????? ??????:
    HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\CLIENT\CONNECTTO
  5. ?? ???? ???????? ???? ?? ???? ????? ??????? ?????? ??? ???? ???? ????????:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\LSA\LMCompatibilityLevel
  6. ?? ???? ???????? ???? ?? ??? ??? ????? ??????? ?????? ??????? ??? ?? ???? ????:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTLMSsp
  7. ?????? ??????? ??? ??? ???????? ????? SQL ???????? ??? ?????? ????? (UNC) ??????? (?? ??? ?????? SQL ??? ????) ?? ??????.
  8. ?????? ??????? ??? ??? ????? ????? ????? ping ??? ????????? (?? ??? ?????? SQL ??? ????) ?? ??????.
  9. ??? ??? ?????? ???????? ???? ????? ????????? ???? ?? ?? ????? SQL Server (MSSQLServer? SQLServerAgent? MSSearch).
  10. ??? ?????? ????? ?? ??? ??? ??? ????? SQL Server ??????? ?????? ?? ?????? Windows ???.
  11. ????? ?? ??? ??? ????? ??????? ?????????? ???? ?????? SQL Server ?? ??? ?????? ???????? ?????? ???? SQL.
  12. ????? ?? ??? ??? ????? ??????? ???????? ???????? "??????? ??????? ???????".

?????

????? ?? ????????? ??? Kerberos SSPI ????????? ???? ??????? ???? ??? ??? ??????? ?????? ?????? ?? ????? ??????? ? Microsoft:
266080?????? ??????? ????????? ?? ?????? Kerberos
231789 ????? ????? ?????? ?????? ????? ??????? Windows 2000
304161 ??? ??????? ??? SSPI ???????? ????????? ?? ???? ?????? ???? ??? ??? ???? ??????
232179 ????? Kerberos ?? ???? ??????? Windows 2000
230476 ??? ??????? ???????? Kerberos ??????? ?? ???? ??????? Windows 2000
262177 ????? ????? ????? ??????? Kerberos
277658 ??? Setspn ??? ??? ??? ?????? ????? ?? ??? NetBIOS ??? ??? ????? SPN ???? SQL
244474 ????? ??? Kerberos ???????? TCP ????? ?? UDP ?? Windows Server 2003 ?? ???? ??????? Windows XP ??? Windows 2000
326985 ????? ??????? ???????? ???????? Kerberos ?? IIS
???? ????? ???? ??? ???? Microsoft SQL Server 2000? ????? ??? ???? Microsoft ?????? ??? ???:
http://technet.microsoft.com/en-us/cc984178.aspx
?? ??? ??????????? ??? ??????
assets folding end collapsed

???????

???? ???????: 811889 - ????? ??? ??????: 24/????? ??????/1434 - ??????: 4.0
????? ???
  • 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
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Integration Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
????? ??????: 
kbsqlsetup kbhowtomaster kbhowto kbsmbportal kbmt KB811889 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????811889

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

 

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