login icon Login: PROJECTENVISION\Administrator

Properties

Property Value
Login Name PROJECTENVISION\Administrator
Principal ID 261
Login Type WINDOWS LOGIN
Enabled true
SID x01050000000000051500000025B2C65A6DE3BF7F151D61F3F4010000
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/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

Database Name Username Type
AdventureWorks2008 dbo WINDOWS USER
PLPKDATAARCH dbo WINDOWS USER
AdventureWorksDW dbo WINDOWS USER
AdventureWorksLT dbo WINDOWS USER
DATA_01 dbo WINDOWS USER
AdventureWorksDW2008 dbo WINDOWS USER
AdventureWorksLT2008 dbo WINDOWS USER
AdventureWorks dbo WINDOWS USER
Cart dbo WINDOWS USER

Server Roles for that login

Role Name
sysadmin

Login Permissions on the server

No Server Permissions defined for that login

SQL

Script
CREATE LOGIN [PROJECTENVISION\Administrator] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]

See also

List of Logins