Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / The combination of use...
Microsoft Dynamics NAV (Archived)

The combination of user ID and password entered is invalid

(0) ShareShare
ReportReport
Posted on by MedInfoTech 1,392

Hello Experts,

I have an issue with dynamics nav 5.0 sp1 when i restored a database and try to connect using Sql Authentication i get this error :

The combination of user ID and password entered is invalid

Steps i followed :

1) I set trace flag 4616 to startup Parameters

2) I Installed & Configured "xp_ndo_enumusergroups", "xp_ndo_enumusersids" NAV SQL extended stored procedures

3) I created database and i restored backup file 

4) I created users in Sql Server and assigned a db_Owner for those users on my restored database.

5) I synchronized those users

NB: i can connect with my session user (windows Account) if i add it as a user in sql server

Any Solution please

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The combination of user ID and password entered is invalid

    I have the exact same problem. tried with the SA account, unchecked that checkbox.

    have u solved the issue? please help.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: The combination of user ID and password entered is invalid

    Have you tried it with SA user.

  • MedInfoTech Profile Picture
    MedInfoTech 1,392 on at
    RE: The combination of user ID and password entered is invalid

    Hi Suresh,

    Yes i unckecked that checkBox

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: The combination of user ID and password entered is invalid

    When you created the SQL user did you uncheck "User must change password at next login" , you need to uncheck that while creating the user or else you will not be able to login.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans