Login: NT SERVICE\SQLSERVERAGENT

Properties

Property	Value
Login Name	NT SERVICE\SQLSERVERAGENT
Principal ID	262
Login Type	WINDOWS GROUP
Enabled
SID	x010600000000000550000000DCA88F14B79FD47A992A3D8943F829A726066357
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:35:03 AM
Create Time	7/30/2010 11:35:03 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\SQLSERVERAGENT] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

See also