CA ERwin Model Manager › Connect to the CA ERwin MM Mart › Enable Windows Authentication

Enable Windows Authentication

The authentication type determines whether a user connects to the mart using Windows authentication or database authentication. Windows Authentication specifies the use of Windows user names and passwords to secure database access. You must be logged onto your computer as the user who is the dbo of the database. Windows Authentication applies to Oracle Version 9i and 10g or Microsoft SQL Server (2000/2005) users.

To enable Windows authentication

1. Click Security on the Services menu.

   The Security Manager dialog opens.

2. Drag the icon for the Windows user from the User list onto the security profile icon in the Security Profile list.

   The user is assigned the security profile.

3. Click OK.

   The Windows user name is added to the mart, which enables Windows authentication. The dialog closes.

Important: For Microsoft SQL Server 2000/2005, you must select Mixed Mode Authentication during the installation of the server. For Oracle Version 9i/10g, the following two parameters should be modified in the initialization file (InitSID.ora):

Remote_OS_Authent=""
OS_Authent_Prefix=TRUE