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

---

 

Create databases and users for SQL Server

This section provides information on setting up SQL Server for WebSphere Portal Express.

 

Before you begin

• You should have completed Installing SQL Server.

Notes:

• If WebSphere Portal Express Version 6.0 and an earlier version of WebSphere Portal Express coexist, the database user IDs for WebSphere Portal Express Version 6.0 must be different than earlier versions to avoid conflicts during installation.

• Database names and user information will be required when configuring WebSphere Portal Express to work with SQL Server.

 

Create databases

Before you create the database users, create the databases. Use the SQL Server Enterprise Manager to create the databases.

1. Expand the nodes to see Databases.

2. Right-click on Databases to see New database.

3. Enter the database name. For information on the recommended database architecture and the databases you will need to create, see Planning for SQL Server.

4. Select the Collation Name from the drop-down list according to your environment. Make sure that collation is set to case-sensitive. For example, on an English system:

   • SQL_Latin1_General_CP1_CS_AS

   For LikeMinds, CI is the default setting; however, CS can also be used.

5. Click OK to save the database changes.

 

Create database users

After creating the databases, create the recommended database users with the SQL Server Enterprise Manager.

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 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. For information on the recommended database architecture and the databases you will need to create, see Planning for SQL Server.

6. Select SQL Server Authentication.

7. Set a password for the selected user.

8. In the "Database Access" pane, select the database the user must connect to at runtime. The following mappings are recommended:

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

9. Be sure that no Server Role is selected.

10. Set Database Access as follows:

    Database	User	Database Role
    RELEASE	RELEASEUSR WMMDBUSR	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
    WMM	WMMDBUSR	public db_owner

11. Click OK to save the user changes.

 

Set SQL Server properties Authentication

After creating the databases and users, set the SQL Server Enterprise Manager Authentication setting to SqlServer and Windows . This will eliminate the need for run-time authentication of SQL Server requests.

If you have previously configured these settings on Enterprise Manager, you do not need to complete these steps.

1. Open the SQL Server Enterprise Manager by selecting Start menu > Programs > Microsoft SQL Server > Enterprise Manager.

2. Expand the tree control until you can see your server.

3. Right click on the server name and select Properties. The "SQL Server Properties (Configure)" window will open.

4. Select the Security tab.

5. For Authentication, select SQL Server and Windows.

6. Restart the SQL Server to apply your update.

 

Next steps

You have completed this step. Continue to the next step.

 

Parent topic:

Configuring SQL Server

 

Previous topic

Installing SQL Server

 

Next topic

Transferring SQL Server

---