?? ???? ???? SQL Server ??????? ??????? ??, ?????? ????? ???????? ?? ??? ???? ?? ??? ???????? ?? ??????? ?????? ????? ??? ???????? ??? ?? ??? ??????? ?? ???? ???? ?? ???? ?? ???? ?? ?? ???????? ?? ???? ??? ??????? ??????? ?????? ???? ??? ?? ???????? ?? ??? ??????? ?????? ????? ???? ???????? ?? ???????, ????? ?????? ?? ?????? ?? ?????? ????
???:SQL Server 6.5 ?? 7.0 ??????? ?? ??? ?????? SQL Server 2000 ?? ??? ???????? ???? ????? ???? ?? ?????? ??? ??? SQL Server 2000 ??????????? ??????? clustering failover ?? ????? ?????, ???????? ?? ??? ??????? ???:
- Microsoft ??? ???? (????? ???)
- ?? ?? ???? ????????
- SQL ????? ?????????? ???????
- ???? ???????? ???????
- ???????????
- SQL Profiler
- SQL ?????? ????????
????? ????? ?? ???? SQL Server ??????? ?? ??????? ?? ????? ???? ????????:
- ????, SQL ??????? ??????? ????? ?? ?????? ???? ?? ?? ?? ??? ??????? ?? ????????? ???? ????? ?? ??? ?? ??????? ????
??????? ??????
???? ???? ??? ?? ????? ?? ?? ?? ???? thing ?? ???? ??? ???? ???? ?? ???? ??, ?? ??????? ???? ??? ????? ?? ?? ??????? ??? ?? ???? ????? ?? ???? ???? ?? ??? ?????? ??? ??? ?? ????????? ??????? ?? ???? ??????? ?? ????? ??????? ????? ?? ??????? ???? ?? ??? ???????
???????????
?? ?????? ?? ??? ???? ?? ??? ????? ?????? ?? ???? ????? ?? ?? ??? ??? ??????? ???????? ????? ?? ???? ?? ?????? ????? ??? ??, ?? ???? ???? ?? ????????? ???? ?? ??????? ????? ?? ??? ????????? ??????? ?? ???? ??????? ????? ??????? ???? - ?? ?? IP ??? ?? ??????? ??? ???? ????, ??????? ?? ????? ???? ??? ??????? ?????? ????? ?? ?? ??? ??????? ?? ???? ?? ????? ?? ????? ?? ??? ?? ?????? ???? ???
???:?? ?????? ????? ??? ?? ???? ??? ????? ??? ?? ?? IP ??? ???? ????, ?????? IP ??? ?? ???? ??? ????? ????? ???? ???? ??? ???
??????? ??????
??? ?? ??? unclustered ?? ?? ????? re-clustering ???, ???? ?? ?????? ????? ????? ?? ???? ??????? ??? ????? ??? ?? ??????? ?? ???? ?? ?? ?? ?? ???? ?? ??????? ??????? ??? ?? ??? ?? ??? bios ??????? ?? ??????? ?? ??? Windows NT ???-??? ???? ???
???? ???????????
?? ????? ????????? ????? ?????, ?? ????? ???? ???? ????:??? ????????? ?????. ?????, ?? ??? ?? IP ??? ?? ????? ?? ?????? ????? ??? IP ??? ????? ???? ??, ????? ?????? ???? ?? ??? ?? ?????
????? ???????????
?????? ????? ????? - ?? ??? ??????? ???? ????, ?? ??? ??????? ????????? ??? 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
???? ???????????
"??????? ????????" ??? ???????? 8 ?? ??????? ????
????? ???????????
3 ??? "??????? ????????" ??? ???????? ?? ??????? ???? - ????, 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 ????
- ??????? ?? ????? ????? \System32 ?????????? ?? ??? ??? ??????? ??????? ??????? ??????????
??????? ??????
???? ??????? ??? ??, ?? ??? ???? ???????????? SQL ??????? ??????? ???????? ?????? CD ?? ??????? ???? ??, ????? ?? ?? ?? ???? ?? ???? ???? ?? ??? ??????? ?? ???? ?? ?? ???? ??????? ?? ???? ?? ????? ?? cluster_tools_share ?? ????? ??? ?????? ???? ???
???????????
3 ??? "??????? ????????" ??? ???????? ?? ??????? ???? - ??????? ?? "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 ??? ?? ?? ??? ???????? ?? ??? ????? - ????, 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 ???? ??????? ???? ???? ??? ?? ????? ????????? ???? ??:..????????? ?????? ???? ?? ???...
248380
(http://support.microsoft.com/kb/248380/
)
SQL PRB: 7.0 ??????? ?? ????????? ?????? ???? ??? ?????? ??????? ??????
???? ??????? ?????? ?? ?? ?? ??? ?????? ?????? ????? ??? ????
?? ??? ?? ??? ?????? ???? ?? ?? ??? ?? ?????? ?? ?????? ???? ???? ?? ??? ??? ???: ?????? ???? ?? ??? ??? ?? ????????? ???? ?? ??? ????? ?? ????? ?? ????????? ?? ???? ???? ??? ?? ????? instantaneously ????????? ???? ??, ?? ????? ???? ????? ?? ?? ??? ?? ?? ??????? ???????? ?? ??? ????? ????? ??? ??, ????? ??????? ?? ??? ?? ??? ????? ???? ??, ???? ??? ?????? ?? ?????? ??? ??? ?? ???
???????????
????? ?? ?? ???????? ??? ?????? ????? ?? ?? ?????? ?? ?? ?? ???? ???, ?? ????????? ???? ?? ???? ??? ???? ???? ????????? ??? ?????? ?? ?? ???? ?? ?????? ???? ?? ??? ???? ????? ???? ???? ?? ??? ????? ?????? ?? Microsoft ???????? ??? ?????:192708
(http://support.microsoft.com/kb/192708/
)
INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
219264
(http://support.microsoft.com/kb/219264/EN-US/
)
INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
??????? ??????
??? ?? unclustering ?? ?? ?????? DLL ??? ?? ?? ?????, ?????? DLL ??? ?? ????? ?? ???? ??????? ?? ??????????? ?? ??? ?? ??? ?? ???? ??? ?? ?????? ?????? ????????? dbnmpntw.dll ????? ?? ?? ?? ?????? ?? ??????? ???? ?? ????? ?? ??? (Resrcmon.exe) ?? ???? ???? ???
???? ???????????
????? ???? ?? ?? ??????? ???? ???? ?? ??? ??????? ?? ??? ?? ??????
????? ???????????
Dbnmpntw.dll.copy ???? ?? ??? ???????? DLL ?? ??? ?????, ?? ???? ??? ?? ??? ??? ?? ????????? ?????? ?? .Copy ????? ????? ??? ?? ????? dbnmpntw.dll ????? ?? ????, ????? ???? ?? ?????? ?? ???? ???????? ????? ?? ???? ??? - 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 ???????? ?????? ??? ??? ?? ?? ??? ??? ????:
192708
(http://support.microsoft.com/kb/192708/
)
INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
219264
(http://support.microsoft.com/kb/219264/EN-US/
)
INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
????? ???????????
Sqlsrv32.dll ????? ?? ??? ?????, ?? ???? ??? ???????? ????? ????? ??????????? ?? ??? ??, ???? ?? ???? ????????? ???? ?? ???? ??????? ?????? ??? ??? ??? ?? ????? Microsoft ???????? ???? ?????? ??? ??? ??:
192708
(http://support.microsoft.com/kb/192708/
)
INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
219264
(http://support.microsoft.com/kb/219264/EN-US/
)
INF: ?? SQL Server 7.0 Clustering ????? ?? ??? ??????? ????
????? ???????????
SQL ?????? ?????? ???? ?? ?????? ????? - 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
ProblemThe 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
ProblemWhen 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 and
sysdevicessystem 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
ProblemSetup 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. The
User Cannot Change Password, ??
Password Never Expirescheck boxes are copied.
???:When copying an account that is a member of the Administrators
local group, the
User 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 ???????? ???? ?????? ??? ??? ?? ?? ??? ??? ??? ??????? ?????? ???? ?? ?????:
192708
(http://support.microsoft.com/kb/192708/
)
INF: ?? SQL Server 6.5 MSMQ 1.0 Clustering ????? ?? ??? ??????? ????
219264
(http://support.microsoft.com/kb/219264/EN-US/
)
INF: ?? 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
(http://support.microsoft.com/kb/254593/en-us/
)
????? ?? ???? ????
