Documentation Center

Removing the database user and schema

To ensure successful creation of a new database user and schema, delete the user that was created when importing the sample data, as well as the schema of the same name if one exists.

About this task

A database user in SQL Server exists on two levels, as an account on the SQL Server level and as an account on your database. Depending on the kind of initial database setup dump you received, you could have problems creating your new database user. Therefore, you should delete the Content Manager database designated user (by default named isource) and schema if one is present.

Procedure

  1. In the SQL Server Management Studio window, locate and open the tree under the newly created database.
  2. Open Security > Schemas.
  3. Right-click on isource if it appears in the list, then click Delete.
    A Delete Object window displays.
  4. Click OK to confirm the removal.
  5. Open Security > Users.
  6. Right-click on isource then click Delete.
    A Delete Object window displays.
  7. Click OK to confirm the removal.