It can but you will only be able to use 4 proces and 4GB of ram.


http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

--

Andrew J. Kelly
SQL Server MVP


"jeff" <jeffrey.merritt (AT) cma (DOT) ca> wrote

Jeff,

I thought you had SQL 2000 not 7.0. I don't know for sure if 7.0 EE can be
installed on 2KServer. My guess would be no and the error seems to support
that. I don't have 7.0 BOL anymore but what does it say in the Maximum
Capacity Specs sections?

--

Andrew J. Kelly
SQL Server MVP


"jeff" <jeffrey.merritt (AT) cma (DOT) ca> wrote

Hi guys. I believe SQL 7 EE requirement was that the OS had to be WINNT4
Enterprise, only the standard and small business editions can run on NT4
std.
For Win 2000 SQL 7 therefore requires the 2K Advanced Server edition.

This link suggests says as much
http://www.mssqlcity.com/Articles/Ad...0InstProbl.htm
(have confirmed the NT4E requirement in BOL7 as well)

This behaviour is a bit daft if you think about it, which is probably why MS
changed the OS requirement for SQL 2000 EE i.e. WINNT4 and 2K standard is ok
as well as NT4E and 2KAdv.
--
BR,

Mark Broadbent mcse+i, mcdba
_________________________
"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote