Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My hierarchy ask me to setup a production Windows server 2008 virtual machine (HyperV) with SQL 2000 Standard Ed. installed on it.

I can't find on the net much information about the relative "compatibility" of SQL2000 on WinSrv2008.
Of course I found some obscure answers like : "it's impossible, it's not supported, don't do it".

I already setup the machine, it's working, but... I don't know where I'm going.

Do you experienced this kind of configuration ?
Could you give me some advices ?
Could you tell me the pros and cons ?

Thanks a lot for you help

share|improve this question

1 Answer 1

Microsoft doesn't support SQL 2000 on Windows 2008 but that doesn't mean it won't work (as you've already found out). Of course, you could get it into production and then find some odd quirk that affects availability after the fact and if you called Microsoft about it, they wouldn't help much.

All that having been said, you said you're running this as a VM so the fact that the host server is running Windows 2008 has no impact on the operating system running in the virtual machine hosting SQL 2000. If it were me, I'd create a Windows 2003 R2 virtual machine and install SQL 2000 there so you have a supported and known-good configuration.

share|improve this answer

Your Answer

 
discard

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.