access to nav

goldengategoldengate Member Posts: 2
Hi all,

i'm just a beginner in NAV, and maybe ma questions will be very stupid for you, but I need your help.
Yesterday I restored a backup of a society on my pc, and i made some test on it. The problem is that today I can't access on it anymore, I put my credentials and a message says to me "user ID and password are not valid". I'm using a 2009 version of NAV(the original backup was a version 4 sp3, maybe this could be a problem, I dont't know, but it was impossible to me ti install it on a different version of NAV).

Hope someone can help me

thankyou [-o<


  • Options
    ara3nara3n Member Posts: 9,256
    is this sql or native?
    if native, you'll need to restore it again, but before closing go to tools and security and add yourself as super.

    if the db is on sql, then you can delete window user and user table from sql and you can login
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    postsauravpostsaurav Member Posts: 708

    Just an addition on what ara3n said.

    Cause -
    After restore you haven't created a windows / database login into the database.

    If the database is SQL the from SQL Management studio run following query -
    USE [Database Name]  
    delete from [dbo].[User] 
    delete from [dbo].[Windows Login]

    Where you replace [Database Name] with your database name.

    * REMEMBER - THIS will delete all the logins that are there in the database.

    After this try login again using Navision, it will allow you.

    First thing after login in is to create a windows / database login into the database.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?

    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
Sign In or Register to comment.