By definition the idea of logging in means denying entry to certain people . Your login mechanisms must not allow that . In practice your database must treat each entry in the username column and password column as unique and therefore refuse to create a second user account which is same as one that already exists. You could even do this in your .Net code.
Did you have a particular problem you were trying to solve so that i can give an example ?