LiveCycle for the SQL Server 2005 DBA
If you are a SQL Server 2005 DBA tasked with configuring a database for Adobe LiveCycle ES 8.0.1, the following scripts will help. You can run them using SQL Server Management Studio in the following order as the Instance-wide Administrator (sa). Make appropriate changes for your server envrionment.
Best practice (from a LiveCycle perspective) calls for:
1) the instance login, the database user and the schema to be exactly the same
2) this to be less than or equal to 12 characters in length
3) this to not contain any characters other than letters and numbers (no hyphens)
Also, SQL authentication is preferred over Windows authentication.
Minimum required storage is:
LC ES (8.0.1) : 300 MB, 500 MB is better
LC ES Update 1 (8.2.1) : 800 MB, 1 GB is better
Create Database
Create Instance Login
Create Database Schema
Create Database User
Alter the Schema
Add dbowner role to Database User
Please note: The Database Instance "Login" name and the LiveCycle Database "User" name have to be the same for LCM bootstrapping to work.
After LiveCycle has been completely configured (all users in your directory have been synchronized with the LiveCycle database), run the following system stored procedure to update database statistics:
sp_updatestats;
To determine the amount of storage used by the LiveCycle database, run the following system stored procedure:
sp_spaceused;