To access the Login Properties window for a specific login account in IDERA SQL Server, expand the Security folder in the Snapshot tree, select the Logins object, and then right-click the specific login on the table of the right and select Properties.
Use the Login Properties window to review the SQL login security properties for the selected login as well as its most recent password health.
Password health indicates whether or not the password associated with the account is considered weak. You can configure how SQL Secure detects weak passwords.
By default, the IDERA Level 2 and Level 3 policy templates enforce password health.
Possible password health states include:
| Password health state | What it means |
|---|---|
| Blank | The password for this login is either blank or null, which means no password is required for authentication or successful connection to databases hosted by your audited SQL Server instances. |
| Matches login name | The password for this login matches the name of the login. |
| N/A | The password for this login was not checked, most likely because the login is a Windows user account. |
| OK | This login most likely has a strong password because the password does not match any of the words and phrases in the Default Weak Passwords list or the additional and custom passwords you specified. |
| Weak | The password for this login matches one or more of the words and phrases in the Default Weak Passwords list or the additional and custom passwords you specified. |
Available tabs on the Login Properties window
The General tab summarizes the key security settings and login properties typically found on the General, Server Role, and Status tabs in the Microsoft SQL Server client. For more information, see Microsoft Server Books Online.
The Permissions tab summarizes the key security settings and login properties typically found on the Explicit Permissions pane of the Securables tab of the Microsoft SQL Server client. For more information, see Microsoft Server Books Online.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal