Equal rites / Pratchett, Terry

When a wizard tries to pass on his powers to an eighth son of an eighth son, he discovers too late that the son is actually a daughter.

A dying wizard is trying to pass on his powers to the son of an eighth son, who is just being born, when it's discovered that the son is actually a daughter. But the discovery comes too late--the powers have gone to her.