Solaris stand-alone: Set up SQL Server automatically or manually
We can set up Microsoft SQL Server Enterprise Edition to work with WebSphere Portal automatically or manually. When setting up SQL Server automatically, we run a ConfigEngine task to create users, grant privileges, and create JCR table spaces. Alternatively, we can manually run SQL scripts to create users, grant privileges, and create JCR table spaces.
- Prerequisites
- Solaris stand-alone: Install SQL Server
- Solaris stand-alone: Modify SQL Server database properties
Manual configuration allows database administrators to understand what is going on at each end of the process. The speed of automatic database setup but to gain a better understanding of what is happening during the automatic configuration process, we 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 ConfigEngine or to manually set up the database.
- If you have configured the database automatically by running ConfigEngine, 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.
- Solaris stand-alone: Run a task to automatically setup SQL Server databases
- Solaris stand-alone: Set up SQL Server manually
If you have configured the database automatically by running ConfigEngine, you do not need to run manual tasks for creating users, privileges, or table spaces, but you may decide to perform additional manual configuration for items that are not provided to you when you automatically when you run ConfigEngine.For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task.
Parent: Solaris stand-alone: Set up a SQL Server database
Previous: Solaris stand-alone: Modify SQL Server database properties
Next: Solaris stand-alone: Configure Portal to use SQL Server