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 ●

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: Install Web Client Single-Machine Deployment

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

Now that the Web Client Runtime feature has been added, we can install the web client itself. I am only doing a single-machine deployment of the web client in this series of posts.

To install the Web Client, launch the setup utility and, under Additional Products select Web Client:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Install Web Client Single-Machine Deployment

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

MDGP 2016 R2 Feature of the Day: HTTPS Support for Management Reporter

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The nineteenth Feature of the Day is support in Management Reporter 2012 for https access to the web viewer:

This adds the ability to deploy Management Reporter for report access over secure https communication.

This feature is well overdue; it should have been introduced at the same time as the web viewer itself.

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

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

MDGP 2016 R2 Feature of the Day: SmartList Favorite Protection

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here

The second Feature of the Day is SmartList Favorite Protection:

SmartList Options

This new feature allows a password to be set which will protect SmartList Favourites from being modified; when a user tries to modify a SmartList Favorite they will be prompted to enter a password.

The downside of this setting is that it is a global setting for all SmartList Favourites and not a password which can be set differently for each Favourite. This point was mentioned to Microsoft at reIMAGINE 2016.

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

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

Integration Manager Error: Cannot Open Database “GPLIV” Requested By The Login

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWe’re in the middle of large upgrade project at the moment for a client and encountered an error when trying to run an integration.

This particular integration is an Account one, which has been extended with VB Script which checks to see if the segments exist, and if not, it inserts them. When a user tried to run the integration, they get the following error:

Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: System.Data.SqlClient.SqlError: Cannot open database "GPLIV" requested by the login. The login failed.
DOC 2 ERROR: System.Data.SqlClient.SqlError: Cannot open database "GPLIV" requested by the login. The login failed.
DOC 3 ERROR: System.Data.SqlClient.SqlError: Cannot open database "GPLIV" requested by the login. The login failed.
Integration Failed
Integration Results
    3 documents were read from the source query.
    3 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        3 failed to integrate.

I did some double checking and it turned out that the user who was doing the testing had two Domain accounts (one with full name and one with initial and surname) and were not using the one I had configured originally.

All of the other users I had worked with had been using Domain accounts of initial and surname, which was the one I had configured, but this particular user was using the account with their full name.

Adding this Domain user account to the database with the DYNGRP role resolved the problem.

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

Upgrading Microsoft Dynamics GP: Missing Security Roles

● Ian Grieve ●  ● 5 Comments   ● 

/10Microsoft Dynamics GPWhen you do a fresh install of Microsoft Dynamics GP, all of the required security roles and tasks are created. However, when Dynamics GP is upgraded, the new security roles and tasks are not automatically added. Microsoft do supply a set of scripts each time which can be run to add the roles and tasks.

This comes up every time we upgrade a client and I am tired of having to hunt out the posts from Microsoft, so I’m bringing together a list of the last few scripts and will add new ones here as each version is released.

The versions I could find again are listed below

MDGP 2016 R1 Feature of the Day: Named Self Serve User

● Ian Grieve ●  ● 0 Comments   ● 

There have already been a few feature of the days I have been a little puzzled by and this one is another of them. Support for named user licensing for the Self Service User Type has been added:

User Setup

User Summary

I would have sworn that this was not new, but was introduced in the last version. Unless it is showing on the User Summary window which is new.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

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

eConnect Adapter Error In Integration Manager

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPA recent upgrade of a client from Microsoft Dynamics GP 2010 R2 to GP 2015 R2 recently resulted in an issue being found when testing some integrations in Integration Manager:

DOC 68 ERROR: eConnect error - The source was not found, but some or all event logs could not be searched.  To create the source, you need permission to read all event logs to make sure that the new source name is unique.  Inaccessible logs: Security.

The problem was a fairly simple one in that the eConnect service account did not have the necessary permissions; a very similar issue to the one I blogged about in March 2013.

The solution is to add the service account to the Local Admins group; instructions are in the post I linked above.

● Categories: Dynamics, eConnect, GP, Integration Manager, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

SQL Script To Bulk Alter Users With Logins

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPBack in July 2013 I did a post where I looked at a problem copying live to test. The basic issue was that the Microsoft Dynamics GP user is also a login (at the SQL Server level) and a user (at the SQL Server database level) and when a database is copied from the live server to the test server (or from the current live top the new live) you can run a script to transfer across the logins, but the users come across with the database and will have different SIDs (Security IDs).

You can use the ALTER USER command in SQL to re-link the login with the user, but this is one statement per user per database. The old post showed how to do this, but this quickly becomes a pain when there are more than a handful of users.

As Perfect Image has grown we have clients with more and more users and/or company databases. Our largest client has over 250 users in their Dynamics GP installation while another has fewer users, but well over 100 companies. Both of these can make copying live to test problematic, especially when only a company database might be copied over rather than the whole system.

I needed to automate the process of altering the login to match the user; the below script is the result of this need. Continue reading → SQL Script To Bulk Alter Users With Logins

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