Page 1 of 3012345678910...202530...Last »

"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…

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 following error:

A SQL Server login already exists for userID. Delete the user and create a new user.

As it so turns out with most application errors, you cannot just follow the instructions literally to fix the problem. In this case, we had more than 85 web client only user accounts created so “Delete the user and create a new user” wasn’t an option and I don’t know why I had a gut instinct this recommendation would not work anyways.

It also turns out that I tested this in Microsoft Dynamics GP 2015 and had no issues switching a user account from Web Client user only to a mixed mode access user account.

NOTE: “mixed mode access” user is a terminology I came up with to identify a Microsoft Dynamics GP user account with access capabilities from both the web client and desktop client.

The Solution

In troubleshooting this problem, the first thing is to focus on the first part of the error message, “A SQL Server login already exists”. If a login already exists on SQL Server, then it should be visible under Management Studio – bear in mind that each Dynamics GP user account was setup as a web client only account to begin with. In principle, there should be no SQL Server security principal for these type of accounts.

Management Studio did not show any account created for the Dynamics GP under the Security folder. So the next logical thing would be to run a statement to check for a SID for the account in question:

SELECT suser_sid(‘TheUserID’);

This statement returned an actual SID number (a long hexadecimal set of characters), confirming at least there was a corresponding SID for the account, even though we could not see the actual account in Management Studio.

Next was to verify then, what account was assigned to that SID. In order to do this, I ran the following SQL statement:

SELECT name FROM sys.server_principals where sid = (SELECT suser_sid(‘TheUserID’));

As it turned out, this statement returned no results. So here’s the conundrum… GP thinks there’s a SQL login for a user account that doesn’t really exists on SQL, but has a SID.

Now, because there wasn’t an actual SQL login for the user ID in question, I went ahead and setup a new SQL login with the user account by running the following statement:

sp_addlogin(‘TheUserID’, ‘somePassword’);

The statement was successful and I could now see the SQL login under the security folder.

The next thing was to then reset the Dynamics GP web client user flag and assign the SQL login to the user account:

UPDATE SY01400 SET WCUser = 0,  SQLLoginID = ‘TheUserID’ WHERE USERID = ‘TheUserID';

Since Microsoft Dynamics GP passwords are encrypted on SQL Server, you will now need to log into Dynamics GP, pull up the user account under the User Maintenance window, and change the password in the SQL login credentials section.


I cannot assess whether this is a bug or not, but suffice to say the same behavior is not present in GP 2015, so I must lean towards it being a bug.

I hope you find these troubleshooting steps useful.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Continued here:
"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…

May 29, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 250

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here: https://mbs.microsoft.com/partnersource/northamerica/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade#UpgradePaths.

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process www.Standardprocess.com, for suggesting this to me.

Enjoy!

Leslie

Original post:
Upgrade from GP 2010 to GP 2013 R2

March 17, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 85

You receive "Unable to Upgrade SBA from RTM" when attempting to apply Microsoft Dynamics GP 2015 January or March Hotfix

Well, this one for sure has bitten more than one person already. I’ve seen a lot of exchanges and fielded a number of calls from folks trying to install the January or March hot fixes of Microsoft Dynamics GP 2015. When the msp file is executed, couple seconds into the execution you receive the following error message:

Unable to upgrade SBA from RTM. Please remove the SBA feature before running this patch.

The first reaction is to try and find the feature via the Uninstall or change a program options under the Windows Control Panel. As it turns out, there’s no such option. This has led many folks to the next “obvious” option: Microsoft Dynamics GP Web Components.

When you choose to uninstall the Microsoft Dynamics GP Web Components, you will get rid of the Web Client install, but not the SBA components.

So what’s the solution?

The keyword in the error message is the word “feature”. SBA is a Microsoft Dynamics GP feature. In order to remove, you will need to right-click on Microsoft Dynamics GP 2015 and select the change option.

You will then click on the Add/Remove Features option in the Program Maintenance window, then scroll down until you see the Service Based Architecture option in the Select Features window. You can the proceed to click on the corresponding options button associated to the SBA prompt and select Not Available.

Select Features window

Once you click Next, the installer will proceed to remove the feature from your environment. When completed, you can re-run the hotfix msp to apply the updated code.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

More:
You receive "Unable to Upgrade SBA from RTM" when attempting to apply Microsoft Dynamics GP 2015 January or March Hotfix

March 13, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65

Modifier Quick Tip for Fixed Assets – Don’t check that box!

 

This came up recently on the forum. A user had modified the ‘Asset User Data’ window. The window previewed perfectly in Modifier, the Modified/Alternate Forms and Reports ID was correctly set, and there was even a period before the window title on the window. However, the window still looked the same as it did when before the modification. What’s going on here?

What’s going on has to do with your choices in the Company Setup window for Fixed Assets. One of the Option items is a checkbox for ‘User Data Auto Format’. If this box is checked, any Modifier changes you make are overridden by the system, and the window displays as it did before it was modified.

The moral of this story is – if you want to modify the Asset User Data window, be sure to uncheck the ‘User Data Auto Format’ checkbox.

