Characters to avoid while setting up Database ID or Password

|
Published

EUM has to access the database and uses connection strings to do that. Certain characters in the database ID or password play foul in this process. For a smooth operation please avoid these characters in the database ID or password:

  1. Special Character " (double quotation mark)
  2. Special Character ' (single quotation mark)
  3. Special Character / (escape)
  4. Special Character \ (escape)
  5. Special Character ; (semicolon)

Azure best practice for naming SQL Server and Database:

  1. Only small letters allowed
  2. Only numbers and letters allowed