Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › SQL Server Principals › Define SQL Server Login Options

Define SQL Server Login Options

Use the SQL Server Login Editor to define authentication methods for a database in a SQL Server 2005/2008 physical model.

To define SQL Server logins

1. Click Principals, Logins on the Database menu.

   The SQL Server Login Editor opens.

2. Select the login in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new login.

   • Name

     Displays the login name. You can change the login name in this field.

   • Type

     Specifies the login type. Select the login type from the drop-down list.

   • Database

     Specifies the default database for the login. Select a database from the drop-down list or click New to open the SQL Server Database Editor and create a new database.

   • Generate

     Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:

   Note: Available options are based on the login type you defined in the Navigation Grid: Windows, Password, Certificate, or Asymmetric Key.

   • Password Unlock

     Specifies to unlock a locked login.

   • Password Must Change

     Specifies to enforce a password change the next time the user logs in.

   • SID

     Defines the GUID of the login. Enter the GUID in this field.

   • Language

     Defines the default language of the login. Enter the default language for the login in this field.

   • Disabled

     Specifies if the login is enabled or not. Select a value from the drop-down list.

   • Check Policy

     Specifies that the Windows password policies of the computer on which SQL Server is running should be enforced on this login. Select a value from the drop-down list.

   • Check Expiration

     Specifies whether the password expiration policy should be enforced on this login. Select a value from the drop-down list.

   • Credential

     Specifies the credential to map to the login. Select a credential from the drop-down list.

   • Asymmetric Key

     Specifies the asymmetric key to associate with the login, if the login type is set to Asymmetric Key. Select an asymmetric key from the drop-down list.

   • Certificate

     Specifies the certificate to associate with the login, if the login type is set to Certificate. Select a certificate from the drop-down list.

4. Click the Permission tab to define the permissions for the login.
5. Click the Roles tab to select or remove role usage.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the login.
7. (Optional) Click the UDP tab to work with user-defined properties for the login.
8. Click Close.

   The login is defined and the SQL Server Login Editor closes.