SQL ??????? ??????? ???????? ?? ???????? ?? ?????? ???? ????

???? ?????? ???? ??????
???? ID: 254593 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? ???? SQL Server ??????? ??????? ??, ?????? ????? ???????? ?? ??? ???? ?? ??? ???????? ?? ??????? ?????? ????? ??? ???????? ??? ?? ??? ??????? ?? ???? ???? ?? ???? ?? ???? ?? ?? ???????? ?? ???? ??? ??????? ??????? ?????? ???? ??? ?? ???????? ?? ??? ??????? ?????? ????? ???? ???????? ?? ???????, ????? ?????? ?? ?????? ?? ?????? ????

???:SQL Server 6.5 ?? 7.0 ??????? ?? ??? ?????? SQL Server 2000 ?? ??? ???????? ???? ????? ???? ?? ?????? ??? ??? SQL Server 2000 ??????????? ??????? clustering failover ?? ????? ?????, ???????? ?? ??? ??????? ???:
  • Microsoft ??? ???? (????? ???)
  • ?? ?? ???? ????????
  • SQL ????? ?????????? ???????
  • ???? ???????? ???????
  • ???????????
  • SQL Profiler
  • SQL ?????? ????????

???? ???????

????? ????? ?? ???? SQL Server ??????? ?? ??????? ?? ????? ???? ????????:
  1. ????, SQL ??????? ??????? ????? ?? ?????? ???? ?? ?? ?? ??? ??????? ?? ????????? ???? ????? ?? ??? ?? ??????? ????

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

    ???? ???? ??? ?? ????? ?? ?? ?? ???? thing ?? ???? ??? ???? ???? ?? ???? ??, ?? ??????? ???? ??? ????? ?? ?? ??????? ??? ?? ???? ????? ?? ???? ???? ?? ??? ?????? ??? ??? ?? ????????? ??????? ?? ???? ??????? ?? ????? ??????? ????? ?? ??????? ???? ?? ??? ???????

    ???????????

    ?? ?????? ?? ??? ???? ?? ??? ????? ?????? ?? ???? ????? ?? ?? ??? ??? ??????? ???????? ????? ?? ???? ?? ?????? ????? ??? ??, ?? ???? ???? ?? ????????? ???? ?? ??????? ????? ?? ??? ????????? ??????? ?? ???? ??????? ????? ??????? ????
  2. ?? ?? IP ??? ?? ??????? ??? ???? ????, ??????? ?? ????? ???? ??? ??????? ?????? ????? ?? ?? ??? ??????? ?? ???? ?? ????? ?? ????? ?? ??? ?? ?????? ???? ???

    ???:?? ?????? ????? ??? ?? ???? ??? ????? ??? ?? ?? IP ??? ???? ????, ?????? IP ??? ?? ???? ??? ????? ????? ???? ???? ??? ???

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

    ??? ?? ??? unclustered ?? ?? ????? re-clustering ???, ???? ?? ?????? ????? ????? ?? ???? ??????? ??? ????? ??? ?? ??????? ?? ???? ?? ?? ?? ?? ???? ?? ??????? ??????? ??? ?? ??? ?? ??? bios ??????? ?? ??????? ?? ??? Windows NT ???-??? ???? ???

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

    ?? ????? ????????? ????? ?????, ?? ????? ???? ???? ????:
    nbtstat -RR
    ??? ????????? ?????. ?????, ?? ??? ?? IP ??? ?? ????? ?? ?????? ????? ??? IP ??? ????? ???? ??, ????? ?????? ???? ?? ??? ?? ?????

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

    ?????? ????? ?????
  3. ?? ??? ??????? ???? ????, ?? ??? ??????? ????????? ??? COM ?? ??????? ?? ????? ?? ??? ????? ????????? ????? ?? ?????? pointed SQL Server subdirectory ???? ?? ??? BINN ??? ??????? ???:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\SharedFilesDir
    ???????? ??? ??, ?? ????? ????? ???? ?? ??? ????? ?????:
    C:\Program Files\Common Files\Microsoft Shared\
    ??????? ??????

    SQL ????? ??????? ???????? ?? ??????? ?? ????? ?? ??? ?? ?? ????? ???? ?? ?????? ??? ?????? ??? ?? ?????? ???? ????? ?? ?? ??? ?? ?? ??? ??? ?????? ??????? ?? ????? ????? ????????? ????? ?? ???:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SharedTools\SharedFilesD
    ????? ??? ?? ????? (???? ????????) ?? ????? ????????? ????? ?? ????? ???? ??, ????? ????? ?? ?? ?? ??? ??????? ??? ?? ????? ???? ?????:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\CommonFilesDir
    ???:???????, ?? ?????? ?? ?????? ?? ???? ??, ?? ??? ?????? ?? ????????? ???? ??? ?? ???? ?? ???? ?? ????????? ?? ???? ??????? ?? ???? ??? ?? ??? ?? ?? ???? ???? ???? ???????? ?????? ??? ?? ?????? ??????? ?? ??? ?? ?? ??????? ?? ??? ??????? ????? ?? ???? ?????? ?????, ?? _PRINT_CONSOLE_ ?????? ?????? formed ?? ????? ?? ??? = SQL ??????? ??????? ???? ???? ?? ???? ?????? ??????? ??? 1? ??? ?? ??? ??? ?? ????????? ?? ??? ??, ?? ?? ??? ????????? ???????, ???? Replres.dll ?? Distrib.exe, ?????? ?? ??? ??? ?? ?? ????????? ???? ???? ???? ??? ?? ?? ??????? ?? ??? ?????? ???? ??? ????, ?? ???? ?? ?????? ????? ????

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

    "??????? ????????" ??? ???????? 8 ?? ??????? ????

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

    3 ??? "??????? ????????" ??? ???????? ?? ??????? ????
  4. ????, SQL ??????? ??????? ???????? ???? ??????? ?? ???? ??? ???, ?? ?? ????? ?? ??? ?????? ????????? ???? ?????? ??? ?? ???? ??? ??? SQL ??????? ??????? ?????? ??? cluster_tools_share ?? ??? ?? ?? ???? ????? ??, ?? ???? ???? ?? ??? ??????? ?? ????????? ????? ?? ?? ???? ??? ????? ??? SQL ????? ????? ????????? ?? ??? ?? ???????? ???? ?? ??? ?????? ??? ?? ????????? ?? ????? ??? ????? ???? ??????
    ??????? ??????

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

    ??? ???? ?????? ???? ?? ??? ?????? ????????? ???? ???????? ??? ?? ??????? ???? ?? ??? ??? ???? ??? ?? ?????? ???, ????? ?????? ????? ??? (???????). log ????? ??? ??? ???? ??? ??:
    MSI (c) (5 C! E0) [15:40:04:153]: ??? ???: ??????? SqlLogMessage ???? ???? ??????? ??? ??? 'Node01' ??? ???? ?? ???: ' <endfunc name="VerifyAdminSharesOnNode" return="53" getlasterror="0">'.</endfunc>
    MSI (c) (5 C! E0) [15:40:04:153]: ??? ???: ??????? SqlLogMessage ???? ???? ??????? ??? ??? '<endfunc name="VerifyAdminSharesOnNode" return="53" getlasterror="0">' ??? ???? ?? ???: ' <endfunc name="VerifyAdminSharesOnCluster" return="53" getlasterror="0">'.</endfunc></endfunc>
    MSI (c) (5 C! E0) [15:40:04:153]: ??? ???: ??????? SqlLogMessage ???? ???? ??????? ??? ??? '<endfunc name="VerifyAdminSharesOnCluster" return="53" getlasterror="0">' ??? ???? ?? ???: ' <endfunc name="GetVSNodeLists" return="0" getlasterror="0">'.</endfunc></endfunc>

    ????? 2836.The ???????? ???? ????????? ?????? ??? ?????? ??? ?? 2836 ??? ????? ClusterNodeDlg ?? ???????? SelectedNodeList ???? ?? ???? ?? ???? ???
    ?????? 15:40:04: ClusterNodeDlg. ????? ????? ???
    ???:?????? ????? ??? ?????? ??? ?? 53 ??? ?? ??? ?? ???????????? "??????? ?? ???? ???? ??" ?????? ??????

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

    ???? ?????? ?? ?? ???? ?? ??? ??? 8 ??????

    ????? ?????? ?? ?? ???? ?? ??? ????????? ?? ?????? ???? ??????? ????? ?????? ????????? ???? ????? ?????? ?? ?? failover ??????? ?? ??????? ???? ?? ????? ??? SQL Server ???????? ?????? "?? ???? ??????? ?????? Clustering" ???? ??? ?? prerequisite ???? ?? ???

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

    ???? ?????? ?? ?? ???? ?? ??? ?? ?????? ??? "??????? ????????" ???????? 3 ????
  5. ??????? ?? ????? ????? \System32 ?????????? ?? ??? ??? ??????? ??????? ??????? ??????????

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

    ???? ??????? ??? ??, ?? ??? ???? ???????????? SQL ??????? ??????? ???????? ?????? CD ?? ??????? ???? ??, ????? ?? ?? ?? ???? ?? ???? ???? ?? ??? ??????? ?? ???? ?? ?? ???? ??????? ?? ???? ?? ????? ?? cluster_tools_share ?? ????? ??? ?????? ???? ???

    ???????????

    3 ??? "??????? ????????" ??? ???????? ?? ??????? ????
  6. ??????? ?? "secnode" ?????, ?? ?????? ??? ?? ??? ?????? ?????? ??????? ?? ??????? ???? ?? ?? ??? COM ??????? ?? C:\Program files\Common files\Microsoft ???? ?????????? ?? ????????? ???? ?? ?? ?? registers ????? ???

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

    ???? ??????? ???????? ??? ?? ?? ?? ????? ?? ?? ???? ?? ?? ????? ?? ?? ???? ????? ?? ?? ????? (?? ???????? ???? ???net use???? ???? ????????? ?????????? ?? ???????)? ?? ??? ????, ???????? ??? ??, node2 ????? ???? ?? ???? ???? ?? ??? ?? ?? secnode ???? ?? ??? ??????? ?? ????????? ????? ?? ??? ??????? ????? ?? ?????? ???? ?? ??? ????? When this occurs, you receive a message indicating that setup could not be run on the remote computer.

    Another problem may occur if you install from a network share when the path has a space in the name. This causes the secnode setup to fail because it is unable to handle paths with spaces unless they are quoted. There is no way around this problem apart from renaming the share.

    First resolution

    If you experience either of these problems, you should check in the <%SYSROOT%> directory for the Sqlclstr.log file or on the second node's TEMP directory for the Remsetup.log for clues or descriptions of the problem. Correct all problems and then run the wizard again.

    Second resolution

    Permissions problems can also prevent the SQL cluster Wizard from working correctly when performing operations on the second node. The account under which setup runs MUST have the appropriate permissions:
    • Be a local administrator for both nodes.
    • Have the user right to "log on as a service".
    • Have the user right to "act as part of the operating system".
    These permissions MUST exist on BOTH nodes; otherwise this step fails.

    You set these permissions from the primary domain controller (PDC). After the correct permissions are set, you need to logoff and then logon again for the changes to be reflected. For further details, refer to scenario 5 in the "Specific Scenarios" section.

    Possible problem

    Secnode may also fail if it runs but has errors internally, such as not successfully registering all the COM files.

    ???????????

    ????? ??? ?? ??????? Sqlstp.log ??? ?? ?? ??? ???????? ?? ??? ?????
  7. ????, SQL Server ??????? ??????? rebinds ????? ??????? ??? ????? ??? ??????:
    • SQL BINN ???????????
    • C:\Program Files\Common Files\Microsoft Shared\SQL ?????
    • C:\Program Files\Common Files\Microsoft Shared\Database ?????????
    ?? ????? ????? ?? ?? ??? ???

    SQL ????? ??????? ???????? ??? rebinds ????? ????? ?? ????? ?????? ??????:
    • Dbnmpntw.dll
    • Sqlstr.dll
    • Sqlwoa.dll
    • Sqlsrv32.dll
    • Cliconfg.dll
    • Cliconfg.exe
    SQL ????? ??????? ??????? ???? ??????? ??? ?? %Sysroot%\System32\Sqlctr70.dll rebinds ???

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

    Rebinding ????????? ???? ?? ???? ??? ??? ??? ??????? ?? ????? ???? ?? ??? ????? ?? ??? ?? ??? ?? ????? ??? ??? ???? SQL ?????????, SQL ???? ??????? ???? ???? ??? ?? ????? ????????? ???? ??:
    ..????????? ?????? ???? ?? ???...
    ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    248380SQL PRB: 7.0 ??????? ?? ????????? ?????? ???? ??? ?????? ??????? ??????
    ???? ??????? ?????? ?? ?? ?? ??? ?????? ?????? ????? ??? ????

    ?? ??? ?? ??? ?????? ???? ?? ?? ??? ?? ?????? ?? ?????? ???? ???? ?? ??? ??? ???: ?????? ???? ?? ??? ??? ?? ????????? ???? ?? ??? ????? ?? ????? ?? ????????? ?? ???? ???? ??? ?? ????? instantaneously ????????? ???? ??, ?? ????? ???? ????? ?? ?? ??? ?? ?? ??????? ???????? ?? ??? ????? ????? ??? ??, ????? ??????? ?? ??? ?? ??? ????? ???? ??, ???? ??? ?????? ?? ?????? ??? ??? ?? ???

    ???????????

    ????? ?? ?? ???????? ??? ?????? ????? ?? ?? ?????? ?? ?? ?? ???? ???, ?? ????????? ???? ?? ???? ??? ???? ???? ????????? ??? ?????? ?? ?? ???? ?? ?????? ???? ?? ??? ???? ????? ???? ???? ?? ??? ????? ?????? ?? Microsoft ???????? ??? ?????:
    192708INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
    219264INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
    ??????? ??????

    ??? ?? unclustering ?? ?? ?????? DLL ??? ?? ?? ?????, ?????? DLL ??? ?? ????? ?? ???? ??????? ?? ??????????? ?? ??? ?? ??? ?? ???? ??? ?? ?????? ?????? ????????? dbnmpntw.dll ????? ?? ?? ?? ?????? ?? ??????? ???? ?? ????? ?? ??? (Resrcmon.exe) ?? ???? ???? ???

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

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

    Dbnmpntw.dll.copy ???? ?? ??? ???????? DLL ?? ??? ?????, ?? ???? ??? ?? ??? ??? ?? ????????? ?????? ?? .Copy ????? ????? ??? ?? ????? dbnmpntw.dll ????? ?? ????, ????? ???? ?? ?????? ?? ???? ???????? ????? ?? ???? ???
  8. SQL ??????? ??????? ?? ??????? ??? ??? ???, IP, sqlserver, ????? ?? vsrvsvc ?????? ????? ??, SQL Server ???? ??, ?????? ?????? ?? ??????? ????? ??? ????? ??sysservers?????? ???? ??????? ????? ?? ??? ???

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

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

    ???????? ?? ?????? bringing ????? ?? ????? ??? ??? ???? ??? MSSQLSERVER $ VIRTNAME ???? ??????? ????, ?? ?? ?????? ????, ?? ??? ?? ??? ???? ?? ??? ??sysservers??? ????? ??? ?? ??? ???? ???? ??, ?? ????? ????? ???? ?? rollbacks ??? ????? ?? ??? ?? ?? ??? ??? ??? ?? Sqlsrv32.dll (??? ODBC ?????) ????? ?? rebinding ?? ??? ????? ?? ??? ???? ??, ???? fixsysservers ??? ???? ?? ??? ???? ?????? 123 ?? 126 ??????? ????? ??? (Sqlclstr.log) ??? ????? ?????

    ??? ?? ?????? ???? ??:
    • ??????? ???? ??? ?? ??? ???
    • ??? ?? ?? ???? ???? ?? Kernel32.dll ????? ?? ??? ?? ?????? ????? ??????? Vernel32.dll ???? ?? ???? ????? ?? ?????? ?? ??? ???
    • ??? ?? ???? ???? ???? ??????? ?? Microsoft ???? ?????? ????? (MDAC) ???????? ?? ??????? SQL ?? ??????? ???? ?? ????, ?????? ?? Sqlsrv32.dll ????? ?? ??????? ????? ???
    ???? ???????????

    ????? ????? ????? ???? ?? ??????????? ?? ??? ??, ???? ?? ???? ????????? ???? ?? ???? ??????? ?????? ??? ??? ??? ????? Microsoft ???????? ?????? ??? ??? ?? ?? ??? ??? ????:

    192708INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
    219264INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
    ????? ???????????

    Sqlsrv32.dll ????? ?? ??? ?????, ?? ???? ??? ???????? ????? ????? ??????????? ?? ??? ??, ???? ?? ???? ????????? ???? ?? ???? ??????? ?????? ??? ??? ??? ?? ????? Microsoft ???????? ???? ?????? ??? ??? ??:

    192708INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
    219264INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
    ????? ???????????

    SQL ?????? ?????? ???? ?? ?????? ?????
  9. SQL ??????? ??????? ???? ???? ???

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

1 ????????

??????

SQL ??????? ???????? ??? ????????? ?? ??? ???? ?? ???? ??:
@ CopyFileIfNeeded: [D:\EnterpriseEdition\x86\CLUSTER\SQAGTRES.DLL] => [C:\WINNT\System32\SQAGTRES.DLL]
@@@ CopyFileIfNeeded: [D:\EnterpriseEdition\x86\CLUSTER\SQAGTRES.DLL] => [\\LNXDAYCC02\admin$\system32\SQAGTRES.DLL]
~~~ XXX InstallRemote failed
[reghelp.cpp:34] : 2 (0x2): The system cannot find the file specified.
					
???????????

???????? ???? ?? ?? ?? ???? ??? ??????? ???? \\server_name\admin$ ????? ????? ?? ??????? ??? ???

?? ????????? ???? ?? ?? ???? ?? ???? ?? ??????? ???????? ????? (NIC) ???????? ??? ???? ??? ?? ??? ?? ?? ??????? ????? ?? ??? ???? ??? ???

???????:??? ?? ????? ????? ?? ?????? ????, Microsoft ????????? ?? ??? Windows 2000 ???????? ?? ??????? ??????? ??? ?? ???, ?? ???????????? ???? ???? ?? ??? ??? ??????? ???? ?? ??????? ???????????? ???? ?? ????? ?? ??? ???????? ?? ???? ?? ??????: ??????? ???? ?? ??? 53 ?????? ??????

???????? 2

??????

SQL ??????? ??????? ??????? ????? ????? ?? ??? ???? ?? ???? ?? ?? ?? ??????? ????? ?? ?????? ???? ??:
????? ???? ?? ????? ???
???????????

???????? ???? ?? ??? ?????? ???? ??? SQL ???? ?? ??? ??? ??? ?? ???? ??, ?? ???????? ???? ?? ???? ????? ?? ?????? ???? ?? ????? ??? ?????? ?? ??? ???? ?? ???? ??? ?? ???? ?? ?? ??? ??????, ?? ?? ??????? ??? (???? x) ?? ??? ????? ?? ??? ??? ??? ??? ??? ?? ??? ???? ??? ????? ???????

???:?? ???? ??? ???? ?? ?????? ?? ??? ???? ???? ??? The default names like "Disk Group 1" have their resources moved to the new group if required by SQL.

???????? 3

Problem

The Sqlclstr.log file shows the following:
~~~ ClusterResourceStart... tick=2, state=2
[validate.cpp:147] DeleteTestGroup:OpenClusterResource: 5007 (0x138f): The cluster resource could not be found. 
~~~ XXX Copy Files failed
[reghelp.cpp:34] : 2 (0x2): The system cannot find the file specified.
					
???????????

Check the net shares on each node and look for the following:
  • \\cluster_tools_share
  • \\cluster_setup_share
