# SalesLogix 5.2 SQL

This connector allows you to connect to SalesLogix 5.2 on SQL Server.

You need to specify a connection to BOTH SalesLogix and SQL Server - there is one tab for each.

You must have the SalesLogix BDE alias settings established on the system you are running on.

### SalesLogix Connection Settings

BDE Alias - Name of the BDE Alias configured on your system.

SalesLogix User Name and Password - this is a SalesLogix user, not SQL Server user. Must have admin rights in SalesLogix.

Get SalesLogix Connections - this will query the OLEDB provider for the available SalesLogix connections and load them into the 'SalesLogix Connection Alias' drop down.

SalesLogix Connection Alias - select the correct alias from the list, then click 'Establish Connection'

### SalesLogix Default Settings

The default setting are used when creating new records in SalesLogix. These defaults CAN be overridden at run time.

Default Account Manager - Account Manager who will be allocated any Accounts created. See also slxSetAcntMgr().

Default Owner - Owner of any records created. See also slxSetOwner().

Default Branch - When a file is uploaded, the correct branch must be used.

Use Direct Connect - if you select this option, the OLEDB provider will be bypassed. NOTE - this will mean that all records created will NOT synchronize to remotes.

### SQL Server Settings (second tab)

SQL Server name - the name of the SQL Server instance hosting the SalesLogix database.

User Name and Password - the login to use to log into the SQL Server. Must have rights on the SalesLogix database. Normally use 'sysdba'.

Database - select the database holding the SalesLogix data. NOTE - this must be the same database as the one used by the SalesLogix Connection Alias selected on the SalesLogix Settings tab.