Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics Login Error M...
Microsoft Dynamics GP (Archived)

Dynamics Login Error MEssage

(0) ShareShare
ReportReport
Posted on by Allen Black 500

Hi All,

 We are currently in the testing phase of our Dynamics GP 10.0 implementation. Any user created after the initial installation receive the attached error message upon entering or exiting a company. The system created DYNSA account does not receive the error message. The DYNSA account has been used to create and subsequent accounts (the ones receving the error).

Link to error message

After a little research, I see that the issue is most likely related to the SQL access granted to the accnts as they are made. I expect that this will be an easy fix once our IS departments can grant me access to the SQL DB.

Has anyone else encountered this problem and found that it was not related to SQL group access?

*This post is locked for comments

  • Allen Black Profile Picture
    Allen Black 500 on at
    Re: Re: Dynamics Login Error MEssage

    Thanks. I'll keep an eye out for that script. We're trying to get all the little bugs out in the test company before we move ahead.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Dynamics Login Error MEssage

    Just glancing at it, it looks like the user does not have execute access to that stored proc (which may be an extender proc(?) if you use that product.  Typically you woudl want to run a script called Grant.sql which will basically go through and grant insert, select, delete and execute to procs and tables that are in the DYNGRP role.  This script is usually located in the client under the C\Program Files\Microsoft Dynamics\GP\SQL (?) folder, but can also be found in CustomerSource.

     By the way, that Database TWO if the Fabrikam test company.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans