Adding Connection String

Owned by FuseIT OA
Last updated: Feb 03, 2023 by Karl Tompson

IMPORTANT: To meet Salesforce security policies you should:

  • Remove/rename default accounts and change default passwords
  • Encrypt all passwords
  • Implement a robust application password policy
  • Minimum 6-8 characters
  • Combination (2 out of 4) of numbers, letters (lower and upper) and special characters


Add a connection string to the S4S system Web service to the <connectionString> element of App_Config/ConnectionStrings.config. 

For all Salesforce environments the connection string should look like:

<connectionStrings>
  <add name="S4SConnString" connectionString="S4S:user id=user;password=password;environment=mycompany.my.salesforce.com" />
</connectionStrings>

The <connectionStrings> element can have a number of connection strings defined. Each one is defined by the <add> tag. This element has a number of attributes but we use only two: 

Attribute

Description

Name

The name of the connection string. Any entity using this connection string will address it by this name.

connectionString

The connection string itself.

The S4S Security Provider module supports the following format of a connection string:

  • Each string starts with the “S4S” prefix.
  • The prefix is followed by the login credentials for the Salesforce partner API.

The login credentials and environment settings are then specified using the following: 

Key       

Description

user id

The Salesforce username that will be used to establish the Partner API session

password

The password for the Partner API user.
If the servers IP address isn’t trusted by the Salesforce Organization being connected to the user's security token can be appended to the password.

token

(Optional) As an alternative to appending the user's security token to the password in the connection string, it can be defined separately to provide the same functionality. Learn more about how to reset and get your security token.

environment

The domain for the Salesforce environment being connected to. This should be the My Domain domain for the Salesforce org. More information

Example connection strings:

S4S:user id=<user_name>;password=<user_password>
S4S:user id=<user_name>;password=<user_password><user_security_token>
S4S:user id=<user_name>;password=<user_password>;token=<user_security_token>
S4S:user id=<user_name>;password=<user_password>;environment=<binding_environment>


Next Step

CD/CM Considerations

Steps