??? failover ??????? ?? SQL Server 2005 ???????? ???? ?? ??????? ???? ?? ??? ???? ????

???? ?????? ???? ??????
???? ID: 910230 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? failover ??????? ?? Microsoft SQL Server 2005 ???????? ?????? (SSAS) ?? ??????? ?? ???? ??? ?? ?? ?? ???? ???, ?? Microsoft ??????? ???? (MSCS) SSAS ?? ??? superior ??????????? ?????? ????? ???

?? ???? ????? ???? ?? ?? ????? ????:
  • ??? failover ??????? ?? SQL Server 2005 ???????? ???? ?? ??????? ???? ?? ??? ???? ????
  • ??????? ??? ??? ?? ?? ???? ?? ?????? ???? ?? ??? ???? ????
  • SQL Server 2005 ???????? ???? ?? ?? failover ??????? ?? ??????? ?? ??? ???? ????
  • ????? ?????

?????

?? ???? ????? ?? ?? ???? ?? failover ??????? ?? SQL Server 2005 ???????? ???? ?? ??????? ???? ?? ???, ?? clustering failover ???????? ?????? ?? ???? ??? ???? ??????? ?????? ????? ???

???? ???????

?? failover clustering ?? ?????? ???? ?? ??? SQL Server 2005 ??????????? ??????? ?? SQL Server 2005 Standard Edition ??????? ?? ???? ???? ????? ?????? ?? ????? editions ????? ???? ?? ?? ??? failover ??????? ?? ???????? ?????? ????????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
SQL ????? 2005 ?? ?????????????? ?????SQL Server 2005 ???????? ???? ?? ??????? ??????????
SQL ????? 2005 ??????????? ???????SQL ????? 2005 ??????????? ??????? ?? ??? ??? ?????????? ???????? ?????? ?????? ??????? ?? ????? ?????? ???? ???

?????? ?? ???, ??? ?? Microsoft Windows Server 2003 ??? ??? ?? ?? failover ??????? ?? SQL Server 2005 ??????????? ??????? ??????? ???, ?? ??? ???? 8 ????? ????????
50
SQL ????? 2005 Standard Edition216
???:??? SQL Server 64-??? editions failover clustering ?????? ??? ?? ???? SQL Server 2005 x 64 ??????? ??????? ????, failover clustering ?? ??????? ????? ??????? ???? ?? ?? ???????-?????? ???????? ?? ??? ??? SQL Server 2005 ??????? ??????? ??, ??????? ????? ??????? ???? ????

??? failover ??????? ?? ???????? ???? ?? ??????? ???? ?? ??? ???? ????

