AIX clustered server: Create databases manually on SQL Server

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

Before you begin, create the databases.


Prerequisites


AIX clustered server: Install SQL Server
AIX clustered server: Modify SQL Server database properties

  1. Expand the nodes to see Databases.

  2. Right-click 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 Plan for SQL Server

  4. On the Options page, select Collation Name from the drop-down list that matches environment. Set the collation 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.


Parent

AIX clustered server: Set up a remote SQL Server


Previous

AIX clustered server: Modify SQL Server database properties


Next topic

AIX clustered server: Set up SQL Server automatically or manually

 


+

Search Tips   |   Advanced Search