Skip to Content
author's profile photo
Former Member

Sap can not connect sql server

Hi Experts,

My problem is that sql server agent could not start and i tried many things to solve.Finally i added 'NT AUTHORITY\ANONYMOUS LOGON' account after that sql server agent can start but now sap gives those errors:(platforms are win 2008 and sql 2008)

lpc:(local) connection used on BWTEST

C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2285]

C (18452) [28000] [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.

C Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=BWTEST;AutoTranslate=no;Trusted_Connection=yes;WSID=BWTEST;APP=R3D00 comm rd ODBC;Database=FBT;

Can you please help me and suggest me what can i do?

Regarts,

SavaƟ

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 05, 2011 at 02:35 PM

    Hi, Savas

    check hosts file! is there any invalid IP or hostname?

    Regards

    ABH

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 11:26 AM

    Is your sap system is connected to your domain controller?

    Thanks

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 03:56 PM

    Hello,

    The message is that OS user with which you are

    trying to log on the database and the database belong to different

    Windows domains, and these do not have a trusted relationship.

    This usually happens when you are installing a system; however a change

    in the configuration (e.g. if somebody changed a trust relationship

    between domains, or deleted a particular user, etc.) could make stop

    working a previous configuration.

    Please, check note 117395 Authorization problems for file I/O on Windows NT

    regards,

    John Feely

    Add comment
    10|10000 characters needed characters exceeded