Sap can not connect sql server

[Former Member]

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ş

[Former Member · Accepted solution]

Hi, Savas

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

Regards

ABH

[Former Member · Accepted solution]

Hi again,

Thank you for all usefull answers.

Regards,

Savas

[former_member189546]

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

[sivakumar_kilari3]

Is your sap system is connected to your domain controller?

Thanks

Siva