Set up a remote SQL Server database on Windows for a stand-alone production server

To setup a remote Microsoft SQL Server Enterprise Edition database, create user IDs and databases on a remote server. Tasks are provided to assist with creating the user IDs and the databases. Before you can use the tasks, modify properties files.

  1. Installing SQL Server

    View the steps to install SQL Server for use with WebSphere Portal.

  2. Creating users manually

    Use this alternative method for creating users if you have problems running the setup-database task that is documented for setting up a remote SQL Server 2005 database on Windows for a stand-alone production server.

  3. Modifying database properties

    Learn how to modify the,, and files to work with your database. Modify these property files before running tasks to create databases, create users, or transfer data.

  4. Set up databases

    This topic provides instructions on automatically setting up your database using...


    As an alternative to automatically setting up the database, you can manually create users and grant privileges.

  5. Optional: Assigning custom table spaces

    The repository of WebSphere Portal consists of many tables and indices that are created in default file groups. When using an existing set of file groups for the objects of the repository, specify this when executing the database transfer to the target database system.

  6. Configure WebSphere Portal to use SQL Server 2005

    View information on manually transferring data to the SQL Server 2005 database you have installed and set up. Follow these steps to transfer WebSphere Portal, and Java Content Repository databases to SQL Server 2005. As an alternative to the manual database transfer procedure described here, you can use the configuration wizard to complete the database transfer task.

Parent topic:

Configure databases