If either is found, delete them.

???????? 4

Problem

When you try to re-cluster SQL after installing SQL service pack 1, the install fails with the following error in the Sqlcluster.log file:
Looking at disk P:
Disk P is fixed in group SQL_Disk
Looking at disk Q:
Disk Q is used by SQL but is moveable
Looking at disk R:
Error: Resource groups SQL_Disk and Disk_R both contain SQL disks
[chkconf.cpp:1416] : 160 (0xa0): The argument string passed to DosExecPgm is not correct. 
[chkconf.cpp:1482] ClusterFindVirtualSQLSrvGroup: 160 (0xa0): The argument string passed to DosExecPgm is not correct.
					
The "P" drive is the drive to which SQL was installed and the installer thought it was the only drive in use. Actually, the P, Q and R drives are being used.

???????????

Check the SQL error logs andsysdevicessystem table and make sure that all drives being used by SQL are in the SQL group SQL is using.

???:If additional cluster disk resources are added to the cluster for use by SQL, or if other disks currently used in the cluster are designated for use by the clustered SQL server, they should be added as dependencies of the SQL Server.

Scenario 5

Problem

Setup is unable to update the remote node or errors occur when connecting to all the default databases during the initial setup.

?????? ?? ???::
#### SQL Server Remote Setup - Start Time 10/28/99 13:14:22 ####
Script file copied to '\\server8\ADMIN$\secnode.iss' successfully.
Installing remote service...
Running '\\node1\F$\ENGLISH\X86\setup\setupsql.exe SecNode=1 -s -f1 \\node2\ADMIN$\secnode.iss'...
Remote process exit code was '-1'.
\\node2\Admin$\sqlsp.log
Disconnecting from remote machine...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 10/28/99 13:15:08 ####
???????????

