DB connection question

[former_member193399]

I understand that ABAP stack uses windows authentication to connection SQL Server.

But if we are doing local installation of a central instance and also local installation of application servers, how does this work? The SAP Services in application servers run under local user accounts and the connection will be denied to the SQL Server 2005 since it is not part of the domain.

Any idea or workaround?

Thanks,

-RT

[Former Member]

Hi

As a workaround you may create the same users in the DB Server also.

Thanks & Regards

Babu

[Former Member]

from the windows you can try go to the administration tools > services, there is two services belong to the SQL make sure that you using the login that having a right to SQL Server

from the SQL side you can using the STM tools to change or add the login to the sql server.