Is Logins in SQL Server are case sestive RRS feed

  • Question

  • Is Logins in SQL Server are case sestive??

    SQL Server Collation --> Latin1_General_BIN --> what is this collation properties??

    EG: create 'test' user as SQL login

    If you tried to login by 'Test' it is not allowing to login you. only 'test' is allowing to login.


    Satish Kumar.

    Thanks, Satish Kumar.
    Monday, January 10, 2011 8:20 PM


All replies

  • Collation Latin1_General_BIN is case sensitive. so when you create login test and try using Test it will not work
    Monday, January 10, 2011 10:59 PM
  • As Yogeh mentioned, its due to the server collation.
    To change server collation you need to rebuild the master database.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    This posting is provided "AS IS" with no warranties, and confers no rights.
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, January 11, 2011 1:21 AM
  • Hi All,

    Thanks for your replies...

    I too know Collation Latin1_General_BIN is a case sensitive... Re-Build Master database is little bit panic...

    I am looking for any MS article on explaing collation properties...


    Satish Kumar

    Thanks, Satish Kumar.
    Tuesday, January 11, 2011 10:08 AM
  • Start here http://msdn.microsoft.com/en-us/library/ms187582.aspx Regretably the SQL Server Books Online writers are pretty much English only people, so though we know about collations, but we don't have much practical experience. Feel free to stick any advice into the SQL Server TechNet Wiki http://social.technet.microsoft.com/wiki/contents/articles/sql-server-overview.aspx That's a great area for community generated content.
    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    Tuesday, January 11, 2011 4:57 PM
  • Hi Rick,


    One more question to you...


    "Use standard code page CP 1252" --> stands for which collation in SQL Server.. I am thinking " SQL_Latin1_General_CP1_CI_AS " suits for this.


    correct me if any thing wrong here...



    Thanks, Satish Kumar.
    Wednesday, January 12, 2011 1:31 PM