| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-07-29 : 14:15:47
|
| Does anyone know why I am not able to install SQL2000 Enterprise on ACTIVE-->ACTIVE cluster node on win2003. I'm able to install fine on the first node, but when I go to install it on second node to make it active-->active, I am unable to do so. The logs don't show me much and tried everything possible like removing terminal service, etc... Still a no go.thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-29 : 14:19:51
|
| To use SQL Server 2000 on Windows 2003, you must also install service pack 3a for SQL Server. The installation of SQL Server 2000 will say that you can't use it on Windows 2003, but it still lets you get past that error and install it. After installing it, you immediately install sp3a which is what allows SQL Server 2000 to function on Win2k3. So what error are you getting?Tara |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2004-07-29 : 14:27:50
|
Below is part of the sql.log file and it hangs after it is performing operations on cluster nodes. I couldn't make much out of it....12:42:15 Setup is performing required operations on cluster nodes. This may take a few minutes...12:42:15 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini12:53:25 Process Exit Code: (2) The system cannot find the file specified.12:53:25 Begin Action : GetRemsetupRetCode12:53:25 Installation return status on ZBRBPDB11 : 012:53:25 Installation return status on ZBRBPDB10 : 212:53:25 End Action : GetRemsetupRetCode#### SQL Server Remote Setup - Start Time 07/29/04 12:42:15 ####CThreadPool::RunUntilCompleteHlpr create thread, index=0CThread::Run thread [0x94] created for execution.CThread::Process [0x94]CThreadPool::RunUntilCompleteHlpr create thread, index=1Running '\\ZBRBPDB11\C$\SQL200~1\x86\setup\setupsql.exe k=Nb k=Rm k=Cl -SMS -s -f "\\ZBRBPDB11\C$\SQL200~1\x86\setup\setup.ins" -f1 \\ZBRBPDB11\admin$\ZBRBPDB11_BRBPDB11INST.iss -f2 "\\ZBRBPDB11\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"' (ZBRBPDB11) ...CThread::Run thread [0x98] created for execution.CThread::Process [0x98]CThreadPool::RunUntilCompleteHlpr start thread [0x94],index=0CThreadPool::RunUntilCompleteHlpr start thread [0x98],index=1Script file copied to '\\ZBRBPDB10\ADMIN$\ZBRBPDB10_BRBPDB11INST.iss' successfully.Installing remote service (ZBRBPDB10)...Running '\\ZBRBPDB11\C$\SQL200~1\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f "\\ZBRBPDB11\C$\SQL200~1\x86\setup\setup.ins" -f1 \\ZBRBPDB10\ADMIN$\ZBRBPDB10_BRBPDB11INST.iss -f2 "\\ZBRBPDB10\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"' (ZBRBPDB10) ...CProcess::RunUntilComplete [0x94] exit code: 0Remote process exit code was '0' (ZBRBPDB11).CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0CThreadPool::RunUntilCompleteHlpr signaled thread [0x94]Thread [0x94] exit code: [0x0]CRemoteProcess::RunUntilComplete [0x98] exit code: 2Remote process exit code was '2' (ZBRBPDB10).CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0CThreadPool::RunUntilCompleteHlpr signaled thread [0x98]Thread [0x98] exit code: [0x2]CThreadPool::RunUntilComplete returned 2CThreadPool::RunUntilComplete execution level=1, need execution: 0One or more errors occurred while running the remote/unattended setups.Disconnecting from remote machine (ZBRBPDB11)...Service removed successfully.Remote files could not be removed.#### SQL Server Remote Setup - Stop Time 07/29/04 12:53:10 ####Disconnecting from remote machine (ZBRBPDB10)...Service removed successfully.Remote files removed successfully.quote:
Originally posted by tduggan
To use SQL Server 2000 on Windows 2003, you must also install service pack 3a for SQL Server. The installation of SQL Server 2000 will say that you can't use it on Windows 2003, but it still lets you get past that error and install it. After installing it, you immediately install sp3a which is what allows SQL Server 2000 to function on Win2k3. So what error are you getting?Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-29 : 14:35:52
|
quote:
One or more errors occurred while running the remote/unattended setups.
Are you running it remotely or unattended? If so, I would try it from the console.Tara |
|
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2004-07-29 : 16:21:37
|
| same errors and same error log when trying it from console... This thing is driving me nuts..... Any help is appreciated.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-29 : 16:22:48
|
| I'm out of ideas. I would suggest contacting MS if no one else is able to help:800-936-3100Tara |
|
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2004-07-30 : 09:46:09
|
Just one more thought I had and I may be doing this wrong. When I installed SQL on my first node, I chose the program files to go on C: drive which is not a shared drive (not in cluster), and my Data files to go on E: drive which is a shared drive(in cluster) which can failover to my second node. Do you think this is a problem. I mean should I be installing both program and data files on the same drive and should that be on a clusterd drive..Thanks,Jayquote:
Originally posted by tduggan
I'm out of ideas. I would suggest contacting MS if no one else is able to help:800-936-3100Tara
|
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-07-30 : 10:06:09
|
| The program files are installed locally to each machine, data files (master db etc) need to go on a shared cluster drive.-------Moo. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-30 : 12:20:17
|
| No it's not a problem as mr mist mentioned. But I wouldn't install applications on C. C should be reserved for the OS. We have another local drive, E for applications. Then we've got SAN drives, F, G, and H on each of the database servers. F for MDFs, G for LDFs, and H for backups.Tara |
|
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2004-08-04 : 09:49:14
|
| OK, After searching through so many articles on Microsoft site, I came across one which helped me install it. I basically had to stop all the unneccessary services on all my nodes in order for me to install SQL2000 instances on Win2003 cluster enviorment..Thanks for all the feedback..Jay |
|
|
|
|
SQL Install