Create the Database

SQL Server

  1. Connect to your SQL Server.
  2. Create a database named colectica.
  3. Run the SQL commands in RepositoryDir\scripts\sqlserver2008-RepositorySchema.sql.
  4. If using the built-in Colectica authentication system:
  1. Launch a command line with Administrative rights.
  2. Navigate to drive\WINDOWS\Microsoft.NET\Framework\versionNumber
  3. Run the Aspnet_regsql.exe tool.
  4. In the wizard that follows:
  1. Choose to Configure SQL Server for application services.
  2. Select your database server. Leave the database as Default.
  3. Click Next twice and your authentication database will be created.

PostgreSQL

  1. Connect to your PostgreSQL server.
  2. Create a database named colectica.
  3. Run the SQL commands in RepositoryDir\scripts\postgres8.4-RepositorySchema.sql.
  4. If using the built-in Colectica authentication system, create a database named colectica_user and run the SQL commands in RepositoryDir\scripts\postgres8.4-ProviderSchema.sql.