Connect to a remote MSSQL server.

[Former Member]

Dear All,

I have the following details about the remote SPA server:

- IP address 216.165.165.86 and port 1443.

  Along with the login credentials for the remote MSSQL Database.

I wish to connect to this database from my SAP system to fetch some data from a VIEW created in the remote MSSQL Database.

If anybody is aware of the process, I request you to please help.

Thanks and Regards,

Piyush R. Skaharkar.

[Sriram2009]

Hi Sankharkar

Kindly go thru the SAP Note 1774329 - Preparing your SAP instance to connect to remote SQL server

Note 178949 - MSSQL: Database MultiConnect

Note 323151 - Several DB connections with Native SQL

Thanks

Ram

[Former Member]

Hi Ram,

Thanks for the reply.

Will check the note.

Regards.

Piyush R. Sakharkar.

[former_member184473]

Hello Piyush,

You can create a DBCON (SAP running on Linux or Windows) or UDConnect (Java Stack)

Check note 1601608.

Regards,

Eduardo Rezende

[Former Member]

Hi All,

The details, I have mentioned are about remote MSSQL server. (I have written SPA by mistake.)

@ Eduardo.

Thanks for the quick response.

I am getting the message that the SAP Note 1601608 is not available.

Thanks ans Regards.

Piyush.

[former_member184473]

Hello Piyush,

I just check note 1601608 once again and could see normally.

Could you retry?

Regards,

Eduardo