????? ???? ???????? SQL Server 2000 Analysis Services ?? ???? ??????? Windows 2000 ? Windows Server 2003

?????? ????????? ?????? ?????????
???? ???????: 308023 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ???? ????? ??? ????? ????? SQL Server Analysis Services 2000 ????? ?????? ????????. ??? ????? ?? ?? "????? ?????" ??? ????? ????? ?? ???? ??????, ????? ????? ?????? ????? ????? ????? ??? ??? ????.

??? ????? ??????? ??????? ?? ??? ??????? ???? ???? ?? ???? Analysis Services ?? ???? ?????? ???????? ???? ???? ??????? ???? ????? ?????? ?????. ??? ????? ???????? ??????? ?????? ??? ????? "????? ??????? ?? Microsoft" ???:
  • ??? ??????? ?????? ??? ???? ??????? ???? ????? ??????? Microsoft Windows 2000 Advanced Server ?? ???? ??????? ???? ????? ??????? Windows 2000 Datacenter Server ?? ???? ??????? ???? ????? ??????? Windows Server 2003.
  • ????? ???? ???????? ???? ???? ?????? Analysis Services ????? ?? ??? ?????? ???? ???????? ?????????? ???? ????? ??? ????? IP ?????? ? ??? ???? ??????.
?????? ???? ??? ????? ??????? ?? Microsoft ??? ?????? ?? ?? ???? ??? ???? ?????? ???????? ????? IP ?????? ???????? ??? ???? ????? ??????? ?????? "????? ???????" ?? Node1 ??????.

?????????? ??????? ????????? Analysis Services 64-?? ?? ??? ??????? ??? ?????? "????? ????? 64-?? ???????" ??????? ". ????? ??????? ???? ??? ?? ???? ??????? Analysis Services 64-?? ??????? ???? ????????? ??? ????? ?????? SQL Server. ???? ?? ??????? ????? ??????? ???? ????? ??????? SQL Server ???? ??? ??????? ???? ????????? Analysis Services ?? ??:
  • ????? ????? ??????? ???? ????? ??????? SQL Server ???? ???? ??????? ??? ????????? ????? ???? ????????. ??? ??????? ?? ???? ?????? ?????? ????? ???? ???? ?????? ??????? ????? ????? ??????? ??? ??????? ???? ????? ??????? SQL Server.
  • ????? ????? ??????? ???? ????? ??????? SQL Server ???? ???? ??????? ??? ????????? ??? ???? ????????. ????? ??? ??????? ?? ??? ???? ?????? ??? ????????? ????? ?? ???/???? ???????. ????? ??? ??????? ?????? ?? ??????? ?????? ????? ???? ??????? ????????.
??? ???? ????? ????? ????? SQL Server 2000 ??? ?????? ???/????. ?? ??? ?????? ????????? ???/??? ?? "????? ?????".

??????? ?? ??????? ??? "????? ?????" ??????? ?? ??:

???? ????? SQL Server ???????? ????? ??????? ??????. ??? ??? ????? SQL Server ? ????? ????? ????? ??? ???? ??? Analysis Services ??? ????? "????? ???????". ????? ??? ?????? ??????? ??? ???? SQL Server ??? ?????. ???? ??? ???? SQL Server ?????? ??????? ???? ????????? Analysis Services 64 ??.

