Maybe a little bit of both?
ms sql server can be installed as case sensitive or case insensitive. You may have to recreate the database as described at
. Or, you can try changing it with the example at
. In the example, the CI is case insensitive; case sensitive would be CS.
Either way, assuming a case insensitive setting seems bad...
nice. i changed the default collation to something case insensitive and it's all good now.