Why can one instance create multiple SAS instances? Isn't it case insensitive?

Source: Internet
Author: User

Someone in the Forum asked if the SQL Server account can be case-sensitive. In fact, it is okay, but there are prerequisites.

 

Many people think that only passwords of SQL Server are case-sensitive, while SQL login accounts are case-insensitive. The default SQL Server login account is case insensitive, but if you install
If the server sorting rule is case-sensitive, the login account of SQL Server will also be case-sensitive (for SA accounts, you can create SA, SA, and SA ).

 

For example, my sorting rules are case sensitive:

 

Select
Serverproperty ('colation ')

------

Chinese_prc_cs_as

 

 

You can create four SAS instances:

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.