????? ????? ??????? ??? Node1

  1. ????? ?????? ??????? ??????? ?? ?????? MSOLAP\Install ??? ????? ??????? ????? ?? SQL Server 2000 ?? ???? ??? "2000 ??????... ????? ????? ????? SQL Server" ?? ????? ??????? ???????? ???? ???? ??? ???? "????? ???????" ???? ????? ??? SQL Server.
  2. ?? ???? ?????? "???????" ? ???? ??? ??????.
  3. ?? ???? ?????? "??????? ????? ???????" ? ???? "??????? ???????" ?? ???? ??? ??? ??????? ???? ?????????.
  4. ?? ???? ?????? ????? ?????? ???? ?? ????? ???? ?????? ??? ?? ???? ?????? ????????? ????? ??????. ???? ??? ??????.
  5. ?? ???? ?????? ???? ?????? ???????? ????? ?????? ???? ??? ???? ????? ??????? ???? ???????? ??? ???? ????? ????? ???????? Analysis Services. ???? ??? ???? ?????? ???? ???? ???????? ?????? "?????? ???????" ?????? ?????? ??????? ????? ??. ???? ??? ??? ?? ???? ??? ??????.
  6. ?? ???? ?????? ????? ???? ?????? ? ???? ??? ?????? ????? ?????? ?????????.
  7. ??? ?????? "?????? ???????" ? ???? ??? "?????" ?????? ?????? ???????.

????? ?????? ????? ????? 64-??

?????? ???? ?? ????? ???? SQL Server ????? ??? ??????? ???????? ??? ????? "????? ???????". ????? ??????? Analysis Services 64-?? ??????? Analysis Services 32-?? ?? ???? ???? ??? ?????? SQL Server Analysis Services.

?????? Analysis Services 64-?? ???? ??????? ???????:
  1. ???? ??? ???? "????? ????" ???? ??? ???? ?????? ?? ???? ??? ??????.
  2. ???? ??? ?????? ?????.
  3. ???? ?????? ????? ???? ???????? SQL Server ???? ??? ????? ??? "???? ?????" ?????? ???? ????????.
  4. ???? Server Analysis, ???? ??? ?????? ???????.
  5. ???? ??? ??????? ? ??? ???? ?????? ??? ???? ????? ???????? ?? ??? ???? ???????? ??? ???? ????? ??????? ?????? "????? ???????" ?? ???? ??? ??????.
  6. ?? ???? ?????? ??? ???? ???? ??? ???? SQL ??????? ???? ?????? ??? ?? ???? ??? ??????.
  7. ???? ????????? ?????????? ??????? ????????.

????? ???? "?????? ?????" ??? ??? ??????? ?????? ??? Node1

  1. ??? ???? ???? ????? ???????. ???? ???? ???? ????? ??????? ??? ???? ?????? ???? ??? ???? ? ???? ??? ??????? ? ???? ??? ????? ?????? ? ?? ???? ??? ?????.
  2. ??? ???? ???? MSSQLServerOLAPService ?? ??????? ??? ?? ???? ????? ??????? ??? ??? ?????? MSSQLServerOLAPService ???? ???? ?????? "?????".
  3. ?? ??????? ??? ? ????? ??? ??? ??????? ??? ????.
  4. ??? ???? ???? ?????? ?? ???? ? ???? ??? ?????.
  5. ???? ??? ????? ?????? ???? ?????? "?????".
  6. ???? ???? ???? ????? ???????.

????? ?????? ????????? OLAP ??????

????? ????? ????? ?????? ????????? OLAP ?? ?????? ?????? ??? ?????? ??????? ??????? ??????? ???????. ???? ??? ?? ???? ?????? ??????? ??????? ??? ????? ?? ?? ???? ?? ?????? ?????, ??? ????? ??? ?????? ??????? ??? ??? ???? ???????? ?? ???? ????? ?? ????? ???????. ????? ??????? ACL ??? ??????? ?????? ?????? ???? ????? ? ??? ????? ?????? ????????? OLAP ??????? ????? ???? ????? OLAP ???????? ????? ??? ???? ????? OLAP ?????? "???????".
  1. ??? ???? ?? ???? ???? ???? ???????? ???????.
  2. ??????? ??? ??????? Active Directory ??? ????? ????????? ?? ????? ?????????? ?????? ????????? ?????? ???? ????? ?????? ????? ???? ????????? OLAP.
  3. ????? ???? ?????????? ????? ??? ?? ???? ????????? ?? Analysis Services ??? ?????? ????????? OLAP.
  4. ????? ????? ??????? Active "?" ????? ????????? "??" ????? ?????????? ?????? ?????????.


