Windows Application Server

[Former Member]

Hello Gurus,

We are going to add additional application server to our sap system. It's on unix/DB2 but the DI that we are going to add is windows and we need to connect this to msSQL. It's a bit challenging but it's possible. There's an abap program to fetch the data from this mssql in windows that's why we are doing this. And I dont know where to start. Is it the same DI installation. How about the kernel, the sql client? how can I connect the apps server to SQL?

Thanks in advance for the help.

[Former Member]

Hi,

 It's on unix/DB2 but the DI that we are going to add is windows and we need to connect this to msSQL. 

This does not make sense. If you have a CI/DB unix server with DB2, you can add windows application servers but thare absolutely no need for MSSQL.

Beware of abap specific programs using files on the CI server if your developpers did not use logical directories from transaction FILE...

Regards,

Olivier

[Former Member]

Hello Olivier,

Thanks for your prompt response. To make this simple, there is a need on our SAP system to access the data from mssql. I know ABAP can code it like SELECT statements and fetch the data to be processed. This is why we are going to add an apps server that is connecting to the mssql. someone told me that I need sql client running on this windows server to communicate to sql db but I dont know what specific steps I need to do first.

Thanks again.

[Former Member]

Hello,

I still don't understand what you want to do. What is this MSSQL database if it is not the SAP system database.

If it is an external non SAP database, then be aware that external direct database access is the worst interface technology.

It's not safe and will be a nightmare to maintain.

You should use an application API (RFC, web services, etc...) to access the external data.

Regards,

Olivier

[Former Member]

Hello SAP Gurus,

i'm installing DI On windows. CI is on Unix. I read a note about heterogeneous inst.

1. On UNIX, release the /usr/sap directory as SAPMNT. To do this, use SAMBA or a comparable tool. The user who is performing the installation on the Windows host as well as the <sapsid>adm and SAPService<SAPSID> Windows users created during the installation must have read and write authorization on this share directory and its subdirectories.

Do you know how I can give authorization to SIDadm and ServicesapSID to access, write and read this directory and it's subdirectories. : /usr/sap? I can't set the permission on windows. it says access denied.

Appreciate your help. Thank you.

[Former Member]

Hi,

You have to give authorizations from Samba configuration on the CI Unix server.

Regards,

Olivier