Can not install SP4 for SQL Server 7.0 on Win2k

In my case this is a SP4 install on a reinstall of SQL 7.0 with no user data
bases.
I have followed all the tips about turning off all non-essential services, e
tc., per the kb article and various other docs, but the 7.0 sp4 installation
still fails with the message
"One or more of your user databases have been marked read only, offline or s
uspect (not recovered). Correct the problem and restart setup."
The log files seem to show everything is ok but the install still fails.
I did try one additional test -- running the scm and osql commands shown at
the end of the sqlsp.log file.
When I ran the osql command, I get the expected results of 0 but also get an
additional message for the ODBC driver manager: "The driver doesn't support
the version of ODBC behavior that the application requested (see SQLSetEnvA
ttr)."
I suspect that this additional message is causing the failure.
(Running on W2k / SP4).
-- Vikram Jayaram [MS] wrote: --
* Look at the sqlsp.log for error messages
* It's a good idea to turn off all 3rd party and non-essential services
before you prform the Service Pack upgrade.
Thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.How are you installing the setup for sp4. What does the sqlsp.log say? Are
you sure there are no other sql70 instances on the box?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.