Hi @Zheng Shi ,
You can run the following query to check if a server is case-sensitive:
SELECT SERVERPROPERTY('COLLATION')
CI= Case Insensitive
CS=Case Sensitive
If there is indeed a issue about case-sensitive, you can change the collation of the database to case insensitive, for example:
If your collation is Latin1_General_CS_AS, and you want to change;
ALTER DATABASE test2 COLLATE Latin1_General_CI_AS
If you want to change the entire server's collation, you basically need to run the installation again to rebuild the master database
https://learn.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?redirectedfrom=MSDN&view=sql-server-ver15
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.