Who is this article for?

Administrators who want to learn about creating Application User Account

Administrative access to the SQL server is required.

This article outlines the process of upgrading and configuring the PentanaMK databases.

1. Understanding database installation prerequisites
2. Upgrading and configuring the Databases
   1. Running PentanaTools.DatabaseUpgrade
3. Checking the Live database options
4. Further Reading

1. Understanding database installation prerequisites

Installation prerequisites are listed below:

• SQL Server computer is a member of the network domain1.
• Microsoft SQL Server 2012.
• SQL accessible over the network and SQL server ports configured through the firewall.

For more information see Appendix 1.

2. Upgrading and configuring the Databases

2.1. Running PentanaTools.DatabaseUpgrade

1. Run the Tool PentanaTools.DatabaseUpgrade.exe provided.

2. Enter the Connection details, normally the Provider and Transmission Protocol can be left as default.
3. The Network location is the name (and instance) of the database server.
4. Either tick the box labelled Integrated Authentication, if you are connecting using a windows user account with SQL privileges, or enter a valid SQL username and password.
5. Select the Live Database from the dropdown list.
6. Click Next.

Note: If the Current database version is less than 7.1, contact Morgan Kai Support for help with the upgrade.

7. Select the version to upgrade to 12.0.
8. Click Next.

12. Select Yes.
13. The database upgrade will commence.
14. Once finished, click Finish.
15. If any errors occur during the upgrade process, the process will be rolled back and a log will be produced, which should be sent to Ideagen support for analysis.
16. These steps should be repeated, using the Ideagen Internal Audit (Aura)-Training database.

3. Checking the Live database options

1. Right-click the MKinsight-Live database.
2. Select Properties.
3. Choose Options.
4. Verify that Recovery Model is set to Full and in Automatic the following is set:

• Auto Close – False
• Auto Create Statistics – True
• Auto Shrink-False
• Auto Update Statistics – True
• Auto Update Statistics Asynchronously – True

5. Change these options if they show a different value.
6. Click OK to save the changes.

4. Further Reading

1. Creating Application User Account - Standard Authentication - Internal Audit MK v12
2. Setting up the Web Server (IIS) - Standard Authentication - Internal Audit MK v12
3. Installing the Client - Standard Authentication- Internal Audit MK v12
4. Installing Client Add-ins - Standard Authentication - Internal Audit MK v12
5. Installing a custom logo - Standard Authentication - Internal Audit MK v12
6. Appendix 1 – Creating Standard Windows User - Standard Authentication - Internal Audit MK v12
7. Appendix 2 – Installation & configuration of Web Service (IIS) - Standard Authentication - Internal Audit MK v12
8. Appendix 3 – WCF Activation - Standard Authentication - Internal Audit MK v12
9. Appendix 4 – Self-signed SSL certificate - Standard Authentication - Internal Audit MK v12