????? ????? ????? ????? SQL Server 2008 ? SQL Server 2005 Analysis Services ??????? ?????? Kerberos

?????? ????????? ?????? ?????????
???? ???????: 917409 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ????? ????? ??? ??????? ???? ???? ????? ????? Microsoft SQL Server 2008 ?? Microsoft SQL Server 2005 Analysis Services ??? ????? ????? ??????? ?????? ??????? ?????? ??? ???? ??????? Kerberos ????????? ????????. ??? ???? ??????? ?? ??????? ?????? ??????? ?????? ???? ????????? ?? ????? ?????? ?????? ????? ?????? ??? ??????? ???? ???? ?????? Microsoft ????? ??????? ?????? (IIS). ?? ??? ?? ????????? ???? ???? ?????? IIS ????? ?????? ?????? ????? ?????? ??? ???? "????? ???????". ??????? ???? ??? ????? ????? ?? ??????? ? SQL Server 2000 ??????? ?????.

????? ???

???? ??? ??????? ????? ????? ????? ????? SQL Server 2008 ? SQL Server 2005 ????? ??????? ???????? ?????? Kerberos.

??????? ????

????? ???? "????? ???????" ???????? ???????? ?????? Kerberos

????? ??? ???? ????? (SPN) ?????? ??????? ???? ??? ???? "????? ???????". ??? ???? ?????? "????? ???????" ??? ??????? ??? ???? ???? ???? ?????? ?????? ?? SQL Server 2000? ??? ????? SPN ????????. ??? ???? ??? ???? ????? SPN ?? SQL Server 2008 ??? SQL Server 2005 ??? ????? SPN ?? SQL Server 2000 ??? ????? ???? ????? ??????? ??? ???? ?????? ????? ????? ???? ?????? ??????. ?????? SPN? ?????? Setspn.exe ?????? ???????? ?? Microsoft Windows 2000 Resource Kit. ??? ??? ????? ??? ?????? ?? ????? ??? Windows Server 2003. ????? ??? Windows Server 2003 ??? ????? ?? ???? ?????? Windows Server 2003 service Pack 1 (SP1).

?????? ?????? ???????? Setspn ?? Windows 2000 Resource Kit? ????? ???? Microsoft ??? ?????:
http://www.microsoft.com/downloads/details.aspx?FamilyID=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&DisplayLang=en
????? ?? ????????? ??? ????? ????? ?????? Setspn.exe ? Windows Server 2003? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
970536????? ???? ??? Setspn.exe Windows Server 2003
??? ????? ?????? ???????? Setspn? ???? ??? ???????.

?????? ??? ?? ???? ???? ?????? "?????? ??????" ?????? ????? Setspn . ??? ???? ??????? ???????? ???? "????? ???????"? ?????? ??? ??????? "????? ???????" ???? ?????? ?????? ??????? (FQDN).
  1. ?????? SPN ?????? "????? ???????" ???? ??? ????? ??? ???? ????? ????? ??????? ??????? ?? ???? ???????:
    • MSOLAPSvc.3/-S Setspn.exeFully_Qualified_domainName OLAP_Service_Startup_Account

      ?????? Fully_Qualified_domainName ???? ???? ? FQDN.
    • MSOLAPSvc.3/-S Setspn.exe?????????????? OLAP_Service_Startup_Account
  2. ??? ??? ??? ???? ????? SPN ?????? "????? ???????" ???? ??? ?????? LocalSystem? ?? ?????? ??????? ??????? ?? ???? ???????:
    • MSOLAPSvc.3/-S Setspn.exeFully_Qualified_domainName ??????????????
    • MSOLAPSvc.3/-S Setspn.exe?????????????? ??????????????
  3. ?????? ?? ?? ??? ??? ?? ?? ????? SPN ??????? ????? ??????? ????? ??????? ??????? ?? ???? ???????.
    Setspn.exe -L OLAP_Service_Startup_Account 
    Setspn.exe -L serverHostName
    ??? ?? ????? ????? SPN ????? Analysis Services? ???? ?? ???? ????? ??? ????? ???????? ??????.
    MSOLAPSvc.3/serverHostName.Fully_Qualified_domainName 
    MSOLAPSvc.3/serverHostName
?????? ???? ?? ???? SQL Server 2005 Analysis Services ????? ????. ?? ??? ??? ??? ?? ????? ????? SQL Server 2000. ??? ??? ?????? ???? ????? ??? ????? ??? ???????. ??? ???? ??? ???? ????? ??????? SPN ???????. ???? ?? ???? SQL Server? ?? ????? ????? ???? ??? ????????. ??? ??????? ??? ?????? ?????? ????? ??????? ????? ???? ????.
MSOLAPSvc.3/serverHostName.Fully_Qualified_domainName:instanceName
MSOLAPSvc.3/serverHostName:instanceName

????? ??????? "???? active Directory"

???? ?? ?? ???? ?????? ??????? ?????? ??????? ???? ?????? ?????? ?????:
  • ????? ?????? ???? ?? ???? ?? ???? ????? ?? ??? ????? ??????? ??????? ?????????? ???? ???? ?????.
  • ????? ??? ?????? ????? ??????? ??? ????? ??????? ????? ?????? ?????? ???????? ???? ??? ??????? "????? ???????". ??? ???? ??????? ??? ??? IIS ??????? ?????? ???? ??????? ???? ???? ????? ?????????? ??? ?? ???? ???? ???? ???? ????????? ??? ??? ?????? ????? ??????? ????? ???????.
  • ????? ??? ?????? ????? ?????????? ????? ??????? ??????? ???? ??????? ??????? COM + ???? ????? ?? ???????.
  • ????? ????? ?????????? ??????? ??????? ??? ????? ???? ????? ????????? ???????? ?? ???????.
?????? ??? ?? ???? ?????? ????????? ???? ????? ?? ????? ????? ??? ???? "Active Directory" ???? ?? ??? ???????? ??????? ??? ?? ??? ?????? ????????. ??? ??? ???? ?????? ?????? Windows 2003 ?????? ???? ???? ???? ?? ????????? ??? ????? ????? ??????? ??? ?????? ??????? ???? ??? "??? ?????? ????????" ?? ???? ??? Microsoft ???????:
http://technet2.microsoft.com/WindowsServer/en/library/f5c70774-25cd-4481-8b7a-3d65c86e69b11033.mspx?mfr=true

????? ????? ????????? ??????? "????? ???????"

???? ?? ?? ?????? ??????? ?????? ??? ????? ????? ????? ????????? ???????:
  • Microsoft Internet Explorer 5.0 ?? ????? ???? ?????.
  • ??? ?? ????? Internet Explorer 6 ??? ???? ??????????????? ?????? ????? Windows (????? ????? ???????)??? ????? ???? ??????.
  • ?? ???? "????? ???????" ???? ????? ??? ????? MSOLAPDisco.3 SPN ??????? SQL. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
    950599????? SPN ????? ?????? SQL Server ????? ???? ?????? ????? ??? ???? ???? ?? SQL Server 2005 Analysis Services ?? SQL Server 2005
?????? ????? ????? ?????? ????? Windows (????? ????? ???????) ?????? ??????? ??? ???? ??? ????? ????? ??????? ?? ?????? ?????? ?????? ????. ?? ???? ??? ????? ????? ???? ????????? ??? ??????? ???? ???????.

????? ????????? ??? ????????? ???? ???? ?????? IIS

???? ?? ?? ?????? ??????? ?????? ??? ????????? ???? ???? ?????? IIS ?? ??????? ?????? ??????? ?????:
  • ????? ????????? ??????? ?? IIS ??? ??? ?????? ?? ?????? ??????? ???? ?? ?????? ????? ??? ???????:
    • ????? ?????? ???? ?????? ????? ??? ?????? Windows ????????? ?? ??? ???????? ????????.
    • ?? ????? ????? ??????? ??????? ??? ???? (?????).
  • ??? ????? ??????? "????? ????????" ??????? ????? ??? ?? ?? ??? ?????? ??????? ???? ?? ?????? ?????? ????? ???:
    • ??? ????? ????? ???????? ????? COM + ??????. ????? ?? ????????? ??? ????? ????? ???????? ???????? ?? ?????? ???? Microsoft ?????? ??? ?????:
      http://msdn2.microsoft.com/en-us/library/ms681722.aspx
    • ??? ????? ???? ??????? ????? COM + ????? ???? Windows ??? ??? ???? ????? ?? ?? ??? ??????? ??? ????? ???????. ????? ?? ????????? ??? ????? ????? ???? ?????? ?? ?????? ???? Microsoft ?????? ??? ?????:
      http://msdn2.microsoft.com/en-us/library/ms681314.aspx
  • ????? ??????? ????????? ?? ??? "????? ???????" ????? ??? ???? ????????? ?????? ??????? ????? Analysis Services SSPI = Kerberos ???????.
  • ?? ????? ???????? ??? ?? ???? ??? ???? ???????? ??? ?????? ?????? ??????? (FQDN) ?? ??? NETBIOS. ??? ???? ??????? ?? ???? FQDN???.mydomain.com? ? ?? ???? ??? NETBIOS ??????????. ??? ???? ?? ????? ????? IP ????? ?????? Kerberos.
  • ?? ???? SPN ??? ????????? ???? ???? IIS ????? ??????. ????? SPN ?????? ?????? ??? ??? ????????? ?? ??? ??????? ????? ???? ????????? IIS. ????? ?? ????????? ??? ????? ????? SPN ??? ????????? ???? ???? ?????? IIS? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
    929650????? ??????? ????? Spn ????? ???? ?????? ??????? ????? ???? ??? ????????? ?? IIS 6.0
    setspn -S http/IISComputerName IISComputerName
    ?????? SPN ??? ????????? ???? ???? ?????? IIS ??????? ???? ??????? ???????? ?? "????? ????? ??????? ???????? Kerberos ?????? ???????? ???????? ".
  • ??? ????? ???? ?????? ?????? ??? ???? IIS ?????? ??????? Kerberos. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
    215383????? ????? IIS ???? ?? ?? ???????? Kerberos ????????? NTLM ??????? ??????
  • ??? ?????? ?????? ?????? Kerberos ????? ???? ?????? ??? ???????. ????? ?? ????????? ??? ???????? ???? ?????? ?????? ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://technet.microsoft.com/en-us/library/cc779260.aspx
?? ???? ?????? ?? ???? ??????? ?????? ?? ?????? ??????? Kerberos? ???? ??????? ???????? ?? ????? ????? ??????? ??????? ?????? ??????? ??????? ??????? ???????? ???? ?? ??? ????? ??????: ????? ?? ?????????? ???? ??? ??? ??????? ?????? ??? ??????? ?? "????? ??????? ? Microsoft":
262177????? ????? ????? ??????? Kerberos

?????

????? ?? ????????? ??? ????? ????? SQL Server 2000 ??????? ???? ????? ???????? ?????? Kerberos? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
828280????? ????? ???? ?? ????? ????? SQL Server 2000 ???????? ?????? Kerberos
????? ?? ????????? ??? "??? TechNet ?? ????? ?????" ???? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
916962WebCast ??? TechNet: ????? Microsoft SQL Server 2005 Analysis Services ??????? Kerberos
??? ?? ????? Microsoft SharePoint Portal Server ??? ????????? ?????? ????????? ?? ??? ????? ?????? ??????? ?????? ??????? NTLM ???. ????? ?? ????????? ??? ????? ????? ?????? vitual ?????? ???????? ??? ???????? (Kerberos)? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
832769????? ????? ???? ????? Windows SharePoint Services ??????? ?????? Kerberos ?????? ??????? ?? ?????? Kerberos ??? ?????? NTLM

???????

???? ???????: 917409 - ????? ??? ??????: 19/???/1434 - ??????: 8.0
????? ???
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2005 Analysis Services
????? ??????: 
kbsqlsetup kbexpertiseadvanced kbsql2005as kbhowto kbmt KB917409 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????917409

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

 

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