It sounds like your database server is not in a domain -- thus, it only offers you the one choice for login, that one choice being its local SAM. (* Unless it is a DC; that's a rather unusual case.)

If your database server is indeed not in a domain, then you will only be able to create windows logins that exist in the local SAM.