# SalesLogix 6.x, 7.x - SQL

This connector allows you to connect to SalesLogix 6.x and 7.x running 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 OLEDB driver installed on the system you are running on.

NOTE: If you have the version 7.0 OLEDB driver installed, you will NOT be able to connect to a 6.x database.

### SalesLogix Connection Settings

SalesLogix Server - Name of the SalesLogix server (not necessarily the same as the SQL Server)

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

SalesLogix Port Number - port number for connecting to SalesLogix server. Normally 1706.

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.