Posts

Showing posts from May, 2015

"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed mode access

Image
I'm completing the deployment of Microsoft Dynamics GP 2013 R2's Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access. As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal. The Problem To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only  check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Image
Hello all! It's been quite a while since I've actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I've been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10's of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on. This time around I want to bring to the forefront, an issue I encountered updating  from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack. Background My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I'm absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics

Microsoft Convergence Atlanta 2015 (#CONV15) - Wrap Up

Image
Hey, not that this concerns anyone, but finally here is the wrap up post for the Convergence 2015 event. It's really been a busy couple of seasons for this writer (not that I'm complaining!), so I have had to opt for work instead of blogging which I'm sure you will understand as a reader. Microsoft Convergence Atlanta 2015: GPPC PreGame Microsoft Convergence Atlanta 2015 (#CONV15) - Day 1 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 1 Continued Microsoft Convergence Atlanta 2015 (#CONV15) - Day 2 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 3 Microsoft Convergence Atlanta 2015 (#CONV15) - Day 4 Other entries on the event, from my good friend David Musgrave : #CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame #CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote #CONV15 – Convergence 2015 Atlanta – Day 1 – Dynamics GP Session #CONV15 – Convergence 2015 Atlanta – Day 1 – Continued #CONV15 – Convergence 2015