Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Database open issue in nav 2009 r2?

Posted on by Microsoft Employee

Hi All,

i have an issue in nav 2009r2, i have restore database in sql 2014 and when open this database in navision 2009 r2 i got below error even i try to log in through sa also

ERROR :- " user id and password are invalid try again"

but when i open nav 2013 it is asking to conversion database and also when i open in nav 2009 sp1 it is showing already database upgraded.

any one help me and i given my user as sysadmin and db owner permissions in sql side.

*This post is locked for comments

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Database open issue in nav 2009 r2?

    Is this a customer database you have restored ?

    If yes then delete the users from the database and login.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Database open issue in nav 2009 r2?

    Hi ramesh reddy ,

    In basic practice DB login use as Windows Authentication  

    Try change your authentication type as :   Windows Authentication  

    thats it

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Database open issue in nav 2009 r2?

    Try with user id SA and relevant password

    If you are trying to open with windows authentication then you need to give permission in sql as well as need to synchronize after adding in nav

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans