You might have to activate the cd key in steam?
Go to Games -> Activate a product on Steam and insert the cd key there
I think Steam doesn't ask the key, you have to do it manually. That's how I installed the original Company of Heroes that I have on cd and it worke just fine.