Our server name is 'NC-Coleman', so when I went to the server and created a new login for me, I was able to type into the name field 'NC-Coleman\KevinM', and it worked fine.

When I try this, I get "Invalid syntax near '-'"

CREATE LOGIN NC-Coleman\KevinM PASSWORD = 'mypw'

I have also tried:

CREATE LOGIN 'NC-Coleman\KevinM' PASSWORD = 'mypw'

with the same result.

Can someone set me straight?

Thanks