Installation guide

Updating the SQL Server registration
(Topic number: 7604)
8.
To correctly register SQL Server with the Database Server software and set up permissions within
SQL Server, update the SQL Server registration. To do so, you must be logged into Windows as an
administrator-level user.
To update the SQL Server registration
1.
Select Start > All Programs > Microsoft SQL Server 2008.
2.
Right-click SQL Server Management Studio and select Run as.
3.
In the Run as dialog, select The following user.
4.
From the User name list, select AgfaService.
5.
In the Password field, type the password for the AgfaService account and click OK.
Scheduling additional SQL database backup jobs
(Topic number: 46983)
9.
Note:
Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server
Management Studio using the Administrator account.
This procedure applies to SQL Server 2008 R2.
After upgrading SQL Server, to guard against information loss, manually back up the database again
(refer to page 32), then confirm that you can configure a schedule_backup job.
CAUTION!
If backups are not created regularly, the transaction log fills up and eventually halts the
operation of your system. Also note that you must do an initial backup of your database.
Otherwise, SQL Server assumes that you do not want transaction logs maintained.
A schedule_backup job is automatically installed and enabled with the software package. This backup
is scheduled to run at 12:00 midnight every day. In addition to the schedule_backup job, you can
enable and schedule the differential or incremental database backup jobs, if required.
To configure an additional time to run a database backup at, perform the task that follows.
To schedule additional SQL database backup jobs
1. Ensure that you have done an initial manual backup of your database (refer to page 32).
AS300 Upgrade and DAA Consolidation Guide—IMPAX 6.2 or 6.3 to IMPAX 6.5.3 38
Agfa Company Confidential—Subject to Non-Disclosure Obligation