Creating the database in SQL Server manually

When you create the IMS Server database in Microsoft SQL Server 2005 and 2008 manually, you must specify the correct attributes for the logon name, user and collation.

Prerequisites

Preparing a database server with SQL Server

1. Log on to the SQL Server Management Studio with sa credentials.
2. Create a database.
   1. In the Object Explorer panel, right-click Databases.
   2. Click New Database.
   3. In the Database Name field, provide the database name. For example: imsdb
3. Set the collation.
   1. In the Select a Page panel, click Options.
   2. From the Collation list, select the collation SQL_Latin1_General_CP1_CS_AS.
   3. Click OK.
4. Create a SQL Server logon. For example: imsdbusr
   1. In the Object Explorer panel, expand Security > Logins.
   2. Select Logins, right-click New Login, and select SQL Server authentication.
   3. Enter a logon name. For example: imsdbusr
   4. Enter the password twice.
   5. Clear the Enforce password policy check box.
   6. For Default Database, select the database you created in step 2.
   7. Click OK.
5. Create a user.
   1. In the Object Explorer panel, expand Databases > <dbname> > Security > Users.
   2. Select Users.
   3. Right-click Users and select New User.
   4. In each of the following fields, type the same name that you specified in step 4 :
      • User name
      • Login name
      • Default schema
      For example: imsdbusr
   5. In the Database role membership panel, select db_owner.
   6. Click OK.
6. Add the schema.
   1. In the Object Explorer panel, expand Databases > <dbname> > Security > Schemas.
   2. Click New Schema.
   3. Type the name you specified in step 4, for each of the following fields:
      • Schema name
      • Schema owner
      For example: imsdbusr
   4. Click OK.
7. Close SQL Server Management Studio.