Does MSSQL 2000 run in VMware ESX? We are planning on going into a virtualized environment and are wondering if main production database will run in VMware ESX. We cannot upgrade the SQL version.

  • 3
    VMware what? VMware is a company which make several virtualization products. If you really want a VMware related tag on this question, please edit back in a product specific one as I have removed the [vmware] tag. – Ben Pilbrow May 11 '11 at 19:38

Yes, it runs just fine in VMware - hopefully it's a lightly loaded database server rather than a multi-terabyte monster!

Ideally, you'd want a fresh install of Windows and SQL Server 2000, but failing that a P2V will work. Brent Ozar refers to it as taking care of dinosaurs:




The only time I got caught out with this approach was when a SQL2000/Windows2000 box was cloned (P2V), and then taken from its original domain to a new domain. SQL got a bit confused as the servername is embedded during install.

  • Cool, our guys helping with the conversion we concerned about it. This restores my confidence, thanks. – Kratz May 11 '11 at 18:48

I've done this with dozens of legacy systems. Without fail, they run better in the virtualized environment (which is newer hardware). The flexibility to move between physical systems, free up (or preferably, retire) hardware, and consolidate is just great.

The dogma around SQL Server not playing well with virtualization amazingly still lingers, and is still misguided. Unless you're running on a type 2 hypervisor or have overcommitted resources, it's straightforward to make SQL Server play well with others.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.