Connection strings
The application will read two connection strings from the FuseIT.SDDMS.exe.config file:
...
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.
| Code Block | ||
|---|---|---|
| ||
<add name="SqlAdminConnectionString" connectionString="Server=PC01\SQLEXPRESS; Database=SDDMS_Test; User Id=Admin; Password=sqlPassword;" /> |
At least one connection string is required.
One for creating a Salesforce session and another to connect to the SQL Server database if this functionality is required.
| Code Block | ||
|---|---|---|
| ||
<connectionStrings> <add name="SqlAdminConnectionString" connectionString="Server=PC01\SQLEXPRESS; Database=SDDMS_Test; User Id=Admin; Password=sqlPassword;" /> <add name="SalesforceConnectionString" connectionString="G4S:user id=sfdcuser@example.com;password=examplePassword;token=YYB00TokenExampleBwENRKwCSZ;environment=Production"/> </connectionStrings> |
Make sure that the 'SqlAdminConnectionString' has got the user id of a user with administrator privileges.
Specify the details of your Salesforce account in the 'SalesforceConnectionString'.
If you want to use file stream to store files in SQL Server, please make sure you have enabled FileStream on SQL server.