Hands On With Microsoft Dynamics GP 2016 R2: Manage Web Client SQL Server Login

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

The final step before we can log into the web client, is to configure the client with a proxy user which is used to connect to SQL Server. If you did this while installing the Microsoft Dynamics GP desktop client, you do not need to do this step now (provided of course that the username and password you set while installing the web client match what you set when installing the desktop client.

To configure (or manage) the Web Client SQL Sever Login, launch GP Utilities and log in using the sa or other user account with security admin permissions:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Manage Web Client SQL Server Login

● Categories: Dynamics, GP, GP Utilities, Microsoft, Web Client ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Create A Company

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In this post, I’m going to cover the creating of new companies in Microsoft Dynamics GP 2016 R2; to create a company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Create A Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Desktop Client First Run

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I deployed the system database; now we can deploy the sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Desktop Client First Run

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

in the previous post, the first client was installed; the next step it to deploy the System database.

Do this by launching GP Utilities from the Windows start menu. Log in using the sa account (this is one of the few times when the sa account must be used; at this time there are no other users which can be used).

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Deploy System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

List View Action Pane Error During Upgrade

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWe have been doing a number of upgrades for clients recently, the majority of which went fine. However, we did have one, being done by one of my team, where there was an error produced on the table List View Action Pane when upgrading to Microsoft Dynamics GP 2015 R2:

Company Detail

Continue reading → List View Action Pane Error During Upgrade

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPIn the last couple of posts in this series, we have deployed the system database and Fabrikam sample database. In this post, I’m going to create a new company using GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

wfDeployClrAssemblies Error When Deploying The System Database

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis post is a slight diversion from my Hands On With Microsoft Dynamics GP 2016 R1 series, but I am posting it as it came up while I was deploying the system database.

Towards the end of the deployment an error occurred while the wfDeployClrAssemblies was being executed (actually there were three error messages produced):

Microsoft Dynamics GP Utilities: The following SQL Statement produced an error: EXEC wfDeployClrAssemblies

Microsoft Dynamics GP Utilities

The following SQL Statement produced an error:
EXEC wfDeployClrAssemblies

Continue reading → wfDeployClrAssemblies Error When Deploying The System Database

● Categories: Uncategorized ● Tags: , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Ian Grieve ●  ● 11 Comments   ● 

Microsoft Dynamics GPNow that we have the first client installed, we can deploy the system database. By default the system database is called DYNAMCIS, but i have chosen to use one called D16R1. To deploy the system database, hit the Windows start button, search for and launch GP Utilities.

While I do try to minimise the use of the sa account as it is the SQL Server system administrator account, the initial implementation of Dynamics GP does require its use. So, on the Welcome to Microsoft Dynamics GP Utilities window enter sa in the User ID field and enter the relevant password.

Once done, click OK:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Upgrade Conversion Process Error

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWe’ve recently started work with a client to upgrade their Microsoft Dynamics GP 2010 R2 system to Microsoft Dynamics GP 2015. When running GP Utilities the following error, which caused the upgrade to fail, was produced:

Table Error Detail

The conversion process encountered an error and the temporary table did not get removed.

As a first step, we restored the system database and restarted GP Utilities and got the same error again. I did a little exploring of the Company Master table and found that there were entries for companies which did not exist.

After restoring the DYNAMICS database again and running the Clear Companies.sql script from Microsoft, we were able to run GP Utilities without further errors and complete the upgrade.

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●