STEPS ON CREATING A JPEGGER DATABASE

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.