web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / This login failed. Att...
Microsoft Dynamics GP (Archived)

This login failed. Attempt to log in again or contact your system administrator

(0) ShareShare
ReportReport
Posted on by Mounir Ahmed 237

Any user access welcome login screen get previous error massage and can not continue, but the user has Sysadmin role in SQL Server passed with no error.

I had checked kb/919345, but no one solved my case, Is there any suggestion ?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    You should be able to log in as the SA user. When logged in as SA, try changing the password for an existing user, then logging on as that user.

  • Mounir Ahmed Profile Picture
    Mounir Ahmed 237 on at

    Thanks Harry, it's working with SA user, but not working with a user has public role only in SQL

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Mounir,

    Dynamics GP Users must be created in GP, not just SQL.  GP will create the SQL Accounts as part of the user creation process.  Go to Microsoft Dynamics GP > Tools > Setup > System > Users to add users.  Here is a link to a simple overview of this multi-step process.

    kbase.dyntools.com/.../how-to-create-a-new-user-in-dynamics-gp

  • Mounir Ahmed Profile Picture
    Mounir Ahmed 237 on at

    After The user had created in GP, I changed the password from application by SA, but the user can not pass login screen, he pass only if I let him a Sysadmin in SQl

  • Manjunath Vemula Profile Picture
    Manjunath Vemula 1,197 on at

    You have to login to GP as SA.

    Create new users by providing user name and password. 

    After this try to login to GP with the newly created user details.

    When you create from GP roles in SQL will be assigned automatically. Don't change them.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Mounir,

    When you create a new user in GP. You need to give him access to the company and assign him a security role for that user. The GP will take care of the roles based on the security Role ID's selected for the user. e.g "AR Clerk". Based on the roles assigned, the new user will be allowed to perform certain tasks.

    Note: You need not go and change the user role in the SQL.

  • Rosemary Profile Picture
    Rosemary 10 on at

    Please note if you are using GP 2013, when you create the profile and tick any of the 'advanced sql server options' the profile credentials has to be the same as in Active Directory. It has to be the same user id as well as password. Passwords are also case sensitive.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans