????? ????? ???? SQL Server 2000 Analysis Services ???????? ?????? Kerberos?

?????? ????????? ?????? ?????????
???? ???????: 828280 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

??????

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

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

?????? ??????? ???? ????? ??????? ???????? ???????? Kerberos ???? ??????? ???????:
  1. ????? Analysis Services ???? ?????? Service Pack 3 (SP3) ?? ????? ???? ??? ????????? ?????? ??????? ???? ????? ????????? ??????? ???? ??? ??? ??????? ?????? ?????.
  2. ??????? ?? ?????? ??????? ??? (SPN) ??????? ??????? ?????? (MSSQLServerOLAPService) ??? ????????? ?????? ?????.

    ?????? ??? ???? ?????? MSSQLServerOLAPService ???? ??? ???? ???? ???? ?????? ?????? ' ? ??? ????? SPN ????????. ??? ???? ?????? MSSQLServerOLAPService ???? ??? ???? ???? ???? ??? ???? ?????? ?????? ' ? ??? ????? SPN ??????. ?????? ????? ?????? ?????? ???????? Setspn.exe ?? Microsoft Windows 2000 Resource Kit. ?????? ?????? ???????? Setspn ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://www.microsoft.com/downloads/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46
    ??? ????? ?????? ???????? Setspn ???? ??????? ???????:
    1. ?????? SPN ????????? ?????? ????? ??? ??????? ??? ???? ???? ?? ?????? ????? ?????? ?? ???? ???????:
      full_path_of_Setspn.exe -A MSOLAPSvc/serverHostName.Fully_Qualified_domainNameserverHostName OLAP_Service_Startup_Account
    2. ??? ??? ??? ???? ????? SPN ????????? ?????? ????? ??? ??????? ??? ???? LocalSystem ?? ?????? ????? ?????? ?? ???? ???????:
      full_path_of_Setspn.exe -A MSOLAPSvc/serverHostName serverHostName
      
    3. ?????? ?? ?? ??? ??? ?? ?? ?????? ?? SPN ?? ??????? ??????? ?????? ?????? ??????? ??????? ?? ???? ???????:
      full_path_of_Setspn.exe -L OLAP_Service_Startup_Account
      
      full_path_of_Setspn.exe -L hostName
    4. ??? ?? ????? ????? SPN ??????? ????????? ??????? ????? ????? ????? ?? ?????? 2? ?? ?????? 2? ????? ????? ?? ??????? ??????:
      MSOLAPSvc/serverHostName.domainName MSOLAPSvc/serverHostName
  3. ??? ???? ???????? ??????? ??? ???? ?????? ???? ??? ??????? ???? ????? ?????? ????? MSSQLServerOLAPService:
    • ????? ?????? ?????
    • ??????? ???? ?? ???? ???????
    • ??????? ??? ???? ??? ????? ???????
    • ????? ???? ????? ??????
    ?????? ????? ??? ???? ???????? ??? ???? ?????? ?????? ???????? ?????? ???????? "??? ?????? ??????" ?? "????? ??????" ?? "???? ??????".
  4. ??? ?????? ?????? ?????? ??? ?????? Windows ????????? OLAP ??? ???????? BIN ????????? ?? ???? ????? "????? ???????". ?? ???? ?????? ??? ???????? ??? ????????? ?????? ????? ?????? ??? ???:
    • ????? Files\Microsoft C:\Program Services\BIN
    • ????? Files\Microsoft C:\Program Services\Data
  5. ????? ???? ?????? ???? ???? ?? ????? OLAP ?????? Administrators Windows.
  6. ??? ?? ??? ??????? Analysis Services ??? SQL Server ? ???? ?? ???? ???? ?????? ???? ?????? db_owner ??? ????? ?????? ???????.

????? ????? ??????? ???? Analysis ? ????? ????????? ??????? "????? ?????"

???? ?? ????? ?????? ??????? ??? ????? ????? ??????? ???? ??? ????? ????????? ??????? Analysis Services:
  • ??? ??? ????? ??????? ???? Analysis ????? Microsoft Windows 2000 ?? ????????? ???????.
  • ???? ????? ????????? ?????? ????? ?? Windows ??? ?????? ?? ?? ?????? Windows ????? ????? ?????? ???????. ?????? Windows ??????? ???? ???? "Active Directory".
  • ??????? ?????? ??? ????? ??? ?????? ????? ??????? ??????. ??????? ??????? ?????? ?????? ????? net time. ????? ?? ????????? ??? ????? net time ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://technet2.microsoft.com/WindowsServer/f/?en/Library/fbf96287-fc67-46bf-8e9e-e79623e85ab51033.mspx
  • ??? ????? ??????? ????? ????? ???? ??? ????? ??????? ???? ???????.

    ?????? ????? ????? ????? ??? ???? ?? ????? IP ????????? ?????? ??? ??? NetBIOS.

    ?????? ??? ???? ?? ????????? ??? ????? ????? ??? ????? ????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft ":
    308201????? ????? ????? ????? ??? ???? DNS ?? ???? ??????? Windows 2000
  • ??????? DNS ?????? ??? ????? ???? "????? ?????" ????????? ??????? ?? ???? Windows ???? ??? ??? ???? ???? ??? ?????? (DNS). ?????? ??? ???? ?? ????????? ??? ????? ????? ???? DNS ???? ?? ?????? ???? Microsoft ?????? ??? ?????:
    http://technet2.microsoft.com/WindowsServer/f/?en/Library/28cc8d8c-20fb-4cdb-8915-8df5905cbcf51033.mspx

????? ??????? "Active Directory"

