Server configurations
- The authentication mode needs to be set to "Mixed Mode", if you are using SQL Server authentication.
- all front-ends and controller must use the same domain as the database server, when using Windows Authentication.
- The collation of the SQL Server instance must be case-insensitive (CI_*).
- The collation of the database catalog must be Case Insensitive and it should also be Accent Insensitive.