When migrating our MS SQL 7.0 database from one server to another, I’m getting failure during the SQL install. This is a clean server, 512MB of RAM, 40Gb of disk space, NT 4.0, sp-6a, dual processors. Going through the SQL setup log, the InstallPkgs process completes successfully. However, in the BuildServer portion of the install, there’s an error message “unable to update path variable – RegDBGetKeyValueEx”. When cnfgsvr.exe tries to run with user sa and no password (default?), the process exit code is (-1) and the message “Setup failed to configure the server…refer to error logs for more info…”
Is there any chance this failure is due to something really simple like using a domain account to start services on boot or a conflict with a second server on my network domain with the same with the same registration code used during setup? The sqlstop.log tells me the CDKEY VALIDATED, and the cnfgsvr.log tells me “an error occurred while attempting to start the service” (5)….not much to go on. We didn’t have any problems with our intial install on the other server – a platform with considerably less available resources.
I’ve gone so far as to manually delete all the SQLSERVER entries manually from the registry and it doesn’t seem to make any difference – the install craps out at the same point everytime.
I’m installing to a large NTFS partition instead of the default boot partition, but we’re consistent with this and it hasn’t been a problem in the past either.
Ideas?