????? ?????? OLAP ?????? ??? ?????? ????????? OLAP Node1

  1. ??? Node1 ? ???? ??? ?????? ?????? ??? ???? ????????? ?? ???? ??? ?????.
  2. ?? ?????? ???? ????????? ??????????? ???????? ??????? ??? ????? ??????.
  3. ???? ??? ???? ???????.
  4. ???? ??? ?????? ?????? ??? ?????? ????????? OLAP ???????? ?? ?????? ?????? ??? ?? ???? ??? ?????.
  5. ?? ???? ?????? ????? ????????? OLAP ? ???? ??? ?????.
  6. ?? ???? ?????? ????? ???????? ?? ??????? ? ???? ?? ????? ?????? ???? ??? ??????? ?? ?????? ????????? OLAP.
  7. ??? ???? ?? ?????? ????????? OLAP ?? ??????? ??? ?? ???? ????? ??????? ??? ??? ?????? ?????? ????????? OLAP.
  8. ???? ??? ????? ?????? ???? ?????? ????? ???????? ?? ???????.
  9. ???? ??? ????? ?????? ???? ?????? ????? ????????? OLAP.
  10. ???? ???? ???? "????? ?????????".


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

????? ????? Microsoft ?????? ??? ??????? ?? ??????????? ??????? ??? ?????? ?? ????? ?????? "??? ?????????" ?? Microsoft Access ?????? Msmdqlog.mdb. ?????? "????? ?????? ??????? ????? ???" ????? ?????? Msmdqlog.mdb ??????? ???? ??????. ????? ????? Microsoft ?????? ???? ????? ?????? ??????? ??? ????? ?????? Msmdqlog.mdb ?? ??????? ??????? ????? ????? ?????. ??? ?? ???? ??? ?????? ??????? ?????? ?? ???? ????????; ??? ???? ??? ?? ???? ??? ??? ?????? ??????? ????? ?? ???? ????????.
  1. ??? ?????? Windows.
  2. ??? ??? ????? ???????? ???? ??????? ???? ???? ???????? ?? ????? "????? Analysis Services ??? Node1" ??????.
  3. ????? ???? ???? ???? AnalysisLog.
  4. ????? ??? ????? Files\Microsoft C:\Program Services\Bin ??????.
  5. ??? ??? Msmdqlog.mdb ?? ??? ?????? ??? ?????? AnalysisLog ?????? ??? ????? ??????? ?? ??????.

????? ?????? ????? ????? 64-??

???? ???????? ????? ????????? ??????? ?? ???? SQL Server ???? ??? ??????? ??? ????? Analysis Services 64-??.

???? ?? ??? ????? ???????? OLAPQueryLog ?? ???? SQL Server ??????? ??? ???? SQL Server ??????? ??? ????? ???????? OLAPQueryLog ????? ??? ????? ???????. ????? ??? ????? ???????? ???????? ?? ?? ????? ???????:
  • ????? ????? ????????? ?????????? ?? SQL Server ????? ????????
  • ??? ????? ??????? ?? SQL Server ????? ????????
  • ?????? ??? ????? ????? ?????? (DTS) ???? ?????? ??? ???? SQL Server ??????? ?? ???? 32-?? ?? ????? SQL Server ???????
?????? ?? ???? ??? ????? ???? AnalysisLog ??? ????? ??????? ?? ???? ??? ?? ???? ???? ?? ??????? ?????? ?? ??? ??????.

????? ???????? ?? ???????? $ MsOLAPRepository ??? Node1

  1. ????? ??? ????? Files\Microsoft C:\Program Services\Bin ??????.
  2. ???? ??? ?????? ?????? ??? ???? ??? ??? ?? ???? ??? ??????.
  3. ???? ??? ?? ?????? ??? ?????? ??? ??????.
  4. ???? ??? ????? ?????? ???? ?????? ????? ???.
  5. ?? ?????? ?????? Windows.