Be sure the service account is set up with all the correct permissions. By copying the existing Administrator account, you can make sure that the group memberships and many other properties are copied to the new account. When a user account is copied, the description, group memberships, logon hours, logon workstations, and account information are copied exactly. The user name, full name, and password boxes of the new account are blank and must be entered. TheUser Cannot Change Password, ??Password Never Expirescheck boxes are copied.

???:When copying an account that is a member of the Administrators local group, theUser Cannot Change Password?????? ?? ????????? ???? ???? ??? ????? ??,?????????? ????? ???? ????? ?? ??????? ???????? ????? ????? ??, ???? ??? ???? ??? ???? ?????? ??; ???????, ?? ??? ????? ???? ????? ?????? ??? ??? ??,??????? ??? ???? ??? ???? ????????? ????? ?? ??? ???? ????? ???? ?? ????? ??? ???????????? ????? ???, ?? ??? ????? ????add.

??, ???????????? ???????????, ?? ??? ????Policies\User ??????, ?????? ?? ??? ?? ??? ????????? ?????????? ??????, ?? ???? ??? ?? ?????????? ?? ??? ????? ?????? ???:
  • ???????? ?????? ?? ??? ?? ??? ??? ??? ???? ????
  • ???? ???? ?? ??? ??? ??? ?? ?????
  • ????? ??????? ??? ???
