login icon Login: NT AUTHORITY\LOCAL SERVICE

Properties

Property Value
Login Name NT AUTHORITY\LOCAL SERVICE
Principal ID 276
Login Type WINDOWS LOGIN
Enabled true
SID x010100000000000513000000
Default Database master
Default Language us_english
Default language friendly name English
Enforce Password Policy true
Enforce Password Expiration true
Permission to connect to database engine true
Mapped to certificate
Mapped to asymmetric key
System Object false
Last Modify Time 7/17/2011 1:51:41 PM
Create Time 7/17/2011 1:51:41 PM

Login mapped to credentials

Login is not mapped to any credential

Login mapped to database users

Database Name Username Type
ReportServer NT AUTHORITY\LOCAL SERVICE WINDOWS USER
ReportServerTempDB NT AUTHORITY\LOCAL SERVICE WINDOWS USER
msdb NT AUTHORITY\LOCAL SERVICE WINDOWS USER
master NT AUTHORITY\LOCAL SERVICE WINDOWS USER

Server Roles for that login

No server roles for this login.

Login Permissions on the server

No Server Permissions defined for that login

SQL

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

See also

List of Logins