Is there anyway to create users with the correct Windows AD ID cases
so that I'm not having to figure it out then modify the logins for
each AD ID user?
Built in, you already found it -- use the directory searching interface in the GUI. Alternatively, you could use SQL CLR (as mentioned), or write a PowerShell script. You could certainly write a routine to clean up an instance using either method.
Note that the GUI rewrites the domain name, even if it's incorrectly cased when entered, but not the login name itself. (You can see this by manually typing something in, then hitting the Script button.)
But it was returning all lowercase for me, yet all uppercase when I
asked the user to run SELECT SUSER_SNAME() and give me the result. The
correct is all uppercase (...).
Under impersonation, SUSER_SNAME()
returns the principal name as entered. If you try the test again with a different casing, it will return the exact name you typed in. The only reason the impersonation works using an incorrectly-cased name is because the Windows collation says the comparison of the two is a match.
Not under impersonation, there are two cases: (a) group login: the principal name is returned from what Windows supplies, which is always correctly-cased, and (b) individual login: the principal name is returned from what is entered for the name in SQL Server (it doesn't go out to Windows to double-check).
Now, having said all that, try as I might, I cannot replicate this problem using 2008 R2 management tools. If you're still running 2008 (non-R2) management tools, one option would be to try upgrading the tools, because this appears to be a bug in Management Studio itself.
Best Answer
Yes, it is there correctly. You have run CREATE LOGIN correctly.
The number of stars in the SSMS box is just a mask and is unrelated to your actual password. SSMS doesn't know or try to read your password from the server
Note that SQL Server doesn't store your password so it can't relate to the
****
in SSMS anyway. SQL Server hashes it into thepassword_hash
column of sys.server_principals