???, ????? ???? ?? ??? ???? ?? ?? ???? ?? ??? ????? ????? ?? ??? ??????????? ?? ???????? ?? ??????? ?? ??? ??:
  • ?????? ????????? ??? (RPC) ??????????? ?? ?????? ????, ?? ??? ??? ?? ???? ?????? ??? ?? ???????? ??? ?? ??????????, Regedt32 ?? Srvmgr ?? ??? ???? ?? ?????? ?????

  • NetBIOS ?????? ???? ???? ?? ??? ?????? ???? ??????? \\machine_name NET, ??????? \\machine_name\admin$ NET

  • ???? NBT ?? IP ??????????? RDR ?? SRV ???????? ???? ?? ???????? NET \\ IP ???

  • ??????????? ??????????? ?? ??? ??????? ???? ?? ??? ?????? ?? FTP ???? ?? ????? ???? ?? ?????? ?????

???????? 6

??????

SQL 6.5 ??????? ??????? ???? ???? ?? ?? ??????? ???????? ??? ?? ????? ?????? ????? ??:
Start SQL Server cConnectString="ODBC;DSN='';DRIVER={SQL Server};SERVER=CLIO;DATABASE=master;UID=sa;PWD="
					
???????????

???? ???? ???? ?? ???@@ servername?? ?? ???????? ???? ????? ??? ?? ???? ??, ??sysservers?????? ???? ?? ??????? ????? ??? ?? ??? ????????? ???? ??? ??? ??? ???? ?? ???? ?????

??? ?? ??????? ???? ??? ????? ??? ??@@ servername, ?? ODBC ????????? ?? ??? ?? ??? ???? ????? ?? ??? SQL ??????? ????? ???????? ?? ???:? ???? ?? ??? ODBC ????????? ?? ??? ?? ??? ????, ????? ????? ????????? SQL Server 6.5 ??????? ??????? ????????? ????? ?? ?? ?? ??? Intel ?????? ?????????? ?? ??? \I386\Odbc ?????????? ?? \Alpha\Odbc ?????????? ????? ?????? ?????????? ?? ????

