Installation Guide › WebSphere Version › Separate Database Configuration › How to Create Separate Databases › Create an MS SQL Server Database Instance

Create an MS SQL Server Database Instance

Follow these steps:

1. Create a database instance in SQL server.
2. Create a user and grant this user the necessary rights (such as public and db_owner rights) to the database by editing the properties of the user.

   Note: The user must have at least select, insert, update, and delete permissions for all of the tables created by the .sql script for creating the database, and must be able to execute all of the stored procedures (if applicable) defined in these scripts.
   For example, the user must have these permissions on the tables defined in the following default location:

   C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\sqlserver\idm_db_sqlserver.sql

3. While editing the user’s properties, set the database you just created as the default database for the user.
4. Ensure the Authentication setting has a value of SQL Server on the Security tab of the SQL Server Properties dialog for the server where the database is installed.

Note: For complete information about Microsoft SQL Server, see your Microsoft SQL Server documentation.