Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Login Properties

Login Properties

The following describes new or changed properties in the property editor and related information.

SQL Azure does not support the following arguments and options when using the CREATE LOGIN statement:

• hashed_password
• MUST_CHANGE
• SID
• DEFAULT_DATABASE
• DEFAULT_LANGUAGE
• CHECK_EXPIRATION
• CHECK_POLICY
• CREDENTIAL

The following describes the impacts on the SQL Azure Login Editor as compared to the SQL Server 2008 Login Editor:

• In the Navigation Grid, the only available option for the Authentication drop-down is Password. There is no Database selection.
• On the General tab, only the Disabled option is available.
• GRANT/DENY/REVOKE on Login is unavailable in SQL Azure, so Permission on Login is unsupported.
• Since sp_addsrvrolemember is unavailable in SQL Azure, the Role property is not supported.