Linux 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.
Prerequisites
Linux clustered server: Install SQL Server
Linux clustered server: Modify SQL Server database properties
Linux clustered server: Create SQL Server databases manuallyAutomatic configuration provides a faster path for database administrators for setting up SQL Server, but does not provide in depth knowledge of how the database is configured. Manual configuration allows database administrators to understand what is going on at each end of the process. The speed of automatic database setup but you would like to gain a better understanding of what is happening during the automatic configuration process, you can review the steps in the manual configuration section and then return to the automatic configuration steps.
- You must log in as the system administrator to run the ConfigEngine task or to manually set up the database.
- If you have configured database automatically by running the ConfigEngine task, you do not need to run manual tasks for creating users, privileges, or table spaces, but you may decide to refer to the manual configuration section to perform the optional step of assigning custom table spaces.
Linux clustered server: Set up a SQL Server database
Previous
Linux clustered server: Create SQL Server databases manually
Next topic
Linux clustered server: Configure WebSphere Portal to use SQL Server