Login: NT SERVICE\MSSQLSERVER

Properties

Property	Value
Login Name	NT SERVICE\MSSQLSERVER
Principal ID	260
Login Type	WINDOWS GROUP
Enabled
SID	x010600000000000550000000E20F4FE7B15874E48E19026478C2DC9AC307B83E
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 SERVICE\MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

See also