The application will read two connection strings from the FuseIT.SDDMS.exe.config file:
SalesforceConnectionString: The connection string for connecting to the Salesforce Partner API. The Salesforce user should have sufficient permissions to extract meta data about any Salesforce object that should appear in the SQL database e.g. specify the Salesforce User with PartnerAPI access as follows:
<add name="SalesforceConnectionString" connectionString="G4S:user id=user@fuseit.com;password=passwordHere;token=xkTOKENURUmmDTTTiw8i8fG9i;environment=Production"/>
The security token will automatically be appended to the password. The environment setting can be set to “Sandbox” if access to a testing environment is required.
SqlAdminConnectionString: The connection string for connecting to the SQL Server 2008/2012 instance. The SQL user should have sufficient permissions to drop and recreate the database.