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 adding the MKinsight_User to MS SQL Server, restoring and configuring the database.

1. Understanding database installation prerequisites
2. Adding the MKinsight_User to MS SQL Server
3. Restoring MKinsight 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 MKinsight_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 MKinsight_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 MKinsight Databases

1. Restore the Live database, named CompanyName-Live.bak in the installation archive to MKinsight-Live.
2. Expand the Security folder
3. Expand Logins.
4. Right-click MKinsight_User.
5. Select Properties. 
6. Select User Mapping.
7. Select MKinsight-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 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.

5. Restoring and configuring the Training Database

1. Restore the Training database, named CompanyName-Training.bak in the installation archive to MKinsight-Training.
2. Expand the Security folder.
3. Expand Logins.
4. Right-click MKinsight_User.
5. Select Properties. 
6. Select User Mapping.
7. Select MKinsight-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 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.

7. Further Reading

1. Configuring MKinsight_User and Restoring Databases in MS SQL Server - Standard Authentication - MKinsight 11.1
2. Install Full Text Search - Standard Authentication - MKinsight 11.1
3. Setting up the Web Server (IIS) - Standard Authentication - MKinsight 11.1
4. Installing the Client - Standard Authentication - MKinsight V11.1
5. Installing Client Add-ins - Standard Authentication - MKinsight 11.1
6. Installing a custom logo - Standard Authentication - MKinsight 11.1
7. Appendix 1 – Creating Standard Windows User - Standard Authentication - MKinsight 11.1
8. Appendix 2 – Installation & configuration of Web Service (IIS) - Standard Authentication - MKinsight 11.1
9. Appendix 3 – WCF Activation - Standard Authentication - MKinsight 11.1
10. Appendix 4 – Self-signed SSL certificate - Standard Authentication - MKinsight 11.1