Connections > Microsoft SQL Server connection properties > Using special characters in the password
  

Using special characters in the password

When you use SQL Server authentication to connect to Microsoft SQL Server, you can use the following special characters in the password for the database user name:
To use these special characters in the password, you need to set the EnableMSSQLPasswordSpecialChars custom property in the Secure Agent properties.
To configure the custom property in the Secure Agent, perform the following steps:
  1. 1Log in to Informatica® Intelligent Data Management Cloud™ (IDMC).
  2. 2Select Administrator > Runtime Environments.
  3. 3On the Runtime Environments page, select the Secure Agent.
  4. 4Click Edit.
  5. 5In the Custom Configuration Details section, select Data Integration Server as the service and DTM as the type.
  6. 6Enter EnableMSSQLPasswordSpecialChars in the Name field and set the value to true.
  7. 7Click Save.