It sounds like your birthday was a trigger for your because of bigger problems in the relationship. If this was just about your birthday, I’d suggest that you take the lead and ask him to take you shopping for your birthday or show him something you want and ask him to buy it for you or ask him to pick up a cake — some people would be fine with a funny card or dinner at a restaurant, and it takes some time for couples to get their “birthday needs” met, if they have different historical traditions…. but it sounds like there’s more going on here than just your birthday. 😕
He’s got a drinking problem and you’re trying to live a sober life — that’s a big gap in lifestyles! You want family pictures and meaningful birthdays and he’s resistant. After two years together, it’s pretty clear that he’s not who you want in a partner and you’re banging your head against the wall trying to get him to be someone he’s not. I can feel your frustration, but the ball is really in your court. You’re not married. It’s only been two years together — I think it’s time to get out and find a partner who is compatible with what you want for yourself and your kids. I hope that helps. 🙂