??? ??? ???

  1. ??? ????? ???? ???? "????? ??????".
  2. ??? ????? ????? ????????.
  3. ???? ??? ?????? ?????? ??? ?????? ?????? ???? ????? ??? ????? IP ???? ?????? ??? ?? ???? ??? ??? ????????.
  4. ???? ??? ?????? ?????? ??? ?????? ?????? ???? ????? ??? ????? ?????? ????? ????? ???????? OLAP ??????? AnalysisLog ??? ?? ???? ??? ??? ????????.
  5. ????? ????? ??????.


????? ????? ??????? ??? Node2

  1. ????? ?????? ??????? ??????? ?? ?????? MSOLAP\Install ?? "????? ???????" ?? SQL Server 2000 ?? ???? ??? "2000 ??????... ????? ????? ????? SQL Server" ?? ????? ??????? ???????? ???? ???? ??? ???? "????? ???????" ???? ????? ??? SQL Server.
  2. ?? ???? ?????? "???????" ? ???? ??? ??????.
  3. ?? ???? ?????? "??????? ????? ???????" ? ???? "??????? ???????" ?? ???? ??? ??? ??????? ???? ?????????.
  4. ?? ???? ?????? ????? ?????? ???? ?? ????? ???? ?????? ??? ?? ???? ?????? ????????? ????? ??????. ???? ??? ??????.
  5. ?? ???? ?????? ???? ?????? ???????? ? ??? ??? ?????? ??? ???? ????? ??? ?????? ???? ??? ??????? ??? ????? "????? ???????" ??? Node1 ??????. ???? ??? ??????.
  6. ?? ???? ?????? ????? ???? ?????? ? ???? ??? ?????? ????? ?????? ?????????.
  7. ??? ?????? "?????? ???????" ? ???? ??? "?????" ?????? ?????? ???????.

????? ?????? ????? ????? 64-??

?????? ???? ?? ????? ???? SQL Server ????? ??? ??????? ???????? ??? ????? "????? ???????". ????? ??????? Analysis Services 64-?? ??????? Analysis Services 32-?? ?? ???? ???? ??? ?????? SQL Server Analysis Services.

?????? Analysis Services 64-?? ???? ??????? ???????:
  1. ???? ??? ???? "????? ????" ???? ??? ???? ?????? ?? ???? ??? ??????.
  2. ???? ??? ?????? ?????.
  3. ???? ?????? ????? ???? ???????? SQL Server ???? ??? ????? ??? "???? ?????" ?????? ???? ????????.
  4. ???? Server Analysis, ???? ??? ?????? ???????.
  5. ???? ??? ??????? ? ??? ???? ?????? ??? ???? ????? ???????? ?? ??? ???? ???????? ??? ???? ????? ??????? ?????? "????? ???????" ?? ???? ??? ??????.
  6. ?? ???? ?????? ??? ???? ???? ??? ???? SQL ??????? ???? ?????? ??? ?? ???? ??? ??????.
  7. ???? ????????? ?????????? ??????? ????????.

????? ??????? ???? ?????? ??? ??? ??????? ?????? ??? Node2

  1. ??? ???? ???? ????? ???????. ???? ???? ???? ????? ??????? ??? ???? ?????? ???? ??? ???? ? ???? ??? ??????? ? ???? ??? ????? ?????? ? ?? ???? ??? ?????.
  2. ??? ???? ???? MSSQLServerOLAPService ?? ??????? ??? ?? ???? ????? ??????? ??? ???? MSSQLServerOLAPService ???? ???? ?????? "?????".
  3. ?? ??????? ??? ? ????? ??? ??? ??????? ??? ????.
  4. ??? ???? ???? ?????? ???? ???? ? ???? ??? ?????.
  5. ???? ??? ????? ?????? ???? ?????? "?????".
  6. ???? ???? ???? ????? ???????.


