Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › Login Properties › Define SQL Azure Logins

Define SQL Azure Logins

Use the SQL Azure Login Editor to define authentication methods for a database in a SQL Azure physical model.

To define SQL Azure logins

1. Click Target - SQL Azure, Principals, Logins on the Model menu.

   The SQL Azure 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. Use the Enter filter text box to filter a very large list of logins to quickly locate the one that you want to define.

   Name

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

   Authentication

   Identifies the Password authentication type for the login.

   Generate

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

3. Click the General tab and select a value from the drop-down list to specify whether the login is enabled or not.
4. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
5. (Optional) Click the UDP tab to work with user-defined properties for the object.
6. (Optional) Click the Notes tab to view and edit user notes.
7. Click Close.

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

More information:

Define Permissions for an Object in a SQL Azure Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor