Upgrading to Microsoft Dynamics GP 2016 R2: Adding Missing Security Roles

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith Microsoft Dynamics GP 2016 R2 now being available, there are some new security roles and tasks which need to be added.

As they have for the last few versions, Microsoft have made available some SQL Scripts to insert these roles and tasks.

The Dynamics GP 2016 R2 ones can be downloaded from directly from Microsoft or I have a post containing links to all of the versions I can find, which has been updated for Dynamics GP 2016, which is here.

The scripts tend to be cumulative, so if you upgrade from Microsoft Dynamics GP 2013 SP2 to 2016 R2, you only need to run the final script.

As always, when running scripts against Dynamics GP databases, ensure you have a good backup before starting.

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

Hyper-V Error Creating Virtual Machines

● Ian Grieve ●  ● 0 Comments   ● 

Hyper-VA while ago I was having problems with Hyper-V whenever I tried to start a VM after my laptop had been to sleep or after it was first started up.

That problem went away recently after I upgraded to Windows 10 by rebuilding the laptop. However, it seems the problem has migrated to whenever I try to create a new virtual machine:

The server encountered an error while creatng

New Virtual Machine Wizard

The server encountered an error while creating {server name}.

The operation failed.

An unexpected error occurred: Logon failure: the user has not been granted the requested logon type at this computer. (0x80070569).

The operation failed.

The Hyper-V Virtual Machine Management server encountered an under unexpected error: Logon failure: the user has not been granted the requested logon type at this computer. (0x80070569).

This is a lot less disruptive than the originally problem as I started VMs a lot more often than I create them. And fortunately, the fix is the same as last time, so the batch file I created can still be used.

Run the batch file and the VM can be created; and even better is that I can keep the New Virtual Machine Wizard open with all of the settings configured when I run the batch file. So if I forget to run the batch file before starting to create the VM, I don’t lose any work.

● Categories: Hyper-V, Microsoft ● Tags: , , ,  ● Permalink ● Shortlink ●

Analysis Cubes for Microsoft Dynamics GP Configuration Error

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPAs part of my hands On with Microsoft Dynamics GP 2016 R2 series I installed and configured the Analysis Cubes for Microsoft Dynamics GP.

This is the first time I have done this (I tend to hand reporting to other members of my team) and to do it I had to install a couple of extra SQL Server components; namely SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).

This all happened quite smoothly, but when I got to the Analysis Cubes configuration step I encountered a Fatal Error:

Fatal Error - Error encountered --> details written to 'C:\Users\iang\AppData\Local\temp\2\ACConfigurationWizard.log'
Fatal Error

Error encountered --> details written to 'C:\Users\iang\AppData\Local\temp\2\ACConfigurationWizard.log'

I navigated to the specified log file and had a look:

Click to show/hide error message

***Fatal Error Encountered***
System.Exception: The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in %SQL_PRODUCT_SHORT_NAME% Books Online.

Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2].  ---> System.Data.OleDb.OleDbException: Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. 
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.Connect()
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.Connect()
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.FolderExists()
   at Microsoft.SqlServer.Dts.Server.Storage.FolderExists(String folderPath)
   at Microsoft.SqlServer.Dts.Runtime.Application.FolderExistsOnDtsServer(String sFolderName, String sServerName)
   at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreatePackageFolder()
   at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreateDrivers(String companyID, String currency, String exchangetable)
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.ProcessCompanyMasterPackages()
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.InstallAnalysisCubesProduct()

Continue reading → Analysis Cubes for Microsoft Dynamics GP Configuration Error

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Intermission

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe bulk of my Hands On with Microsoft Dynamics GP 2016 R2 posts are now completed and posted, so time for a brief intermission before I finish the series with a look at the new features.

These were introduced my Microsoft in November and I did a Feature of the Day series at the time, but I can now be hands on with them.

However, before I get to them, I have a few other posts to do.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

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

Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Ian Grieve ●  ● 

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 installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Analysis Cubes Configuration Wizards

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server

● 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.

To install the Analysis Cubes Server, launch the Microsoft Dynamics GP 2016 setup utility and click on Analysis Cubes Server under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client

● 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 these next three posts, I am going to cover the Analysis Cubes Additional Product. I’ve only ever posted twice about this Analysis Cubes and in both cases it was about the Microsoft Dynamics GP 2013 Reporting – Second Edition book. So, for me, I am treading new ground.

Each machine which will be used to report from the Analysis Cubes needs to have the feature installed. To do this, open the Programs and Features control panel applet, select Microsoft Dynamics GP 2016 and click Change:

Programs and Features

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Changing Cortana’s Selected Method Of Travel

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPI’ve only recently started using Cortana in any meaningful way, but it has been doing one thing that is really annoying. It has been giving me travel tips based on travelling around by Transit instead of by car. The main one it reminds me of is getting home from the office when I am at the PI office and less often getting to that office from home (I spend a lot of time out on site with clients).

What’s the problem you’re wondering. The problem is that because it is using Transit, it tells me I have to leave work at 1320; or even worse that I need to leave home at 1400 on Saturday to get to the offic for 0700 Monday.

These messages have been popping up on my Windows Phone for a while and I have scoured the settings repeatedly looking for a way to fix it by changing the method of travel to car without success and had started thinking about switching off Coretana entirely.

Then the other day I had to get my laptop rebuilt (new OS installed after replacment of parts leading to jokes about the Laptop of Theseus) and activated Cortana. I found something called Notebook with lots of settings broken into areas.

To find Notebook, hit the Windows key and type Cortana. The third icon down on the side of the Start menu is Notebook:

Cortana Notebook

Continue reading → Changing Cortana’s Selected Method Of Travel

● Categories: Cortana, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● 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.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous but one post in this series covered adding the SBA feature to the desktop client on the web server, the previous covered the installation of the SBA web components and this one will cover the configuration.

After the installation of the web components completes, the Microsoft Dynamics GP Web Components Configuration Wizard will automatically launch. Click Next to proceed:

Microsoft Dynamics GP Web Components Configuration Wizard: Welcome

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● Categories: Dynamics, GP, Microsoft, Service Based Architecture ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Install Service Based Architecture Web Components

● 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.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous post in this seriescovered adding the SBA feature to the desktop client on the web server, this post will cover the installation of the SBA web components and the next will cover the configuration.

To install the SBA Web Components on the web server, launch the Dynamics GP setup utility and, under Additional Products, click on Web Components:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Install Service Based Architecture Web Components

● Categories: Dynamics, GP, Microsoft, Service Based Architecture ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●