Steps on Creating a JPEGger database

1. SQL Server should be in mixed mode.
2. Create a database named JPEGger.
   • Both log and data files should automatically grow by 10% unlimited.
   • Should be in Full Recovery mode.
3. Create a SQL ID named Transact.
   • Make Transact db_owner for the JPEGger database.
4. (Optional)Create a SQL ID named JPEGger.
   • Make JPEGger db_datareaded and db_denydatawriter for the JPEGger database.

Related Articles:
Create a New Log File From a Command Line
Configuring MySQL for Network Access
Recommended Backup Strategy for SQL Server
Creating Self Signed SSL Certificates on IIS 6.0 and Windows Server 2003
Not Able to Retrieve Archived Images