FIX: ????? ??? ??? ??????? ???? ???? ?????? ?? SQL Server ?????? ????????? ??? ?????? ???????? ?? SQL Server 2005 ?????? ????? ?????? Service Pack 1: "??? ????? ?????? ???????? 'LOGON AUTHORITY\ANONYMOUS NT'"

?????? ????????? ?????? ?????????
???? ???????: 925843 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50000288 (??????? ?????? SQL)
????? ???: 50000204 (??????? ?????? SQL)
?????? ??? ???? ?? ????????? ??? ????? ?? ??? ??????? ?? Microsoft SQL Server 2005 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
925001FIX: ????? ??? ??? ????? ????????? ??? ????? SQL Server 2005 ?????? ????????: "??? ????? ?????? ???????? 'LOGON AUTHORITY\ANONYMOUS NT'"

Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ????? ???? ????????? ???????
  • ??????? ??? ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ??????? ??????
  • ??????? ??? ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ??????? ??? ?? ??? ??? ??? ????? ??? ??????? ??????? ??? ????? ???? ??????? ??????
  • ??????? ??????? ?? ???? ????????? ???????

???????

?? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ? ????? ??????? ???? ???? ?????? ?? SQL Server ?????? ????????? ??? ?????? SQL Server 2005 ??????. ??? ?????? ????? ?? ???? ????? ????? ???????:
??? ????? ?????? ???????? 'LOGON AUTHORITY\ANONYMOUS NT'
???? ????? ????? ??? ??? ????? ???????? ?????????:
  • ????? ??????? ???????? TCP/IP.
  • ????? ?????? Kerberos ??????? ??? ????? ????????? ????????.
???? ???? ???? ???? ??????????? ?? ???? ????? ?? ????? ??? ????? ?????. ????? ??? ??????? ??? ??? ????? ????? ???? SQL ??????.

?????????
  • ?? ????? ????? ??????? FREESESSIONCACHE DBCC ??? ??? ???????.
  • ?????? ??? ??????? ??? ??????? ???????? ?? ????? ????? ???. ???? ??????? ?????? ??????? ?? ??? ??????? ?? ??? ??????? ??? ??? ??? ???? ??????? ?????? ????????? ??????? ???.

?????

???? ??? ??????? ???? ???? ????? ?? ???? "???? SQL Server ??????". ??? ????? ????? ???? ??????? Kerberos ??? ??? ??????? ??????? ??????? ??? ??????.

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2005. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ????? ????? ??? ??????? ??????.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

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

?? ??? ???? ????? ?????.

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
Microsoft SQL Server 2005 ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlncli.dll2005.90.2193.05,400,408?? ?????? ????12: 01IA-64
Sqlnclir.rll2005.90.1399.0205,016?? ?????? ??????: ????? ???? ???????
Sqlncli.dll2005.90.2193.02,223,448?? ?????? ????08: 31x 86
Sqlnclir.rll2005.90.1399.0205,528?? ?????? ????10: 48??? ???? ???????
Microsoft SQL Server 2005? x 64
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlncli.dll2005.90.2193.02,855,256?? ?????? ????19: 54x 64
Sqlnclir.rll2005.90.1399.0206,040?? ?????? ????21: 31??? ???? ???????
Sqlncli.dll2005.90.2193.02,223,448?? ?????? ????08: 31x 86
Sqlnclir.rll2005.90.1399.0205,528?? ?????? ????10: 48??? ???? ???????
Microsoft SQL Server 2005? x 86
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlncli.dll2005.90.2193.02,223,448?? ?????? ????08: 31x 86
Sqlnclir.rll2005.90.1399.0205,528?? ?????? ????10: 48??? ???? ???????

???? ??????

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

?????? ?? ??? ???????? ?? ??? ?????? ?????? Server1 ? ??? ?????? ????? ?? Server 2.
  1. ???? ?? ????? ?????????? ????? ??? ????? ????????.

    ?????? ?? ??? ??? ???????? ????? ??????? ??? ??? ??? ?????? ?????? ????? ?????? ?? ???? ??????? ??? ???? ????????? ?????? ???? ???? ?????? SQL Server:
    ?Snp:Server2 ?E Sqlcmd
    ??? ??? ??? ????? ???? ?? ??? ????? ???????? ????? ??? ??? ?? ?? ?? SQL Server ?????? ????????. ?????? ???????? ????? ?????? ????? ????? SQL Server.
  2. ?? ??? ???? ????? ?? ?????? 1 ?????? ???? ????? ???????:
    • ????? ????? ???? ????? ??????.
    • ????? ????? ???? ????? ???? ?????? ??? ????? ????????? ???????. ??? Server 1 ????? ???????? ??????? ?????? ???? ????? ?????? ???????? ????? ??????? Server2:
      EXEC sp_addlinkedserver @ ?????? = 'Server2' ?? @ srvproduct = '' @ ?????? = 'SQLNCLI' ? @ datasrc = 'np:Server2' ? @ provstr = ' "???? ??????" = SSPI '
  3. ??? Server 1 ???? Studio ????? ???? SQL ?? ?? ?????? ??????? ????.
  4. ?? ???? "?????????" ? ?? ?????? ????????? ???? ????? ?????? ????? Server2 ?????? ?? ??? ??? ??? ??????? ???????? ?????:
    ??? net_transport auth_scheme ?? Server2.master.sys.dm_exec_connections ??? session_id=@@spid
    ?? ???? ??????? ???????? ????? ? ???? ??????? ???????:
    net_transport		auth_scheme
    -------------		---------------
    Named pipe		NTLM

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???". ?? ????? ??? ??????? ???? ??? ?? SQL Server 2005 ?????? ????? ?????? SP2.

?????

????? ?? ????????? ??? ???? ??????? ???????? Microsoft SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 925843 - ????? ??? ??????: 23/????/1428 - ??????: 2.3
????? ???
  • Microsoft SQL Server 2005 Service Pack 1
????? ??????: 
kbmt kbautohotfix kbsql2005connect kbhotfixserver kbexpertiseadvanced kbqfe kbprb kbfix KB925843 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????925843

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

 

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