?? ??????? ?? ???? ???????? ???? ?? ??? ?? ???? SQL Server 2005 ?? failover ??????? ??? ????? ?? ??? SQL Server 2005 ???????? ???? ??? ?????? SQL Server 2005 ??????? ?? ???, ????? Microsoft ?????? ??????? (MSDN) ??? ???? ?? "???? ?????? ???? ?? ??? ??? ?? ??????, ?? ??? SQL Server 2005 ??????? ????? ????????? ??" ??? ?????:
HTTP://msdn2.Microsoft.com/en-us/library/ms144259.aspx
??? failover ??????? ?? ???????? ???? ?? ??????? ???? ?? ??? ?? ????? ?? ???? ????:
  1. DVD ??? Microsoft SQL Server 2005 DVD ????? ??????? ??? SQL ????? ??????? ??????? ????: ??????? ???? ????, ??? ?????Splash.htaDVD ?? ??? ??????? ??? ????? ???

    ??? ?? ???? ??????? ????? ?? SQL ????? ??????? ?? ??? ???, ?? ??????? ??????? ???? ?? ???? ??? ???????? ??? ?? ?? SQL ????? ??????? ???? ????? ??? ?? ?????? ???? ?? ??? ????? ???
  2. ??????? ????????? ?? ??????? ???? ?? ??? ????? ????????? ???, ?????, ?????? ???????? ?? ?????.
  3. ???-???? ??????? ?????? ????? ?? ??????? ?????? ?? ????? ??????? ?????? ?? ?????? ?? ??????? ???? ?? ??? ??? ????? ?? ??? ???? ?? ??? ????? ????, ?? ???? ???next.
  4. SQL ????? ??? ?????? ???? ?? ?? SQL ????? ?? ??????? ???? ?? ???? ?????? ?? ?? ?????????? ??????? ???? ??? SQL ????? ??? ?????? ?? ?????? ???? ??, ????? ??????????.
  5. SQL ????? ?? ?????? ????? ?? ??????? ??????? ????? ????next.
  6. ?????? ??????????? ?????? (SCC) ?? ????? ??, ??????? ???????? ????? ??????? ?? ???? ?? ?? ?????? ?? ??? ????? ???? ??? ????? ????, ?? ??? ????? ????STOP:. ????? ?? ???? ???? ??, ?? ??? ????? ???????? ????.

    ???:??? ??? ?? ?????? ?? ????? ??????? ???? ??, ?? ?????? ?? ?????, ?? ???? ???exit. ?? ?? ?? ??? ????? ????????? ?? ?? ??????? ????? ???? ?? ???? ???

    ???? ??????? ?? ???, ????? MSDN ??? ???? ?? ????:
    ?????? ??????????? ?????? (SCC)
    HTTP://msdn2.Microsoft.com/en-us/library/ms143185.aspx

    ?????? ??????????? ?? ??? ?????????? ?? ???? ???????
    HTTP://msdn2.Microsoft.com/en-us/library/ms143753.aspx
    Microsoft SQL Server ??????? ?? ????? ?????, SQL ????? ??????? ??????? ???? ?????????? ?? ??????? ???? ?? ??? ??? ??????? ??????? proceeds ?????? ????? ???
  7. ?????? ??????? ????? ?? ??? ??????? ????????, ???????????? ??? ???? ????, ?? ???? ???next.
  8. ?? ??? ?? ??????? ???? ?? ??? ??? ????? ???? ?? ??? ???? ?? ??????????? ????????? ????? ????? ???????? ????? failover ??????? ???????? failover ??????? ?? ???????? ???? ??????? ????, ?? ???? ??? ???? ?? ??? ????? ??? ????next.

    ???
    • ?? ???? ?? ?????? ??? ????? ?? ??? ???? ?? ??? ????? ?? ????? ?? ?? ?? ??? ???? ?????SQL Server ??????? ??????? ????? ?????????? ????????? ????? ???, ??? ????? ????????? ?? ??? ?? ?? ?? ???? ??????? ??? ??????? ?? ??? ??????? SQL Server failover ??????? ???????? ????? ????? ???????? ????? failover ??????? ???????? ????? ????? ???
    • ?? ??????? ?? ??? ?? ???? ???? ?? ??? ?????????? ????? ??????? ???? ?? ??? ???? ??? ???? ???? ??? ????? ?? ??????? ???? ?? ??? ????? ??, ?? ??????? ??????? ??? ?? ????? ??????? ???? ????
  9. ?????? ??? ????? ?? ??????? ?? ???? ??????? ?? ??? ???????? ??????? ?? ??? ????? ??????? ?? ???????? ?????? ??????? ???? ?? ?? ?? ?? ?? ???? ??????? ?? ??? ?????? ??????? ?? ??? ????, ??? ????? ????????? ?????? ??????? ?? ???????? ?? ???????? ??? ??????? ???? ???? ???

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

    ??? ??? ??? ???????? ?? ??????? ???? ?? ??? ????? ???????????? ??????, ?? ???? ??? ?? ????? ???????? ??? ???? ?????

    ???? ?? ?????? ???????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143531.aspx
  10. ??????? SQL ????? ??? ????? ?? ????? ???????? ?????? ?? ??? ??? ????? ??? ?????? ?? ??? failover ??????? ??????? ?? ??????? ?? ??? ????? ???? ???? ??? ??????? SQL ????? ??? ??????? ?? ????? ???? ?????? ?? ?? ?? ????? ??????? ?? ??????? ????? ?? ????? ??? ??? ???? ?????? ??? ????? ????,next.
  11. ?? ??????? SQL ????? ??????????? ????? ??, ??????? ????? ?? ??? ???????? ???? ??? ?? ?? ???????? ??????? ?? ??? ?? IP ??? ???? ????? ?????? ?? ???, ???????? ??????? ?? ??? ?? ??????? SQL ????? ?????? ???? ?? ??? ????????? (?? ????-????) ??????? ?? ??????? ?? ??? ?? IP ??? ???? ????? ???????? ????? ?? ???? ?? IP ??? ?? ?????? ???

    IP ??? ????? ?? ????, ?? ??? ????????? ???? ?? ??? ????? ???? ?? ??? ????? ???? ??? IP ??? ???? ???? ?? ??? ???? ????????? ???????

    ??????? ?? ??? ???? ?????? ?? ??? IP ???? ???? ?? ??? ????? ??? ?? ??? ??? IP ??? ???? ????, ?? ???? ??? ????? ????add. IP ??? ?? ????? ????? ???? ??? ???? ???? ?? ??? IP ??? ???????? ??????? ??????? ?? ??? ??? IP ?? ????? ???? ??? ?????? ??????? ????????? ?? ?? ?? ???? ???? ???? ???, ????? ????next.

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

    ??????? ????? ??????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143738.aspx
  12. ??????????? ??????? ????????, ???????? ?????? ?? ??? ????? ???? ????? ??? ?? ?????? ??? ?? ???? ?? ????? ????? ??? ?? ?????? ??????? ???? ?????? ???? ?? ????? ????, ?? ??????? ???? ?? ?? ?? ???? ??????? ??????? ???? ?????? ?? ??? ??????? ????? ??????? ???? ??? ?? ??? ????? ?? ??? ???? ?????? ?? ??? ?? ????????? ?? ???????? ??????????? ???? ???? ???? ?? ??? ????? ????next.

    ???:?? ???????? ???? ?????? ????? ?? ?? ???? ?????? ?? ??? ??? ????? ?? ????????? ?? ???? ???? ???????, ?? ????????? ??????? ?? ?? ????????? ???? ???? ?? ????? ????????? ??????? ????? ??????? ??? ???????? ??? ?? ??????? ???:
    SystemDrive: \Program Files\Microsoft SQL ?????
    For more information about cluster group selection, visit the following MSDN Web site:
    http://msdn2.microsoft.com/en-us/library/ms143523.aspx
  13. On the Cluster Node Configuration page, specify the nodes to include in the virtual SQL Server. To add a node to the virtual SQL Server, click the computer name in theAvailable Nodes???? ?? ?????? ?????? ????????? ?? ????? ????, ?? ???? ???add. To remove a node from the virtual SQL Server, click the computer name in theSelected Nodes???? ?? ?????? ?????? ????????? ?? ????? ????, ?? ???? ????????. Any nodes that are unavailable appear in theUnavailable Nodes???? ????

    ????? ?? ??? ??? ?? ??? failover ???????, ???? ??? ??????? SQL ????? ?? ??? ??????? ???? ????? ?? ????? ???????? ????????? ??????? ???? ???? ???? ?? ??? ????? ????next.

    ??????? ??? ??????????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143299.aspx
  14. ?????? ???? ??????? ????? ?? ??? ?????????? ??? ?? ??????? ???? ?????????? ?????? ??????? ?? ??? ????? ?? ???? ???? ?? ??? ???? ???? ?????? ????? ??????? ????????? ????? ?? ????? ???? ?? ??? ?? ???? ?????? ??? ?? ??? ???????? ?????? ??????? ?? ??? ???? ?? ?? ????????????? ??? ????? ???? SQL Server ????? ?? ????? ??????? SQL ????? ??? ???????? ??? ?? SQL ????? ?? ???????? ???? ?? ???? ?? ???? ??????? ?? ??? ????? ?? ??? ????? ?????????? ???? ???? ?????? ??? ???? ???? ?? ??? ????? ????next.

    ?????? ???? ??????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms144295.aspx
  15. ???? ???? (?????????) ????? ?? ?????????? ???, ???????, ?? ???????? ???? ???? ?? ??? ????? ??? ????????? ????? ?? ??????? ???? ?? ??? ????? ???? ??? ?? ??? ???? ?? ????? ???? ???? ?? ?????

    ??????? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143763.aspx
  16. Clustered ?? ??? ????? ???? ?? ???? ?????, ??????DomainName\GroupName????? ???????? ?????? ???? ?? ???? ???? ???? ?? ??? ????? ????next.

    ????? ?????? ?? ??? ????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? MSDN ??? ???? ?? ????:
    HTTP://msdn2.Microsoft.com/en-us/library/ms143195.aspx
  17. ?????????? ??? ????? ?? ???? SQL ????? ??????? ?? ??? ????? ???? ?? ??? ?????????? ??? ?? ??? ????? You must also type and confirm a strong password for the System Administrator (sa) login. ???? ???? ?? ??? ????? ????next.
  18. On the Collation Settings page, specify the sorting behavior for Analysis Services. You can use one collation for SQL Server and Analysis Services, or you can specify collations for individual components.

    To set separate collation settings for SQL Server and for Analysis Services, click to select the check box to customize for each service account. After you click to select the check box, a drop-down list appears. Select a service from the drop-down list, and then assign the collation for the service. Repeat this step for each service. ???? ???? ?? ??? ????? ????next.

    For more information about collation settings, visit the following MSDN Web site:
    http://msdn2.microsoft.com/en-us/library/ms143508
  19. On the Error and Usage Report Settings page, optionally click to clear the check boxes to disable error reporting or feature usage reporting. ???? ???? ?? ??? ????? ????next.
  20. On the Ready to Install page, review the summary of features and components for your SQL Server installation. ???? ???? ?? ??? ????? ??????????? ????.
  21. On the Installation Progress page, you can monitor installation progress on individual cluster nodes by selecting a node from theNode?????-???? ???? ???? Setup progress appears for the selected node. To view the log file for a component during installation, click the product or the status name on the Installation Progress page.
  22. On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link that is provided. To exit the SQL Server Installation Wizard, click??????.
  23. If you are instructed to restart the computer, restart the computer now. When you complete the installation, we recommend that you read the message from the Setup program. Failure to restart any one of the specified nodes may cause failures when you run the Setup program again.

