STEP 1: Create activation center SQL database 

Create new database named acdb and single database user acdbuser on your SQL server.

STEP 2: Create tables, indexes, keys and defaults

Use supplied CREATE_TABLES.SQL script for this purpose.

STEP 3: Add default data to ACEN database.

Use supplied INSERT_DEFAULT_DATA.SQL script for adding default data to database tables.

STEP 4: Add new sql server login (default login: acdbuser)

To create a SQL Server login that uses SQL Server Authentication:

1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.

2. Right-click the Security folder, point to New, and then click Login.

3. On the General page, enter a name for the new login in the Login name box (default: 'acdbuser')

4. Select SQL Server Authentication.

5. Enter a password for the login.

6. Select the password policy options that should be applied to the new login. 'Enforce password policy' may be turned off for now.

7. Select default database to ACEN database (default: 'acdb')

8. Select 'User mapping'

9. Select ACEN database in 'Users mapped to this login:" list.

10. Select 'db_backupoperator', 'db_datareader' and 'db_datawriter' options in 'Database role membership list for: acdb'

11. Click on 'OK' 


- SQL Scripts are located in \database subdirectory.

- All scripts are using default (acdb) database name. If required, rename default database name in provided scripts.

- If you are creating database on remote site you should be able to do it from hosting control panel (you need to consult your hosting provider about this).

- SQL security model should be set to Mixed mode (Windows authentication or SQL Server authentication).

- Be sure to set required rights for database user.

- If required, you can use another database name or database user. Just be sure to set correct information in sql_connectionstring and sql_database_name (used for backup) keys inside acen.config file.

- If you are using integrated security on local IIS server for connecting to database be sure to create login for DefaultAppPool (or any other AppPool you are using)

Here is how:

1. In SQL Server Management Studio, look for the Security folder (the security folder at the same level as the Databases, Server Objects, etc. folders...not the security folder within each individual database)

2. Right click logins and select "New Login"

3. In the Login name field, type "IIS APPPOOL\YourAppPoolName" (do not click search!)

4. In "User mapping" map acen databases to this login and set database role membership (db_datareader, db_datawriter, db_owner)

5. Click OK