Windows clustered server: Set up a SQL Server database
View information on installing and setting up SQL Server to work with WebSphere Portal.
1. Windows clustered server: Install SQL Server
View the steps to install SQL Server for use with WebSphere Portal.
2. Windows clustered server: Modify SQL Server database properties
You must modify the approriate properties files before transferring data from the default database to the SQL database.
3. Windows clustered server: Create databases manually
Use this alternative method for creating databases if you have problems running the create-database task that is documented for setting up a remote SQL Server database on Windows™ for a stand-alone production server.
4. Windows clustered server: Set up SQL Server automatically or manually
You can set up Microsoft™ SQL Server Enterprise Edition to work with WebSphere Portal automatically or manually. When setting up SQL Server automatically, the database administrator runs a ConfigEngine task to create users, grant privileges, and create JCR table spaces. As an alternative to automatically setting up the database, you can manually run scripts to create users, grant privileges, and create JCR table spaces.
5. Windows clustered server: Configuring WebSphere Portal to use SQL Server
This section provides information on how to manually transfer data from the default database to the SQL Server database. Follow these steps to transfer WebSphere Portal and Java Content Repository databases to SQL Server. As an alternative to the manual database transfer procedure described here, you can use the configuration wizard to complete the database transfer task.
Parent
Windows clustered server: Configuring WebSphere Portal to use a database