How to verify whether the installation is successful

To verify whether Analysis Services has been successfully installed on each cluster node, verify that all the following conditions are true:
  • For each cluster node, open the Cluster Administrator tool, and then click the cluster group that you selected in step 12 in the "How to install Analysis Services on a failover cluster" section. You must find???????? ??????listed as a resource of the cluster group.
  • For each cluster node, you findSQL ????? ???????? ??????listed in the services list when you open the Services tool.

    ???:We do not recommend that you perform any operation on this service at any cluster node. You can manage the clustered Analysis Services by using the Cluster Administrator.
  • For each cluster node, the Analysis Services program files were copied to the following folder:
    SystemDrive:\Program Files\Microsoft SQL Server
  • The Analysis Services data files must be copied to a folder that is created on the shared drive. By default, if you did not specify a custom path for the data files, the files are copied to the following folder:
    SharedDrive:\Program Files\Microsoft SQL Server
  • SQL Server Management Studio and SQL Server Business Intelligence Development Studio must be installed on the cluster node on which you run the Setup program. SQL Server Management Studio and SQL Server Business Intelligence Development Studio must not be available in the other nodes.
  • You can connect to the clustered Analysis Services by using the virtual server name that you specified step 10 in the "How to install Analysis Services on a failover cluster" section.

    ???:Even if you install the instance of SSAS as a named instance, you must specify the named instance as the virtual server name. ?? ????? ???? ?? ????VirtualServerName/InstanceNameto connect to the instance.

