Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
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

2 Answers 2

up vote 8 down vote accepted

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.

share|improve this answer
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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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