SQL server login 'NT AUTHORITY\SYSTEM'

[peter_yu3]

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 · Accepted solution]

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.

[peter_yu3 · Accepted solution]

Joey, i guess you are right, i checked the server, somebody changed sap service startup as local system user. As it need reboot after change it back to SAPService<SID>, so I will check if it works later. Thanks.

Best regards,

Peter

Edited by: Peter Yu on Sep 19, 2008 1:19 AM

[Former Member · Accepted solution]

Glad I could be of assistance...