cancel
Showing results for 
Search instead for 
Did you mean: 

connection to mssql 2008 from sap on unix (solaris 10)

Former Member
0 Kudos

good morning all,

i want to make sure i am reading this right, but i do not think i can connect to a mssql server (2008) from sap if sap is using unix.

1601608 - How to access an external Microsoft SQL Server database

Remark:
If your system comprises solely of ABAP stack-based servers running on Unix / Linux platforms you can neither use UDConnect nor DBCON. Why? Because UDConnect requires at least one Java-stack based SAP Application Server (regardless of the operating system) and DBCON requires at least one Windows-based SAP Application Server.

if this is the case, how would a company connect to a sql server and extract data and use in a abap program? ftp?

any help is appreciated.

thx,

Erik

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member189725
Active Contributor
0 Kudos

You are absolutely correct . If you look at the extract below from SAP note 1601608

********************************************************************************************************************

DBCON / Multiconnect

DBCON / Multiconnect uses the Microsoft SQL Server Native Client Software (SNAC) to establish a connection to the remote SQL Server instance. The Microsoft SQL Server Client Software consists of several *.dll files. It is developed and distributed by Microsoft and is therefore not available for any operating systems other than Windows. DBCON utilizes the SAP ABAP stack to access the external databases so your system requires at least one ABAP-stack-based SAP Application Server running on Windows.

********************************************************************************************************************

the last line clearly state that an ABAP stack on windows is required for connecting to an external SQL server database as the MS SQL server client and the ABAP SQL server DBSL is compatible to run on windows OS only . So you cannot have these interfacing agents running on UNIX.

In such a scenario I suggest , you install an SAP application server on Windows OS  with other application server or CI running on UNIX.

Refer the following SAP notes

Note 1067221 - Composite SAP Note for heterogeneous installation

Note 680617 - INST: Appl.Server in Heterogeneous SAP System Environment

In such a scenario , whenever the applications need to connect to the MS SQL server database , it has to run on the application server on Windows OS.

Regards

Ratnajit