A Windows ID (such as MyDomain\someuser) will have a unique SID (such as S-1-5-21-1695517229-881958489-217698969-1001)
The ID is used during login, which confirms that it too is unique in nature.
What's the purpose of the SID then?
Seems like a redundant primary key to me!