How to remove Analysis Services from a failover cluster

To remove the clustered Analysis Services, follow these steps:
  1. Insert the SQL Server 2005 installation media in the disk drive.
  2. Run the following command at a command prompt:
    start /wait <DiskDrive>\setup.exe /qb REMOVE=Analysis_Server VS=<Virtual Servername> INSTANCENAME=<InstanceName> ADMINPASSWORD=<StrongPassword>
    
???: <instancename></instancename>represents the name of the instance of SQL Server 2005 Analysis Services that you want to remove.

You can also use Add or Remove Programs to remove an instance of SQL Server 2005 Analysis Services on a failover cluster.

????? ?????

  • When you install Analysis Services in a cluster group, you must make sure that the status of the group is Online.
  • If you run the Setup program from a terminal session, you must make sure that other users are logged off from cluster nodes.
  • If the installation source files are on a network share location, you must make sure that all the cluster nodes can access the share location successfully.
  • You must be either a member of the Domain Admin group or the owner of the domain group of which you want the cluster service account to be a member. Otherwise, you may receive the following error message:
    You do not have privileges to add account to the domain groups specified for this failover cluster. Ask your domain administrator for privileges to add new accounts to the domain groups, or log on using an account that does have permission.

???

???? ID: 910230 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Analysis Services
??????: 
kbsql2005as kbexpertiseadvanced kbhowto kbmt KB910230 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:910230

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

 

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