Make a SAS Copy of DBMS Credentials

To provide seamless access to a third-party DBMS, add a login that contains the user ID and password for a DBMS account. These instructions are also appropriate for providing seamless access to other servers that require credentials that are different from the credentials with which a user initially logs on.

Store Shared Credentials for a DBMS

Verify the authentication domain for the DBMS:
1. On the Plug-ins tab, expand the Server Manager node and select the DBMS server.
2. Right-click, select Properties, and access the Options tab.
In User Manager, identify or create the group that you will use to manage the shared DBMS account that you want to share. For example, if you want all users to share the account, use the PUBLIC group.
On the group's Accounts tab, click New.
In the New Login Properties dialog box:
1. Enter the user ID and password for the DBMS account.
2. Select the authentication domain that you saw in step 1b.
3. Click OK to save the login.
On the group's Members tab, make sure that everyone who needs to use the shared account is a member. Remember that only direct memberships are displayed, but indirect or implicit membership is also sufficient for making the credentials available.

Store Individual Credentials for a DBMS

Follow the instructions in the preceding topic but add the login to a user's Accounts tab instead of a group's Accounts tab.

Note: If a user has more than one available login in a particular authentication domain, the login that is closest to the user is used. If there is tie (for example, if a user is a direct member of two groups and both groups have logins in the same authentication domain), the same login is used consistently but you can't control which of the two logins is used.