Wiki Admin

Location Connection for SQL Server - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Location Connection for SQL Server - DSS 6 | Data Source Solutions Documentation

Location Connection for SQL Server

This section describes the connection details required for creating SQL Server location in Data Source Solutions DSS. For information about the pre-requisites, access privileges, and other configuration requirements for creating SQL Server location, see SQL Server Requirements.

If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.

Field Description Equivalent Location Property
SERVER

Name of the server (host) on which SQL Server is running and the Port number or the instance name of SQL Server.

The following formats are supported for this field:

  • server_name : Specify only the server name and DSS will automatically use the default port to connect to the server on which SQL Server is running.
    Example: myserver
  • server_name,port_number : Specify the server name and port number separated by a comma (,) to connect to the server on which SQL Server is running.

    If the DSS version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, this format is required when using custom port for connection or when SQL Server Native Replicator Connection is defined.
    Example: myserver,1435

  • server_name\server_instance_name : Specify the server name and server instance name separated by a backslash (\) to connect to the server on which SQL Server is running.
    This format is not supported on Linux.
    Example: myserver\DSS6048
 SqlServer_Server
DATABASE Name of the SQL Server database. Database_Name
USER

Username for connecting DSS to the SQL Server database.

The login/user account used for connecting DSS to SQL Server database engine should be defined with SQL Server Authentication or Windows Authentication. If Windows Authentication is used for connecting to SQL Server database, the USER and PASSWORD field should be left blank (empty).

 Database_User
PASSWORD Password for the USER. Database_Password

Advanced Settings

Field Description Equivalent Location Property
LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH

Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system.

For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.		 ODBC_DM_Lib_Path
LINUX / UNIX ODBCSYSINI

Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system.

For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc.		 ODBC_Sysini
ODBC DRIVER Name of the user defined (installed) ODBC driver used for connecting DSS to the SQL Server database. It is recommended to leave this field empty, DSS will automatically load the correct driver for your current platform. Otherwise, select one of the available SQL Server Native Client options. ODBC_Driver
SQL Server Native Replicator Connection

If selected, disables the firing of database triggers, foreign key constraints and check constraints during integration if those objects were selected with not for replication. This is done by connecting to the database with the SQL Server replication connection capability.

If the DSS version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, when this field is selected, the database connection string format in SERVER must be server_name,port_number, the other two formats of the connection string are not supported. This port_number must be configured in the Network Configuration section of the SQL Server Configuration Manager.

If the DSS version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, when this field is selected, encryption of the ODBC connection is not supported.

 SqlServer_Native_Replicator_Connection