Installation manual

UNIPOWER
Installation manual PQ Secure
96
1.12
Go to Admin-> Tools and set the “Default Measure Unit Time Zone” to “(UTC)
Cordinated Universal Time” and the “Default Database Time Zone” to the local
time zone
☐
If you wish to use SQL Authentication continue to section 2.0
If you wish to use Windows Authentication continue to section 3.0
2.0
Log on to the SQL Server using SQL Server Management Studio. Log in as SA.
☐
2.1
Run DBWizard and create the PQSecure database. (db version: _________ )
☐
2.2
Set recovery model to “simple (database→ properties→ options) to avoid
growing transaction log.
☐
Continue to section 4.0
3.0.1
Have the local Database admin (DBA) create a database named “PQSecure” in
the SQL-server.
☐
3.0.2
Have DBA create a Windows user called “PQSecure_installation” with
dbo_access for the PQSecure database.
☐
3.1
Log in as “PQ Secure_installation”. Run DBWizard and create the PQSecure
database. (db version: _________ )
☐
3.2
Set recovery model to “simple” using SQL Server Management Studio
(database→ properties→ options) to avoid growing transaction log.
☐
3.3
Have DBA give the “PQSecure_installation”-user admin_role for the PQSecure
database in the SQL-server
☐
Continue to section 4.0
4.0
Install PQSM (version: _________ )
☐
4.0.1
Start PQSM Service control as administrator.
☐
If you wish to use SQL authentication continue to section 5.0
If you wish to use Windows authentication continue to section 6.0
5.0
Set the address to the sql-server (See 1.5)
5.1
Decide the folder for periodic reports. This folder grows, so choosing C: (system
partition) may be a bad idea.
☐
5.2
Set up SMTP server and test email.
☐
5.3
Set up email receiver for system warnings and error messages
☐
5.4
In the PQSM Service, choose “local system account”
☐
5.5
Install and start the service
☐
5.6
Re-boot server and verify that SQL Server and PQSM start normally.
☐