Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to access a user record in Microsoft Dynamics GP Personal Data Keeper: "This user does not have a corresponding SQL Login"

Error message when you try to access a user record in Microsoft Dynamics GP Personal Data Keeper: "This user does not have a corresponding SQL Login"

Symptoms

When you try to access a user record in the User Setup window of Personal Data Keeper (PDK) in Microsoft Dynamics GP 9.0 or in Microsoft Dynamics GP 10.0, you receive the following error message:
This user does not have a corresponding SQL Login

↑ Back to the top

Cause

This problem occurs because you have logged on to Personal Data Keeper by using a PDK user account instead of by using a system administrator (sa) user account. The PDK user account is not a security administrator account on the SQL server. Therefore, you cannot access security record tables.

↑ Back to the top

Workaround

To work around this problem, log on to PDK by using an sa user account.

↑ Back to the top

More Information

Steps to reproduce the problem
  1. Log on to PDK by using a PDK user account.
  2. On the Setup menu, click System, and then click User.
  3. In the User Setup window, click the VCR button at the bottom of the window to display the first user.


    Note If you are logged in as the displayed user, click the VCR button again and select a different user.

↑ Back to the top

Keywords: kbexpertiseadvanced, kberrmsg, kbsurveynew, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbprb, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 975973
Revision : 1
Created on : 3/3/2017
Published on : 7/12/2012
Exists online : False
Views : 119