Login: tester

Properties

Property	Value
Login Name	tester
Principal ID	268
Login Type	SQL LOGIN
Enabled
SID	xF6E2A8BFC3211B46BBA9F31490F3C751
Default Database	master
Default Language	us_english
Default language friendly name	English
Enforce Password Policy
Enforce Password Expiration
Password Expired
User must change password at next login
Login is locked out
Permission to connect to database engine
Mapped to certificate
Mapped to asymmetric key
System Object
Last Modify Time	9/22/2010 8:34:43 PM
Create Time	9/22/2010 8:34:43 PM

Login mapped to credentials

	Credential Name	Identity
	krystianCredential	W7\alien

Login mapped to database users

Database Name	Username	Type
AdventureWorks	tester	SQL 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
/* For security reasons the login is created disabled and with a random password. / CREATE LOGIN [tester] WITH PASSWORD=***********************, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF ALTER LOGIN [tester] DISABLE DENY CONNECT SQL TO [tester]

See also