Can't create Windows Login's on a case sensitive SQL Server 2005 Instance - MSG 15401

Question

I need to create 3 logins on a SQL Server 2005 instance:

However two of them (aaa and bbb) fail with the following error:

Msg 15401, Level 16, State 1, Line 5 Windows NT user or group 'DOMAIN\aaa' not found. Check the name again.

When I try to add them with DOMAIN\AAA and DOMAIN\BBB it works.

What is causing this strange case sensitive behaviour? And how can I add all accounts lower case?

I found a KB article from Microsoft for the 15401 error, but nothing in there explains this behaviour.

I had the same issue once. I think I was able to change the collation at the DB level and this fixed the problem. Let me check the server again, and I will let you know. — StanleyJohns, Aug 23, 2011 at 1:10

gbn · Accepted Answer · 2011-08-22 15:30:49Z

4

You will have "CS" in this result:

 SELECT SERVERPROPERTY('Collation')

answered Aug 22, 2011 at 15:30

gbn

69.6k8 gold badges161 silver badges242 bronze badges

Well since it's a commercial product, this is not my choice and I can't go and change the collaction. I try to understand where this behaviour comes from and especially why some login's seem to be different from others.
– nojetlag
Aug 24, 2011 at 6:46

Add a comment |

1 Answer 1