Skip to Content
Author's profile photo Former Member

DB connectivity from Linux to SQL Server (DBCO)

Hello all,

I want to provide you the required steps (with the help of my colleagues from team) in order to create a connection between a SAP system running on Linux (SuSe in my case) and external SQL server. For the SAP system level configuration (DBCO transaction entry needed), you can check the note 178949 – MSSQL: Database MultiConnect . Main note for this activity: 1644499 – Database connectivity from Linux to SQL Server

My Linux version:

root-> cat /etc/SuSE-release

SUSE Linux Enterprise Server 11 (x86_64)



1- Check you SAP Kernel, if file is in place. Make sure that mentioned packages in the note already installed:

root-> cd /sapmnt/SID/exe/uc/linuxx86_64/

root-> ls -ltr

-rwxr-xr-x 1 sidadm sapsys 1820217 Oct 30  2015

root-> rpm -q glibc



2- Download ODBC Driver from this address:

3- Download unixODBC component from this address:

4- Create a temporary directory and copy those 2 downloaded files there. Then extract and build in following order:

root-> mkdir /tmp/MSSQL_ODBC

root-> gunzip msodbcsql-11.0.2260.0.tar.gz

Copy unixODBC under the new folder:

root-> cp unixODBC-2.3.0.tar.gz ./msodbcsql-11.0.2260.0/

Build it:

root-> cd ./msodbcsql-11.0.2260.0

root-> ./ –download-url=file://unixODBC-2.3.0.tar.gz


5- Install unixODBC:

root-> cd /tmp/unixODBC.10010.13772.354/unixODBC-2.3.0

root-> make install

Making install in extras

make[1]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras’

make[2]: Entering directory `/tmp/unixODBC.10010.13772.354/unixODBC-2.3.0/extras’

make[2]: Nothing to be done for `install-exec-am’.

root-> ./ verify


root-> ./ install –force


Check if ODBC properly installed:

root-> odbcinst -q -d -n “ODBC Driver 11 for SQL Server”

[ODBC Driver 11 for SQL Server]

Description=Microsoft ODBC Driver 11 for SQL Server




You can execute ADBC_TEST_CONNECTION report for testing the connection:


Other useful links and even a video from SAP:–by-the-sap-hana-academy

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.