- May 20, 2019
- Posted by: scanstore
How do I connect to an SQL Server database?
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.