Connection String for SQL Server

This page describes how to specify a connection string for SQL Server.

Entries into the Sensitive Part field will be stored encrypted in Salesforce. If you want to secure the username also, include it in the field separated by a semi-colon.

Overcast uses the .NET Framework Data Provider for SQL Server and thus uses the following connection string syntax.
The <hostname> can be either an IP address or a hostname. Depending on the SQL Server configuration, you may need to include the instance name.

Format

Enter the following text into the Connection String field

Data Source=<hostname>; Initial Catalog=<database>; User ID=<username>;

Enter the following text into the Sensitive Part field

Password=<password>;

Sample

Enter the following text into the Connection String field

Data Source=db1.mycompany.intranet; Initial Catalog=development; User ID=user33;

Enter the following text into the Sensitive Part field

Password=mypassword

When entering any password or username that uses whitespace, it should be enclosed in double quotes, i.e., User ID="user 77";

Data Source may require the instance name when multiple instances are hosted, i.e., Data Source=hostinstance1;

Each time you create or modify a connection string in Overcast, validate your connection by clicking the Check button to ensure the connection can be established successfully.

Parameter Keys

Key	Description
Data Source	IP address or hostname. May require instance name.
Initial Catalog	Database name
User ID	Username
Password	Password

1. Go to the Connection Strings tab and select the New button.

2. Enter a Connection String Name and select "MSSQL" for Connection Type. Enter your Connection String and its Sensitive Part as described above, and select Save. Description and Named Credential are optional.

3. Select Check to validate your connection. A green checked circle will appear once a successful connection is established.