If you are installing IBM® Controller for the first
time, you must create an empty Controller database. This is because IBM Controller requires a configured Controller database to run.
- If you performed a typical installation of Microsoft SQL Server, after you install you must change the authentication mode to
SQL Server and Windows.
For more information, see the related knowledge base article on the Microsoft Web site.
- Create the database.
Ensure that the database collation sequence is case insensitive, and is the same for both the
server and the Controller database.
- Determine which user account Controller Web Services Server will use to access the
database.
- Grant create table privileges for the database to the user account.
Ensure that the user account is a member of the db_owner role.