Who is this article for?

Administrators who want to learn about Configuring PentanaMK_User and Restoring Databases in MS SQL Server.

Administrative access to the SQL server is required.

This article outlines the process of adding the PentanaMK_User to MS SQL Server, restoring and configuring the database.

1. Understanding database installation prerequisites
2. Adding the PentanaMK_User to MS SQL Server
3. Restoring PentanaMK Databases
4. Checking the Live database options
5. Restoring and configuring the Training Database
6. Checking the Training database options
7. 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 2008 R2 or above.
• SQL accessible over the network and SQL server ports configured through the firewall.

For more information see Appendix 1.

2. Adding the PentanaMK_User to MS SQL Server 

1. Run SQL Server Management Studio
2. Connect to the server with an administration level account (e.g. the sa account or a member of the Administrators user group).
3. Expand the folder of the server instance, then right-click the Security folder.
4. Select New Login.
5. Search for PentanaMK_User.
6. Click OK to add the user.

For more information about adding a Windows user to SQL server open internet link:  http://technet.microsoft.com/en-us/library/aa337562.aspx

3. Restoring PentanaMK Databases

1. Restore the Live database, named CompanyName-Live.bak in the installation archive to Ideagen Internal Audit (Aura)-Live.
2. Expand the Security folder
3. Expand Logins.
4. Right-click PentanaMK_User.
5. Select Properties. 
6. Select User Mapping.
7. Select Ideagen Internal Audit (Aura)-Live database.
8. Select db_owner from Database role membership.
9. Click OK to save the database login properties.

For more information about restoring a database open internet link:  http://technet.microsoft.com/en-us/library/ms177429.aspx 

4. Checking the Live database options

1. Right-click the Ideagen Internal Audit (Aura)-Livedatabase.
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.

5. Restoring and configuring the Training Database

1. Restore the Training database, named CompanyName-Training.bak in the installation archive to Ideagen Internal Audit (Aura)-Training.
2. Expand the Security folder.
3. Expand Logins.
4. Right-click PentanaMK_User.
5. Select Properties. 
6. Select User Mapping.
7. Select Ideagen Internal Audit (Aura)-Training database.
8. Select db_owner from Database role membership.
9. Click OK to save the database login properties.

6. Checking the Training database options

1. Right-click the Ideagen Internal Audit (Aura)-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.

7. Further Reading

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