DBIF_RSQL_SQL_ERROR - WRITE_TO_DATABASE

[jorge_velasquez]

Hi Experts,

After system copy I have an error when trying to access to tx SECSTORE :

How to correct the error

    Database error text........: "[Microsoft][SQL Server Native Client 10.0][SQL

     Server]Login failed. The login is from an untrusted domain and cannot be used

     with Windows authentication."

    Internal call code.........: "[RSQL/DELE/PAKDATBUF ]"

    Please check the entries in the system log (Transaction SM21).

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

    "SAPLPA_PACKAGE_SERVICES" or "LPA_PACKAGE_SERVICESF02"

    "WRITE_TO_DATABASE"

Any clue?

[Former Member · Accepted solution]

Hi,

  Please check the hostname . There could be some invalid IP Address. I believe this should solve the problem.

Secondly, check whether the domain controller is up and running. And the sql server is mapped to correct domain and correct trusted group.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Reagan]

Hello

If you get dumped out when you call x SECSTORE then try to run the report SECSTORE_CLEANUP from Tx SE38 and see whether that helps.

If that fails as well then try this:

change SQL Server's account from Network Service to Local System

Ref : http://www.megustaulises.com/2012/04/sql-server-login-failed-login-is-from.html

Cheers

RB

[former_member185239]

Hi jorge,

1. Maintain a host entry on your local system.Also check at the server level as well.

2. Check your kernel as well.

With Regards

Ashutosh Chaturvedi

[former_member188883]

Hi Jorge,

Refer this link for step by step guidance on resolving the issue.

http://blog.sqlauthority.com/2012/09/06/sql-server-fix-error-cannot-connect-to-login-failed-the-logi...

Regards,

Deepak Kori

[Former Member]

I haven't seen this one before. Is transaction SECSTORE the only one giving the error or are you getting the error whenever the database is accessed?