Submitted a support call to microsoft and they responded:
Entity Framework v2 doesn’t support sql 2000
Here is there response:
Thank you for posting this bug. Unfortunately, a business decision was made to no longer support SQL Server 2000 in this scenario.
So no support for sql 2000 in entity framework v2 in .net 4.0