NT AUTHORITY\SYSTEM not found

Question

I'm trying to add "NT AUTHORITY\SYSTEM" to MSSQL Database, and it fails with error:

Windows NT user or group 'NT AUTHORITY\SYSTEM' not found. Check the name again.

Query string:

CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_LANGUAGE=[us_english]

How is it possible not to have this win user ?

Check if this helps - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=191253 — MusicLovingIndianGirl, Nov 02 '15 at 11:55

score -1 · Answer 1 · answered Nov 02 '15 at 13:14

-1

I read microsoft documentation about this kind of situation, and the only solution is to re-install windows, because NT AUTHORITY\SYSTEM appears only once - at windows installation. So i guess we can close this question.

answered Nov 02 '15 at 13:14

serje bulavsky

11
1
3

Reinstalling Windows is unlikely to be the right answer. Windows *always* has SYSTEM - although it isn't actually an account. Either you're adding it in the wrong way (did you try sp_grantlogon?) or there's some problem with the SQL installation. – Harry Johnston Nov 03 '15 at 04:07

NT AUTHORITY\SYSTEM not found

1 Answers1