login icon Login: InfrastructureMonitorUser

Properties

Property Value
Login Name InfrastructureMonitorUser
Principal ID 271
Login Type SQL LOGIN
Enabled true
SID x8F42251D3C1E0E4FB8D5184747DFECA8
Default Database master
Default Language us_english
Default language friendly name English
Enforce Password Policy true
Enforce Password Expiration false
Password Expired false
User must change password at next login false
Login is locked out false
Permission to connect to database engine true
Mapped to certificate
Mapped to asymmetric key
System Object false
Last Modify Time 5/8/2011 7:11:50 PM
Create Time 5/8/2011 7:11:49 PM

Login mapped to credentials

Login is not mapped to any credential

Login mapped to database users

Database Name Username Type
InfrastructureMonitor InfrastructureMonitorUser 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 [InfrastructureMonitorUser] WITH PASSWORD=************************, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
ALTER LOGIN [InfrastructureMonitorUser] DISABLE

See also

List of Logins