How do I connect to an SQL Server database?

You are here:
  • KB Home
  • How do I connect to an SQL Server database?
< Back

On the Database tab, choose “SQL Server” from the drop-down labeled “Configure Data Source”. Click the “Start” button.

You will be prompted to enter the SQL Server name and database name. Once selected, an OLE DB data source will be entered under “Data Source”.

You can add a default user to the “Data Source” using the conventions for OLE DB provider strings. With this configuration, all users will use the same SQL Server login. To configure individual logins, check “Require Logon” on the Logging tab. If you would like the users to select their name from a list, add each user ID using the “Add User” button.