Installation manual

UNIPOWER
Installation manual PQ Secure
106
3
Update of PQ Secure (installation/configuration)
3.0
PQ Secure installations-CD version: _________
3.1
Uninstall + install PQOnline (version: _________ )
☐
3.2
Uninstall + install PQ Secure (version: _________ )
☐
3.3
Pause all schedules in PQ Secure in order not to interfere with next section
☐
3.3.1
Using PQSchedule Service Control: stop the PQ Schedule Service and exit any running PQ
Schedule.
☐
3.3.2
Uninstall PQ Schedule
☐
3.3.3
Run DBWizard (db version: _________ )
If DBWizard fails to update manually run the scripts in section 3.3.3.1 or 3.3.3.2
☐
3.3.3.1
If the server runs with Windows authentication, use the following script in the stated order:
Users_winauth.sql
tables_permissions.sql
procedures.sql
procedures_winauth.sql
systemusers.sql
3.3.3.2
If the server runs with Mixed mode and SA login, use the following script in the stated
order:
users.sql
tables_permissions.sql
procedures.sql
procedures_sqlauth.sql
systemusers.sql
3.3.4
Install the new PQ Schedule (Version: _________________)
☐
3.4
Start PQSM by “Run as administrator”.
Stop the PQSM service.
☐
3.4.1
Unistall + install PQSM (Version: ___________ )
☐
3.4.2
Start PQSM by “Run as administrator” to be able to make changes in settings.
Uninstall the PQSM Service using the PQSM Service control console.
Make all settings including SMTP and test sending emails.
Check the checkbox for windows authentication if that method is used to log into the
database.
☐
3.4.3
Start PQSM Service Control: install service and start it. If PQSM runs with windows
authentication the user that runs the service must be administrator locally on the machine.
☐
3.5
Unpause all schedules in PQ Secure.
☐
4
Maintain database
4.1
Check time zone in PQ Secure.
☐
4.2
Check response times and check that index works.
☐
4.3
Make settings for recovery model simple (database properties, options) to avoid the
transaction log growing too large.
☐