Enjoy!

Leslie

More:
Modifier Quick Tip for Fixed Assets – Don’t check that box!

February 10, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 82

Third reason to attend #CONV15: @dgpblogster and @WinthropDC

Wow! As if having Satya Nadella and OneRepublic as a 1-2 punch combination reason for attending Convergence 2015 in Atlanta, Microsoft has now decided to amp up the magic by inviting no other than the Dynamic Duo of presentations: David Musgrave and Mariano Gomez (that would be me!).

Mariano Gomez and David Musgrave
Inside joke: in case you can’t tell us apart, I’m the taller one and David is the shorter one

Realizing no event is complete without a formidable duo of presenters, Microsoft has reached out to us — as the famous LeBron James once said, “Not 2, not 3, not 4, not 5…“, but 6 times now to come and help to make this one of the biggest customer events ever.

David and I will be delivering a blockbuster session, CS15G024: Microsoft Dynamics GP 2015 customization which will feature tips and techniques we’ve learned for developing Dexterity and Visual Studio Tools customizations for Microsoft Dynamics GP 2015. And yes, that includes .NET interoperability and Dexterity Services.

You know we are fun! So why not pop into our session? Just come have a blast and hopefully we can show you something new. No, no Visual Basic for Application (VBA) this time. In fact, we will even show you how to convert your Modifier with VBA customizations which will make you the talk of the nation.

Warning: this will not be a beginner’s session, but it doesn’t mean you can’t come to it and get an appetite for what you can do when you reach the next level. Just don’t give us a bad grade if something flies by you :-)

So what do you need to do? Well, for starters, complete your Convergence 2015 registration. If you register and come to our session we may even take a picture with you and make you famous. All kidding aside, we hope to see you in Atlanta.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

View the original here:
Third reason to attend #CONV15: @dgpblogster and @WinthropDC

January 9, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 73

Microsoft Dynamics GP 2015 Developer’s Preview: Wrap Up

It has been an exciting ride combing through the features and capabilities of the Microsoft Dynamics GP 2015 Service Based Architecture components, starting at the core with the new and enhanced .NET interoperability capabilities within Microsoft Dexterity, all the way to the new service base architecture foundation built into Microsoft Dynamics GP to expand the realm of integrations that can be accomplished in today’s fast paced, application (Apps) dominated world, whether those applications are native to the Windows platform or cross-platform, whether they reside in the cloud or on premise, and regardless of the form factor.

I wanted to provide this single point of reference to reach all entries in the series, which saw 5 articles over the past 5 months.

Microsoft Dynamics GP 2015 Developer’s Preview: Loading the VHD image – Part 1 (Aug 29, 2014)
Microsoft Dynamics GP 2015 Developer’s Preview: Working with Sample URIs – Part 2 (Sep 24, 2014)
Microsoft Dynamics GP 2015 Developer’s Preview: .NET Framework Interoperability – Part 3 (Oct 29, 2014)
Microsoft Dynamics GP 2015 Developer’s Preview: Dexterity Service Patterns – Part 4 (Nov 25, 2014)
Microsoft Dynamics GP 2015 Developer’s Preview: Dexterity Service Patterns – Part 5 (Dec 1, 2014)

Since Microsoft Dynamics GP 2015 is now available to the general public, my focus will turn to keeping you abreast of those application nuggets, point out any glaring issues or problems, and continue to work with the development community at large to maximize the technological foundations of the product.

In the future, you may see new series on this blog seeking to enhanced the product learning experience, so stay tuned.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read More:
Microsoft Dynamics GP 2015 Developer’s Preview: Wrap Up

December 11, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 148

Microsoft Dynamics GP 2015 RTM is now available

This week saw the release of Microsoft Dynamics GP 2015, six months after the release of Microsoft Dynamics GP 2013 R2. Dynamics GP 2015 introduces over 120 new features, all of which have been covered recently over at Inside Microsoft Dynamics GP, the official blog of the Microsoft Dynamics GP Product Management & Marketing teams.

This new release also introduces a first round of Service Based Architecture operations, geared toward enhancing the product integration capabilities, and the ability for developers to expand into areas such as mobile applications, cross-platform applications, cloud-based applications and services, among others.

At its core, developers will now enjoy the enhanced coding capabilities with the introduction of .NET interop in Microsoft Dexterity, the IDE used to build Dynamics GP.

For the IT director or manager, Microsoft Dynamics GP 2015 introduces single sign-on capabilities offered via Windows Azure Active Directory, yet reinforcing Microsoft’s commitment to the cloud.

PartnerSource

CustomerSource

Here are links for the articles about the release:

Inside Microsoft Dynamics GP

Dynamics GP Support and Services Blog

Winthrop Development Consultants (David Musgrave)


ERP Software Blog

Microsoft Dynamics GP Administrator

Dynamics GP Essentials

Dynamics GP – Learn & Discuss

Azurecurve


For questions about upgrading to Microsoft Dynamics GP 2015, please contact me for a free consultation or use the comment section provided with this article.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read the original post:
Microsoft Dynamics GP 2015 RTM is now available

December 5, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 168