Authentication Mode

[Former Member]

Hi,

Is SBO works with windows Authentication mode? or is it necessary to install SQL with Mixed mode authentication ?

Thanks,

Avi

[Former Member]

Hello

According to SAP Documentation:

- For ABAP systems we recommend you to set authentication to Windows only.

- For Java or ABAP+Java systems you must set authentication to the mixed SQL Server and Windows authentication mode.

You can find detailed information [here|http://help.sap.com/saphelp_nw70ehp2/helpdata/en/34/85a1390f463a26e10000000a114084/frameset.htm].

Regards,

Laszlo

[former_member189546]

Hello,

The authentication mode that should be set is

'SQL Server and Windows'.

There also exist he mixed mode authentication,

Windows AND SQL based authentication,

that can be used too.

However in SAP environment this is not

necessary for ABAP stacks - this is why it is set to Windows

authentiction by default for ABAP stack SAP systems.

For dual stack or Java-stack systems also require mixed

authentication, so turning this on will not cause any issues.

See note

592514 : MSSQL: internal database users, permissions and security

regards,

John Feely