????? ???? OLAP ????????? ??? ?????? ????????? OLAP Node2

  1. ??? Node2 ? ???? ??? ?????? ?????? ??? ???? ????????? ?? ???? ??? ?????.
  2. ?? ?????? ???? ????????? ??????????? ???????? ??????? ??? ????? ??????.
  3. ???? ??? ???? ???????.
  4. ???? ??? ?????? ?????? ??? ?????? ????????? OLAP ?? ?????? ?????? ??? ?? ???? ??? ?????.
  5. ???? ??? ????? ?? ???? ?????? ????? ????????? OLAP.
  6. ?? ???? ?????? ????? ???????? ?? ??????? ? ???? ?? ????? ?????? ???? ??? ??????? ?? ?????? ????????? OLAP.
  7. ??? ???? ?? ?????? ????????? OLAP ?? ??????? ?? ???? ??? ??? ????????? OLAP ?????? ??? ????????.
  8. ???? ??? ????? ?????? ???? ?????? ????? ???????? ?? ???????.
  9. ???? ??? ????? ?????? ???? ?????? ????? ????????? OLAP.
  10. ???? ???? ???? "????? ?????????".


????? ???????? ?? ???????? $ MsOLAPRepository ??? Node2

  1. ??? ?????? Windows.
  2. ????? ??? ????? Files\Microsoft C:\Program Services\Bin ??????.
  3. ???? ??? ?????? ?????? ??? ???? ??? ??? ?? ???? ??? ??????.
  4. ???? ??? ?? ?????? ??? ?????? ??? ??????.
  5. ???? ??? ????? ?????? ???? ?????? ????? ???.


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

  1. ?? "?????? Windows?" ????? ??? ???????? ?????? Services\Bin ????? Files\Microsoft.
  2. ??? ??? Msmdrep.mdb ?? ???? ??????? ?????? ??? ???? ???????? ??? ?????? AnalysisLog ??? ????? ??????? ?? ??????.
  3. ?? ?????? ?????? Windows.

????? ?????? ????? ????? 64-??

?? ???? ??????? ??? ?????? ???? ?? ???? ??? MDB ????? ??????? ??? ???? ????????? ???? ???? ?????? SQL Server. ??? ??? ????? ?????? OLAPRepository ??? ???? SQL Server ??????? ???????? ??? ???????? ???????:
  • ????? ????? ????????? ??????????
  • ??? ????? ???????
  • ???? DTS

