Configuring Permissions to RDP to Server

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis is only something I need to do occasionally so am posting this as a reminder.

Most of the demo VMs I create are on my local Client Hyper-V, but occasionally I make one available to a prospect or client and need to give them a user other than the administrator account.

Creating the user account itself is easy, but the bit I usually fail to remember how to do, is to give the user the rights to sign in remotely.

When this right has not been granted, an error message like the below will be displayed:

To sign in remotely, you need the right to sign in through Remote Desktop Services. By default, members of the Administrators group have this right. If the group you

To sign in remotely, you need the right to sign in through Remote Desktop Services. By default, members of the Administrators group have this right. If the group you're in doesn't have this right, or if the right has been removed from the Administrators group, you need to be granted this right manually.

Continue reading → Configuring Permissions to RDP to Server

● Categories: Microsoft, Windows, Windows Server 2012 ● Tags: , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Batch Edited Message

● 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 and also look at the new functionality introduced; the index for this series can be found here.

The feature of the day I am covering in this post, is the Batch Edited Message. If a user tries to open a batch being edited by another user they will receive a warning message containing the users name:

Microsoft Dynamics GP: This batch is being edited by laurab. Please try later.

Microsoft Dynamics GP

This batch is being edited by laurab. Please try later.

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Batch Edited Message

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

Hands On With Microsoft Dynamics GP 2016 R2: SmartList Favourite Protection

● 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 and also look at the new functionality introduced; the index for this series can be found here.

The second of the new features I’m going to cover is SmartList Favorite Protection.

This feature allows the administrators to define a password which must be entered before a SmartList favorite can be modified. The password is entered in the SmartList Options window (Administration >> Setup >> System >> SmartList Options):

SmartList Options

The password impacts all SmartList favorites. Please do not use ACCESS as the password; I see far too many clients who have this as a password throughout their system. It is in all of the manuals and lots of blog posts so it is pretty much the least secure password you could use.

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: SmartList Favourite Protection

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

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

● Ian Grieve ●  ● 3 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.

Not sure why I thought the scripts were cumulative, but they are not. All of the scripts need to be run in sequence for your upgrade path.

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 ●  ● 2 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 ●  ● 6 Comments   ● 

Microsoft 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

Microsoft Most Valuable Professional for Microsoft Dynamics GP

  • Associations

  • Social Media & Other Sites

    MVP Profileazurecurve Publishingazurecurve on the Dynamics CommunityPerfect Image Ltd.Email azurecurveView azurecurveView Detailed RSS FeedView Ian Grieve's about.meView azurecurve's Feed on TwitterView Ian Grieve's profile on LinkedInView azurecurve on facebookView azurecurve on Google+azurecurve Developmentazurecurve WordPress Plugins
  • Buy My Books

  • Posts Archive

    201794 posts
    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    2011112 posts
    1. 06
    2. 07
    3. 08
    4. 09
    5. 10
    6. 11
    7. 12
  • Post Calendar

    May 2017
    M T W T F S S
    « Apr    
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
  • Categories

    Click to see all categories

  • Tag Cloud

    Configuration eConnect Errors Financials General Ledger Hands On Installation Installation & Configuration Integration Manager Inventory Control Management Reporter Management Reporter 2012 MDGP 2013 Feature of the Day MDGP 2013 R2 Feature of the Day MDGP 2015 Feature of the Day Microsoft Dynamics GP 2010 Microsoft Dynamics GP 2013 Microsoft Dynamics GP 2013 R2 Microsoft Dynamics GP 2013 SP2 Microsoft Dynamics GP 2015 Microsoft Dynamics GP 2016 R1 Microsoft Dynamics GP 2016 R2 Microsoft SQL Server Packt Publishing Payables Management Purchase Order Processing Purchasing Receivables Management Reporting Sales Sales Order Processing Security SmartList SQL Script T-SQL Web Client Web Services Windows Workflow Workflow 2.0
  • Dynamics GP Community

  • Login

  • Map of Visits

  • Disclaimer

    This blog and its content is provided "AS IS" with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages arising out of the use of, or inability to use, information or opinions expressed in this site and confers no rights.

    The links in this blog may lead to third-party Web sites to provide access to third-party resources to assist you in finding other services and/or technical support resources. Information at these sites may change without notice and azurecurve is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.