DB connection from ABAP Web application server

[former_member193399]

With default installation ABAP application server uses windows authentication to connect to SQL Server. How can I change this to SQL Server authentication i.e. using user id password?

Thanks,

RT

[Former Member]

You can set the following profile parameters in your instance profile:

dbs/mss/use_integrated_security = 0

dbs/mss/user = <sqllogin>

dbs/mss/passwd = <passwd for sqllogin>

For example for user sapr3 and password sap:

dbs/mss/use_integrated_security = 0

dbs/mss/user = sapr3

dbs/mss/passwd = sap

The sql login must have server role 'sysadmin'.

For the standalone tools to use SQL login you have to set the environment parameters

MSSQL_USEINTEGRATEDSECURITY = 0

MSSQL_USER = <sqllogin>

MSSQL_PASSWD = <passwd for sqllogin>

For example:

set MSSQL_USEINTEGRATEDSECURITY=0

set MSSQL_USER=sapr3

set MSSQL_PASSWD=sap

There's currently no secure store integration.

Regards,

Guenther

P.S.

But actually: why do you want to give up the more secure Windows Authentication?

[former_member193399]

Guenther,

Thanks for the reply......

I understand that there is no secure storage for this like java. But is there anyway to encrypt so that the password is not clear text in the instance profile?

We are trying out some different setup in our environment and one of that is having the application servers in DMZ rather than in enterprise network. In this scenario the application servers will be a local installation and cannot use windows authentication. By using uid/pwd of MSS we can now connect to db.

Any other way of keeping this information secure? If there is no encryption or secure storage available then using this in DMZ is definitely not a option.

Thanks,

RT