Microsoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.
However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.
The second post in this series, covers the installation of the System database. This is the database which holds the deployed companies and security configuration amongst oither items. To install the System database, run GP Utilities from the Start screen.
Despite what seems to be a regular argument I seem to have with Infrastructure people, you must log into GP Utilities using the sa account in order to be able to install the System database (no “ifs”, no “buts”; it must be sa):
![Welcome to Microsoft Dynamics GP Utilities Welcome to Microsoft Dynamics GP Utilities](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_1.png)
On the Welcome to Microsoft Dynamics GP Utilities page, click Next:
![Welcome to Microsoft Dynamics GP Utilities Welcome to Microsoft Dynamics GP Utilities](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_2.png)
For the Installation Options, it is inadvisable to select the Basic configuration, so mark Advanced and click Next:
![Installation Options Installation Options](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_3.png)
Check that the location of the Data and Log files are set to the correct values; I typically find that they have defaulted to the installation folder of SQL Server rather than the default Data and Log folders specified when configuring SQL Server so update then accordingly and click Next:
![Database Setup Database Setup](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_4.png)
Set the Maximum Account Length to 66 and the Maximum Number of Segments to 10; regardless of the account format you intend to use it is always best to set the Microsoft Dynamics GP Account Framework to the maximum allowed so that you have space for expansion in future. Click Next to proceed:
![Set Up Account Framework Set Up Account Framework](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_5.png)
Name the Segments (which for the Fabrikam sample company are Division, Account and Department); it is always best to name them as it makes reporting in SmartList or Management Reporter easier.
Set the maximum length of each segment; the default is 6 and I typically leave the segment at this length unless the client has specified that they will have a longer segment; I will then try to discover why and discourage them if possible as accounts should be as easy as possible for people to type.
Click Next:
![Set Up Account Segment Lengths Set Up Account Segment Lengths](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_6.png)
Choose whether to define additional sorting options. I have opted to do so:
![Define Additional Sorting Options? Define Additional Sorting Options?](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_7.png)
Select the additional segments which will be available for sorting and click Next:
![Set Up Additional Sorting Options Set Up Additional Sorting Options](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_8.png)
Verify the account framework and click Next:
![Verify Account Framework Verify Account Framework](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_9.png)
Enter the password for the DYNSA user; this account should be configured in SQL Server as a security admin (I’d have sworn that I did a post on this, but I can’t find it anywhere; keep your eyes open as I will be blogging about this soon):
![Enter DYNSA User Password Enter DYNSA User Password](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_10.png)
If you intend to use the web client, which I do, mark the Using web client checkbox and then enter a Login Name, Password and Confirm Password and click Next:
![Web Client SQL Server Login Web Client SQL Server Login](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_11.png)
Chose the Authentication Type for web client only users; the options are Windows Account if you’re using a standard Windows AD Domain or an Organisation Account if you’re using Azure, O365 or other Microsoft account:
![Authentication Type Authentication Type](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_12.png)
Enter a System Password; I haven’ty done that here as I am installing a test system, but it is advisable for a live system:
![Enter System Password Enter System Password](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_13.png)
Check the settings and confirm the installation of the System database by clicking Finish:
![Confirmation Confirmation](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_14.png)
I am not deploying the Business Intelligence reports just yet, so I have left the checkboxes unmarked:
![Business Intelligence Reports Setup Business Intelligence Reports Setup](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_15.png)
The final page is the Additional Tasks window. Click Exit to close GP Utilities:
![](https://static.azurecurve.co.uk/images/posts/2015/06/MDGP2015R2_Install_System/MDGP2015R2_Install_System_16.png)
Click to show/hide the Hands On With Microsoft Dynamics GP 2015 R2 Series Index
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
1 thought on “Hands On With Microsoft Dynamics GP 2015 R2: Install System Database”