Login: NT AUTHORITY\SYSTEM

Properties

Property	Value
Login Name	NT AUTHORITY\SYSTEM
Principal ID	259
Login Type	WINDOWS LOGIN
Enabled
SID	x010100000000000512000000
Default Database	master
Default Language	us_english
Default language friendly name	English
Enforce Password Policy
Enforce Password Expiration
Permission to connect to database engine
Mapped to certificate
Mapped to asymmetric key
System Object
Last Modify Time	7/30/2010 11:34:58 AM
Create Time	7/30/2010 11:34:58 AM

Login mapped to credentials

Login is not mapped to any credential

Login mapped to database users

Login is not mapped to any database users

Server Roles for that login

Role Name
sysadmin

Login Permissions on the server

No Server Permissions defined for that login

SQL

Script
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

See also