????? ?????? ???? ?????? ?? ?????? AnalysisLog

  1. ??? ???? ???? ????? ??????. ???? ???? ???? ????? ?????? ??? ???? ?????? ???? ??? ???? ? ???? ??? ??????? ? ???? ??? ????? ?????? ? ?? ???? ??? ????? ??????.
  2. ??? ????? ????? ????????.
  3. ???? ??? ?????? ?????? ??? ?????? ????? ??? ?? ???? ??? ???????... ????.
  4. ?? ???? ?????? ???? ???? ???? ?? ??? ??? ??????:

    "MsOLAPRepository $" (???? ?????? ????????)
  5. ?????? ??? ????? ? ????:

    "?????? ????? ???????" (???? ?????? ????????)
  6. ????? ??? ?????? ??? ?????? ???.
  7. ????? ???????? ?? ???? ??? ???????? ???? ????? ??? ????? ??????? ???? ???? ?? ????? ????? ?????? "????? ???????".
  8. ???? ??? ??????.
  9. ?? ???? ?????? ???????? ????????? ???? ?? ?? ??? ???????? ???????? ?? ????? ???????? ?????????.
  10. ???? ??? ??????.
  11. ?? ????? ??????? ???????? ?? ???? ?????? ???????? ??? ??? ???? ????? ??? ????? ?????? OLAP.
  12. ???? ??? ????? ???? ????? ?????? ??? ??????? ???????? ???????.
  13. ???? ??? ??????.
  14. ?? ??? ?????? ???? ?????? ?????? ? ???? ??? ????????:

    "MsOLAPRepository $" (???? ?????? ????????)
  15. ???? ?????? ??? ?????? AnalysisLog ???? ??? ??????? ?? ?????? "????? ???? ?? Log ?????????".
  16. ???? ??? ?????? ????? ?????? ????????.
  17. ?? ???? ?????? ??????? ???? ??? ?????.
  18. ?? ???? ?????? ????? ???????? ?? ??????? ? ???? ?? ????? ?????? ???? ??? ??????? ?? ?????? ????????? OLAP.
  19. ??? ???? ?? ?????? ????????? OLAP ?? ??????? ??? ?? ???? ????? ??????? ??? ??? ?????? ?????? ????????? OLAP.
  20. ??? ???? ?????? Domain Admins ?? ??????? ??? ?? ???? ????? ??????? ??? ??? ????? ?????? Domain Admins.
  21. ???? ??? ????? ?????? ???? ?????? ????? ???????? ?? ???????.
  22. ?? ???? ?????? ??????? ???? ??? ?????? Domain Admins ???? ???? ???????? ?????? ????? ?????? ??????.
  23. ?? ???? ?????? ??????? ???? ??? ?????? ????????? OLAP ?? ?? ??? ???? ???????? ?????? ????? ?????? ??????.
  24. ?? ???? ?????? ??????? ???? ??? ???????? Everyone ?? ???? ??? ????? ?????? ?????? Everyone ?? ?????? ????????.
  25. ???? ??? ????? ?????? ???? ?????? ??????.
  26. ???? ??? "?????" ?????? ??????? "???? ????". ??? ?? ???? ??????? ???????:
    ???? ?????? 'MsOLAPRepository $' ????? ?????.
  27. ???? ??? ????? ?????? ???? ?????? ?????.
  28. ??? ???? $ MsOLAPRepository ?? ????? ??????? ??? ?? ???? ??? ?????? ?????? ??? $ MsOLAPRepository.
  29. ???? ??? ????? Online ?????? ?????? ??????.
  30. ?? ?????? ???? ???? "????? ??????".


????? ?????? ??????? ?????? ????? ??? Node2

???? ????? ????? Microsoft ?????? ?? ?????? ??????? ?????? ??? ??????? ??? ????? "??????" ????? ". ??? ????? ??? ?????? ??????? ???? ??????? ???? ??? ???? ?????? ??????.
  1. ????? ?????? ???????? "???? ???????" (Regedt32.exe).
  2. ????? ??? ????? ??????? ??????? ??????? Server\Server HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP.
  3. ???? "RemoteRepositoryConnectionString" ??? ??? ?????? ????? ????????. ????? ???? "RemoteRepositoryConnectionString" ??? ??? ?????? ???????. ??? ???? ??????:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\MyClusterNode2\MsOLAPRepository$\Msmdrep.mdb

    ????:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ClusterServerVirtualName\MsOLAPRepository$\Msmdrep.mdb

    ??????? ????? ????? 64-??

    ?? ???? ??????? ???? ?????? ?? ?? ?? ????? ????? ???? ??? ?????? ?????? ??? ??? ?????? ??? ?? ???? ??? ????? ????? ????? ??????. ????? ????? ????? ??????? ??????? ??????? ??? ???? SQL Server ??????? ?? ??? ?? ????? ????? ??????? ? ????? ??????? ?????? ???????. ?? ???? ????? ????????? ?????? ??? ??? ??????? ??? ?????? ????? ??? ?????????, ???? ????? ????? ???????:
    ? ??????? ???????? ??? ?
    ?????? ???? ????? ?????:
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial
    				Catalog=OLAPRepository;Data Source=vsql64cluster;Use Procedure for
    				Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AP135949;Use
    				Encryption for Data=False;Tag with column collation when possible=False 
  4. ???? "????? ????? ??????" ??? ?????? ??? ?? ????? ??????? ?????? Analysis Services ?????. ????? ???? "????? ????? ??????" ??????? ??? ?????? ?????? ??????? ?? ???? "????? Analysis Services ??????" ?? ??? ???????. ??? ???? ??????:

    ???? Provider=Microsoft.Jet.OLEDB.4.0;Data = Services\Bin\Msmdrep.mdb ????? C:\Program Files\Microsoft

    ????:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Q:\AnalysisLog\Msmdrep.mdb
    Q:\ assuming ?? ???? ??????? ??? ?? ????? ?????? AnalysisLog.

    ??????? ????? ????? 64-??

    ????? ??? ??????? ?? ?????? 3.
  5. ???? "???? ?????" ??? ?????? ??? ?? ????? ??????? ?????? Analysis Services ?????. ????? ???? "???? ?????" ??????? ??? ?????? ?????? ??????? ?? ???? "????? ????? ????????? Log" ?? ??? ???????. ??? ???? ??????:

    C:\Program Services\Bin ????? Files\Microsoft

    ????:

    Q:\AnalysisLog
    ????????? ?? ???? ??????? ??? ???? Q:\ AnalysisLog ????? ??????.
  6. ????? ??? ????? CurrentVersion Server\ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP.
  7. ????? ???? ???????? ?? QueryLogConnectionString ??? ?????? ??? ?? ????? ??????? ?????? Analysis Services ?????. ??? ????? ???? ???????? ??????? ??? ???? AnalysisLog ????. ??? ???? ??????:

    ???? Provider=Microsoft.Jet.OLEDB.4.0;Data = Services\Bin\Msmdqlog.mdb ????? C:\Program Files\Microsoft

    ????:

    Source=Q:\AnalysisLog\Msmdqlog.mdb Provider=Microsoft.Jet.OLEDB.4.0;Data
    Q:\ assuming ?? ???? ??????? ???? ?? ????? ?????? AnalysisLog.

    ??????? ????? ????? 64-??

    ????? ??? ??????? ????? ??????? ??? ???? SQL Server ???????. ?????? ???? ????? ?????:
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial
    				Catalog=OLAPQueryLog;Data Source=vSQL64cluster;Use Procedure for Prepare=1;Auto
    				Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column
    				collation when possible=False
  8. ????? ???? ???????? ?? ???? RemoteQueryLogConnectionString ??? ??? ??????. ??? ????? ???? ???????? ??? ??? ?????? ??????? ??????. ??? ???? ??????:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\MyClusterNode2\MsOLAPRepository$\Msmdqlog.mdb

    ????:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ClusterServerVirtualName\MsOLAPRepository$\Msmdqlog.mdb

    ??????? ????? ????? 64-??????? ??? ??????? ????? ??????? ??? ???? SQL Server ???????. ?????? ???? ????? ?????:
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial
    				Catalog=OLAPQueryLog;Data Source=vSQL64cluster;Use Procedure for Prepare=1;Auto
    				Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column
    				collation when possible=False
  9. ???? ???? ???????.

?????? ??? ??? ???? ?????? SQL Server 2000 Analysis Services Service Pack 3 ?? ????? ???? ?????? RemoteRepositoryConnectionString ???? ??????? ???????:
  1. ???? ??? ??? ?????? ?? "????? ?????".
  2. ???? ??? ????? ?????? ????? ???????.

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

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

  1. ??? ???? ???? "????? ??????". ???? ???? ???? ????? ?????? ??? ???? ?????? ???? ??? ???? ? ???? ??? ??????? ? ???? ??? ????? ?????? ? ?? ???? ??? ????? ??????.
  2. ??? ????? ????? ????????.
  3. ???? ??? ?????? ?????? ??? ?????? ????? ??? ?? ???? ??? ???????... ????.
  4. ?? ???? ???? ???? ?????? ???? ??? ??????:

    "????? ???????" (???? ?????? ????????)
  5. ?????? ??? ????? ? ????:

    "????? ???????" (???? ?????? ????????)
  6. ????? ??? ???? ???? ????.
  7. ????? ???????? ?? ???? ??? ???????? ???? ????? ??? ????? ??????? ??? ??? ????? ???????? ? IP ???? ????? ?? ?????.
  8. ???? ??? ??????.
  9. ?? ???? ?????? ???????? ????????? ???? ?? ?? ??? ???????? ???????? ?? ????? ???????? ????????? ??? ?? ???? ??? ??????.
  10. ?? ????? ??????? ???????? ?? ???? ?????? ???????? ???? ??? ????? ???????? $ MsOLAPRepository.
  11. ???? ??? ????? ???? MsOLAPRepository ??? ????? ??? ??????? ???????? ???????.
  12. ???? ??? ??????.
  13. ?? ???? ?????? ?????? ???? ??? ???? ?? ??? ????? ?????:

    "MSSQLServerOLAPService" (???? ?????? ????????)
  14. ?? ???? ???? ?????? ????? ????:

    "Net start MSSQLServerOLAPService" (???? ?????? ????????)
  15. ???? ??? ??????.
  16. ?? ???? ?????? "????? ????????" ??????? "? ???? ??? ????? ?? ?? ???? ?? ??? ?? ???? ???? ????? ????? ??????? ?????:

    "Software\Microsoft\OLAP ????" (???? ?????? ????????)
  17. ???? ??? ????? ?????? ???? ?????? ????? ???????.
  18. ???? ??? "?????" ?????? ??????? "???? ????". ??? ?? ???? ??????? ???????:
    ???? ?????? '"????? ?????"' ????? ?????.
  19. ???? ??? ????? ?????? ???? ?????? ?????.
  20. ??? ???? ??? ?? ???? ??? ?????? ?????? ??? Analysis Services ?? ????? ???????.
  21. ???? ??? ????? Online ?????? Server ???????.
  22. ?? ?????? ???? ???? "????? ??????".


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

??? "????? ?????" ?? ???? ??????, pitfalls ??????? ?????? ??? ??????? ???????? "????? ???????" ???????? ??????? ???????? ?? ????? "????? ??????? ?? Microsoft" ???.
  • ?????? ????? ???????? ??????? ??????? ??????? Server ??????? ???? ?? ???? ????? ??? ??? ??? ???????? ?? ?????? ????? ?????? ?? RAM.
  • ??? ????? ?? ??????? ????? ?? ??????? Server Analysis ???????? ??? ?????? ?????? ?????? ??? ???? ???????? "? ??? ??? ?????? ????. ??? ????? ???? ??????? ? ????????? ???????? ??? ???? ??????.
  • ????? ????? ????? Server Analysis ???????? ??? ?????? ??????. ??? ????? ??? ??????? ?????? ?? ?? ???????? ??? ???? ??????.
  • ????? ????? ????? ???? ??????? ?????? ?? ???????. ?????? ????? ???????? ??????? ?????? ????? ??? ???????? ?? ??????. ????? ??? ????? ??? ??????? ?????? ?????? ?? ????? ????? ??? ???? ?????? ?????? ?? ??? ???? ????????.
  • ???? Analysis Services ??? ????? ?????? ?? ????? ??? ?????? Microsoft ?? ?????? ????? ????? ?????? Analysis Services ??? ????? ?? ??????? ??????? ??????? ???????? Analysis Services.

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
224967????? ????? ??????? ??????? ??? ???? ??????


???? ???? ????? ??????? ??? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/olapsite.mspx


???????

???? ???????: 308023 - ????? ??? ??????: 28/???? ??????/1435 - ??????: 11.7
????? ???
  • Microsoft SQL Server 2000 Analysis Services
  • the operating system: Microsoft Windows 2000
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
????? ??????: 
kbnosurvey kbarchive kbmt kbproductlink kbgraphxlink kbhowtomaster KB308023 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????308023

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