Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Create users

This section provides information on setting up users for SQL Server 2005

• You should have completed installing SQL Server 2005 and creating databases.
• If WebSphere Portal Express Version 6.1 and an earlier version of WebSphere Portal Express coexist, the database user IDs for WebSphere Portal Express Version 6.1 must be different than earlier versions to avoid conflicts during installation.

Create the recommended database users with the SQL Server Management Studio. At least one user is required for each SQL Server 2005 instance.

Take care to create users in an environment that has the same settings as the actual runtime environment. For example, avoid creating a user in an English environment if you plan to use that user in a Turkish environment.

1. Connect to your SQL Server 2005 instance.
2. Expand the tree view beneath the SQL Server instance.
3. Expand Security and right-click on Logins.
4. In the opening context menu, select New Login....
5. Enter the database user names.
6. Select SQL Server Authentication.
7. Set a password for the selected user.
8. In the Database Access window, select the database the user must connect to at runtime. The following mappings are recommended:

   Database	User
   RELEASE	RELEASEUSR
   COMMUNITY	COMMUNITYUSR
   CUSTOMIZATION	CUSTOMIZATIONUSR
   JCRDB	ICMADMIN
   FDBKDB	FEEDBACK
   LMDB	LMDBUSR

9. Be sure that the only Server Role selected is public.
10. Set Database Access as follows:

    Database	User	Database Role
    RELEASE	RELEASEUSR	public db_owner
    COMMUNITY	COMMUNITYUSR	public db_owner
    CUSTOMIZATION	CUSTOMIZATIONUSR	public db_owner
    JCRDB	ICMADMIN	public db_owner
    FDBKDB	FEEDBACK	public db_owner
    LMDB	LMDBUSR	public db_owner

11. Click OK to save the user changes.