I'm experimenting with using the Asp.Net SqlMembershipProvider, and am noticing in the aspnet_Membership table that the PasswordSalt field has the exact same value for every entry. Now, I am using the same password for every user in my testing, but this seems wrong. In production, if two users were to use the same password, that should be indistinguishable in the database because the password hash and salt should be different.
In the web.config membership section, I have passwordFormat="Hashed" set in the provider options.
What am I missing?