???? ?? ????? ???? ?????? ??????? ?????? ??? ????????? "Active Directory":
  • ?? ??? ????? ????? ?????? ???? ? ?? ???? ????? ?????? ?????????? ???? ???? ?????.
  • ?? ????? ?? ?????? ????? ??????? ????? ?????? ?????????? ???? ???? ?????.
  • ?? ???? ??????? ???? ???? ?????? ?????? ??? ???? MSSQLServerOLAPService ? ??? ????? ??????? ?????? ????? ??????? ???? ????.
  • ?????? ????? ??????? ????? ??? ????? ???? ??????? ?? ???? COM +.
  • ?? ????? ????? ????? ?????????? ??????? ??? ????????? ???? ?????? IIS.

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

???? ?? ?? ?? ?? ??????? ??????? ????? ??? ????? ????????? ??????? Analysis Services:
  • ??? ????? Microsoft Internet Explorer 5.0 ?? ????.
  • ??? ?? ????? Internet Explorer 6.0 ??? ???? ????????? ????? ???? ?????? ????? ?????? ????? Windows (????? ????? ???????).

    ?????? ???? ???? ????? ?????? ????? Windows (????? ????? ???????) ??? ???? ??? ??????? ?????? ?????? ?? ???? ?????? ?????? ??????. ?? ???? ????? ????? ???? ????????? ??? ??????? ???? ???????.

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

????? ????? ????? IIS ???????? ?????? ?NTLM. ????? ?? ????????? ??? ????? ?????? ????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
215383????? ????? IIS ??? ???????? Kerberos ????????? NTLM ??????? ??????
?? ???? ????? ????? ??????? IIS ??? ???? ????? ???? ??????? ???????:
  1. ????? SPN HTTP ???? ??????. ?????? ????? ?? ?????? ????? ?????? ?? ???? ???????:
    Setspn - a HTTP / FQDN MyAppPoolServiceAccount
    ?????? ?? ??? ?????? FQDN ?? ??? ?????? ?????? ??????? ?? ???? ????????? ???? ?????? IIS. MyAppPoolServiceAccount ?? ?????? ???? IIS ?????? ???? ?????????.
  2. ??? ???? ???? ????????? ?? ???????? "????? ???? ?? ???? ???????" ? ?? ???????? "?????? ????? ???? ??? ????????".
???? ?? ????? ?????? ??????? ??? ????????? ???? ?????? IIS ?? ??????? ?????? ??????? ?????:
  • ????? ????????? ??????? ?? IIS ????? ??? ?? ???? ????? ?? ?????? ?? ?????? ??? ???????:
    • ??? ????? ????? ?????? ???? ???? ?????? ????? Windows ?? ?????? ????????.
    • ?? ????? ????? ??????? ??????? ??? ????? (?????).
  • ??? ????? ??????? "????? ????????" ??????? ?? ???? ??? ?? ???? ????? ?? ?????? ?????? ??? ??????:
    • ??? ????? ????? ???????? ???? COM + ??? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ????? ?????? ?? ?????? ???? Microsoft ?????? ??? ?????:
      http://msdn2.microsoft.com/en-us/library/ms681722.aspx
    • ??? ????? ???? ??????? ???? COM + ??? ???? ???? Windows ??? ?? ????? ??????? ?????? ????? ???????. ?????? ??? ???? ?? ????????? ??? ????? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
      http://msdn2.microsoft.com/en-us/library/ms687759.aspx
  • ????? ????? ??????? ????????? ?? ??? ????????? ?????? Analysis Services ??????? ???????? ?????? ????? SSPI = Kerberos ???????.
  • ??? ???? ?????? MSSQLServerOLAPService ???? ??? ???? ???? ? ????? ??????? ????????? ?????? Analysis Services ??????? ???? ??????? ???????? ?????? ????? ????? ??? SSPI = Kerberos ??????? ??????? ??? ?????? ?????? ??????? ?? "?????? ?????".
  • ?? ???? ??? ????? ????? SPN ????????? ???? ?????? IIS. ?????? SPN ????????? ???? ?????? IIS ?? ?????? ????? ?????? ?? ???? ??????? ?? ???? ????? ?????? ???????? Setspn:
    setspn -A http/IIS Computer Name IIS Computer Name
    ?????? SPN ????????? ???? ?????? IIS ?????? ? ???? ??????? ???????? "????? ????? ????? ??????? Kerberos ?? ???????? ??????" ??? ?? ??? ???????.

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
319723????? ??????? ?????? Kerberos ?? SQL Server
326985????? ??????? ???????? ???????? ?? Kerberos ?? IIS
283201????? ??????? ??????? ?? Windows 2000 ?? COM +
215383????? ????? IIS ??? ???????? Kerberos ????????? NTLM ??????? ??????
266080?????? ??? ??????? ???????? ???? ????? Kerberos
176377?????? ??? ???? SQL ???????? ?????? ???????? ?? ASP
301423????? ????? ????? ??? Windows 2000 ??? ???? ??????? ???? ????? ??????? Windows 2000 Server
917409????? ????? SQL Server 2005 Analysis Services ???????? ?????? Kerberos?

???????

???? ???????: 828280 - ????? ??? ??????: 14/???? ??????/1435 - ??????: 5.3
????? ???
  • Microsoft SQL Server 2000 Analysis Services
????? ??????: 
kbnosurvey kbarchive kbmt kbkerberos kbcomservices kbclientserver kbactivedirectory kbsecurity kbuser kbauthentication kbcommandline kbservice kbserver kbdatabase kbhowtomaster KB828280 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????828280

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

 

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