Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL server login 'NT AUTHORITY\SYSTEM'

hi all,

Does anybody know why SAP still using this login ''NT AUTHORITY\SYSTEM'', I have ECC 6.0 + SQL Server 2005. My SQL server DBA removed this login for security issue. then after i reboot my sap instance, all the work process stoped, below is the error message in my work process log.

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23715. hr: 0x8000ffff Login failed for user 'NT AUTHORITY\SYSTEM'.

C sloledb.cpp [OpenOledbConnection,line 23715]: Error/Message: (err 18456, sev 0), Login failed for user 'NT AUTHORITY\SYSTEM'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23715]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn. 0

B ***LOG BY2=> sql error -1 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> Login failed for user 'NT AUTHORITY\SYSTEM'. [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -1 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> Login failed for user 'NT AUTHORITY\SYSTEM'. [dblink#5 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]

Then after i add login 'NT AUTHORITY\SYSTEM' back, all works fine. But from SAP's security guide, no any place said i need this login...

Best regards,

Peter

Former Member
Former Member replied

It depends on how you setup SAP.

Make sure all of your SAP services run under the SAP domain account SAPService<SID>, and double check that your SQL logins have the appropriate rights in SQL Server.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question