Page 1 of 85212345678910...2025303540...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: 7

Friday Funny: Game of Thrones: The Musical

David Meego - Click for blog homepageIf haven’t been hiding under a rock or burying your head in the sand for the last few years, you would have heard of that small show on HBO called Game of Thrones. Based on George R. R. Martin’s A Song of Ice and Fire book series, the show has a reputation for frequent use of nudity, violence, sex and for killing off lead characters in many varied ways.

You have enjoyed the books and TV show and now thanks to Chris Martin and his British band Coldplay, you should soon be able to enjoy Game of Thrones: The Musical.

To help raise funds for the US Red Nose Day appeal, the Musical will donate its profits to the cause. On the official Coldplay YouTube channel, videos of the work on the show and some of the songs have been published. Watch them below:

Coldplay’s Game of Thrones: The Musical (Full 12-minute version) (direct link)

 

Game of Thrones: The Musical – Peter Dinklage Teaser (direct link)

 

Game of Thrones: The Musical – Emilia Clarke Teaser (direct link)

 

Game of Thrones: The Musical – Nikolaj Coster-Waldau – Closer to Home (direct link)

 

Game of Thrones: The Musical – Red Wedding Teaser (direct link)

 

If you want to donate to Red Nose Day, use the following link:

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun Tagged: Friday Funny, Fun

View the original here:
Friday Funny: Game of Thrones: The Musical

May 29, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 6

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

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 GP 2013 with Service Pack 2.

As it is customary with these types of request involving a server migration, I followed the very clear instructions outlined in KB article 878449How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server. I have walked through this article more times than I care to mention and can pretty much recite the steps by heart.

During the Dynamics GP Utilities process on the system database, I kept receiving the error message:

“Microsoft Dynamics Utilities Install/Upgrade failed”

This seemed to be a recurring problem on the sySrsReports table during the system database update. Upon further inspection, I noticed the temp table created for the sySrsReports (sySrsReport_T) was still present and that dropping this table would allow Dynamics GP Utilities to continue processing the system database update to completion.

However, the company database updates were failing with the following error messages:

“The stored procedure GetBD_UpgradeStatus() of form duSQL Pass Through SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

Upon clicking the OK button, the following error message would appear:

“The stored procedure UpdateDB_Upgrade() of form duSQL Pass Through SQL returned the following result: DMBS: 12, Microsoft Dynamics GP: 0.”

The above two errors would reiterate a few times (5 or 6 to be exact) to finally produce the following error:

“The stored procedure getCompanyID() of form duSQLInstall Pass Trough SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

And would come to rest with the error described at first. Now, I’ve done myriads of upgrades in my lifetime, but this one put me on a cliff for a while. The DEXSQL.LOG clearly did not show anything specific and the duinstall.log just showed execution messages (“Message encountered” messages) happening where the problem occurred.

In all fairness, the DEXSQL.LOG kept showing a “[Microsoft][SQL Server Native Client 10.0]Communication link failure” error which lead me to check the version of SQL Server Native Client I was running, which was version 10. I then upgraded to SQL Server Native Client 11.0 and nothing really changed.

I also realized the update was failing while attempting to create the table auto procedures for the wkPostingValidationState table. I then drop this table and its auto procedures and restarted the update in the hopes it would recreate the objects once more, but was not successful.

Suffice to say, I restored the system database and company databases in order to devise a different strategy.

The Solution

After tinkering with the installation, I decided to retrace my steps and realized that during the installation process, I chose to install Web Client Runtime Engine – after all this machine was the web server and would be running a Single Machine instance of Dynamics GP. I then decided to install the Dynamics GP client on the database server without the Web Client Runtime Engine and launch GP Utilities once more. The update process ran flawlessly without any errors!

I still cannot understand why the presence of Web Client Runtime Engine would have caused an error while updating a service pack, however I have to remind everyone of the official Microsoft stance: “the session host must only be used to perform very little administrative work”.

It was good to finally get pass these issues and complete the update process for my client.

Please take a look at my GPUG webinar on upgrades at:

Mariano’s Toolbox: Upgrading to Microsoft Dynamics GP 2015 for dummies 

Until next post!

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

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

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

Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

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 Atlanta – Day 2

#CONV15 – Convergence 2015 Atlanta – Day 3

#CONV15 – Convergence 2015 Atlanta – Day 4

#CONV15 – Convergence 2015 Atlanta – Post Conference and Getting Home

At the time of this writing, I’m preparing myself for the GPUG Summit conference in Reno, Nevada. Things are continuing to be hectic

Until next post!

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

Read More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

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

MDGP 2015 R2 Feature of the Day: Document … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

Visit site:
MDGP 2015 R2 Feature of the Day: Document … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 5

MDGP 2015 R2 Feature of the Day: Combined General … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

Follow this link:
MDGP 2015 R2 Feature of the Day: Combined General … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 3

MDGP 2015 R2 Feature of the Day: Purchasing All in … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

View article:
MDGP 2015 R2 Feature of the Day: Purchasing All in … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 5

Page 1 of 85212345678910...2025303540...Last »