SQL Server Performance Forum – Threads Archive
Problem installing SQL2000 into W2003 cluster
Hi I had headaches as I was two days trying to install SQL 2000 in the cluster and I had no luck at all…. Configuration is active/passive cluster. My problem is when trying to install SQL, just after select the unit to store the databases and then, username and password, installation closes suddenly and SQL doesn’t install. I am using a new-created account (SQLADMIN) and it belongs to local administrator (in both nodes) and domain administrator. Anyone can help me? Thanks a lot in advance, Julio/InvokerHave you looked at the Microsoft white paper on SQL Server clustering. If not, you need to walk through that document. It does a really good job of walking you through it. Run a search as msdn.microsoft.com for sql server clustering white paper. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
I have a step-to-step installing SQL guide. Cluster is properly configured. I have seen in the SQL’s installation Log, and these are the last lines, any if I look for any information regarding this, I found nothing at all:
15:42:10 Begin Action : ValidateNodeActions
15:42:10 Begin Action : ValidateNodeActions
15:42:10 End Action : ValidateNodeActions
15:42:10 End Action : ValidateNodeActions
15:42:10 End Action DialogShowSdClusterDef
15:42:10 begin ShowDialogsUpdateMask
15:42:10 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
15:42:10 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
15:42:10 Dialog 0x10000 returned: 1
15:42:10 End Action ShowDialogsHlpr
15:42:10 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
15:42:10 Begin Action ShowDialogsHlpr: 0x20000
15:42:10 Begin Action : Cluster Security – DlgAcct Here is when finish, and exits suddenly. I’m sure I’m using a domain account with admin privileges. So, I don’t know what more to do. Any more ideas? thanks, Julio/Invoker
Make sure you are not installing the cluster through terminal services or have terminal services installed in full mode on the servers. Connect to the console to install. See:
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed
http://support.microsoft.com/?id=301520 and:
PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microsoft.com/?id=815431 The following should show up after your last step:
10:50:04 Begin Action : Cluster Security – DlgAcct
10:50:16 ShowDlgAcct returned: 1
10:50:16 [DlgAccount]
10:50:16 Domain = SID
10:50:16 DomainAcct = clusteradmin
10:50:16 DomainPwd
10:50:16 Result = 1
10:50:16 End Action : Cluster Security – DlgAcct
10:50:16 begin ShowDialogsUpdateMask
10:50:16 nFullMask = 0x1bf7c037, nCurrent = 0x20000,
nDirection = 1
10:50:16 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
10:50:16 Dialog 0x20000 returned: 1
10:50:16 End Action ShowDialogsHlpr
etc….
… Do you see the dialog window that ask for the cluster administrator account at all? And is the remote registry service running on both nodes?
]]>