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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

LOGIN ERROR WHEN RESTORING 2009 DATABASE

(0) ShareShare
ReportReport
Posted on by

 Hello guyz! am trying to login into a restored 2009 database. This is the error "the login failed when connecting to SQL server AMOS"

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    7,019 User Group Leader on at

    Hi! You should try this: http://mibuso.com/blogs/kriki/2009/02/18/how-to-get-access-when-you-cant-get-into-your-nav-sql-db/


    Good luck!

  • mmv Profile Picture
    11,471 on at

    Hi,

    Basically you need to clear the existing credentials by opening the DB using SQL and fire the below queries (for that db):-

    delete from dbo.[Member Of];

    delete from dbo.[User];

    delete from dbo.[Windows Access Control];

    delete from dbo.[Windows 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans