Documentation Center

Removing the database user and schema

To ensure successful creation of a new database user and schema, delete the user and schema that was created when importing the sample data.

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 InfoShare database designated user (by default named isource) and schema.

Procedure

  1. In the SQL Server Management Studio window, locate and open the tree under Infoshare.
  2. Open Security > Schemas.
  3. Right-click on isource 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.