access to nav

goldengate · 2013-12-05

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<

ara3n · 2013-12-05

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

postsaurav · 2013-12-05

Hi,

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]  
GO
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.

access to nav

Comments

Categories