???????? 7

??????

???????? ??? Clustwiz.exe ????? ???? ??, ?? Dr. ?????? ????? ????? ???? ?? Cpqmgmt.dbg ????? ?? ????? ?????

???????????

??? ?????? ??? ??? ????? Microsoft ???????? ????? ?? ?? ?? ?????? Compaq Insight ??????? ?? ??????? ??? ?????? Compaq SoftPak (??? ??????? ?????? SSD 2.12a) ?? ???? ????, ?? ????? Microsoft ???????? ???? ?????? ??? ??? ?? ?? ??? ??? ??? ??????? ?????? ???? ?? ?????:
192708INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
219264INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????

???????? 8

??????

????? ????????? ????????? ?? ??? ???? ??:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVer\CommonFilesDir
???????????

?? ??? ???

???????? 9

??????

?? SQL SQL ??????? ?????? ??????? ?? ????? ?? uncluster ???? ??? ?????? ????

???????????

?? SQL ??????? ?????? ??????? ????? ???? ??, SQL ??????? ?????? ???? ???? ???? ???????? ??? ??, ?? ?????? ????? ?????? ?????? ???? ??? ??:
   <Virtual_SQL_Server_Name> IP Address
   <Virtual_SQL_Server_Name> Network Name
   <Virtual_SQL_Server_Name> SQL Server 7.0
   <Virtual_SQL_Server_Name> VServer
   <Virtual_SQL_Server_Name> SQL Server Agent 7.0
					
?????? ?? ???, ??? Virtual_SQL_Server_Name xyz, SQL ?????? ??? ???????? ??? ??, ??? ?? ??? ???:
   xyz IP Address
   xyz Network Name
   xyz SQL Server 7.0
   xyz VServer
   xyz SQL Server Agent 7.0
					
??? ??? ?? ??? ?? ?????? ??? ?? ??????? ???? ?? ???:
   IP Address
   Network Name
   SQL Server
   Virtual Server
   SQL Agent
					
???? ???? ?? ?? ???? ???? ?? ?? ????? ???? ?? ??? ??????? SQL ?????? ??????? ?? ???? ???? ?? ?? ???? ?? ??? ??????? ??? ?? ?????? ?? ??? ??????

???????? 10

??????

????? ??? ?? SQLCLUST.LOG ?????? ??:
~~~ OnEnableCluster: UpdateSku
~~~ OnEnableCluster: TransferSQLServices
+++ TransferSQLServices: enter
+++ TransferSQLServices: calling AddVSNameLanManServer
[reghelp.h:132] type not REG_MULTI_SZ: 160 (0xa0): The argument string passed to DosExecPgm is not correct.

[reghelp.h:133] : 160 (0xa0): The argument string passed to DosExecPgm is not correct.

[reghelp.h:290] : 160 (0xa0): The argument string passed to DosExecPgm is not correct.

[clenable.cpp:1803] : 160 (0xa0): The argument string passed to DosExecPgm is not correct.

[clenable.cpp:1836] : 160 (0xa0): The argument string passed to DosExecPgm is not correct.

[clenable.cpp:2379] : 160 (0xa0): The argument string passed to DosExecPgm is not correct.

~~~ XXX TransferSQLServices failed
					
???????????

?????? ???? ?? ????? ????????? ????? ?? ?????? ???:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\NullSessionPipes
					
REG_MULTI_SZ ???

???????? ?????? RegQueryValue_MULTI_SZ() ??? ??? ?? ???? ???? ????? ?? ?????? ???? ?? ??????? REG_MULTI_SZ.

?? ????? ?? ?????? REG_MULTI_SZ ???? ??, ?? ???? ?? ???????? ?? ????? ??????? ?? ????????? ???? ?? ??? ????? ?? ????? ?? ?? ?? ??? ?? ??? ?????? ??? ?? ??? re-create, ?? ?? ??????? ?? ??????

???

???? ID: 254593 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Enterprise Edition
  • Microsoft SQL Server 6.5 Enterprise Edition
??????: 
kbinfo kbmt KB254593 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:254593

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

 

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