Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


Q: Can SQL Server 2000 be installed on Windows 2003

Answer:

Well the answer is a simple "YES".

But having said that we do have some pre-requisites for the same. You will have to first install SQL2000. A warning message may come up saying that SQL Server2000 SP2 or lower is not supported on Windows 2003.But thats just a reminder for you to apply SP3a or later.

When you first install SQL it will disable all network libraries except shared memory, preventing remote connections. Applying SP3a will re-enable them.

Make sure its not Win2k3 Web Edition as the only version of SQL allowed on that is MSDE2000 SP3(a).