Scenario:

Consider a situation where you have a full backup of your customer database and restored it on your server.

Once the restore is done, you have to create a user in NAV that is known on your server. The user has to be created before getting out of NAV.

Say, you have missed to do the usual procedure and now faced with difficulties to enter your NAV Database.

What can be done?

If you have done a restore in a Native Database, there is no other option than to redo the complete restore.

But on the other hand, if you have a SQL Database, then there are some methods/workarounds to fix it.

  1. First try to login with user ’sa’. A lot of times, ‘sa’ is defined as a NAV database login.
  2. One more way is, if you know any NAV Database login that has super user rights, you can just use that user in SQL.
  3. Also, Add the user whom you want to access the tables of SQL
    1. Run the table “dbo.Member Of” in the SQL Server Management Studio
    2. Add the User ID and Role ID and the Company (remove the NULL value, but do NOT put a blank). Don’t put a value in the timestamp-field. Remember to use uppercase-characters”.
    3. Run the table “dbo.User” in the SQL Server Management Studio (your database –> Tables –> dbo.User –> right mouse button –>Open Table).
    4. Add the User ID and the password (remove the NULL value, but do NOT put a blank) and the Company (remove the NULL value, but do NOT put a blank). Don’t put a value in the timestamp-field. Remember to use uppercase-characters”. In “Expiration Date”, put a date in the future.
    5. Now you can enter NAV using this login

    4. Another way is to delete all logins and their roles from the tables. The following sql-statements do just that:
    delete from dbo.[Member Of];
    delete from dbo.[User];
    delete from dbo.[Windows Access Control];
    delete from dbo.[Windows Login];

 

Tags: Dynamics NAV | Comments Off

previous post: Dynamics SL – Notifications through Communicator module next post: How to resolve “Unable to connect to the ‘Company Name’ company. You don’t have access to this company” issue in Management Reporter 2012

Comments are closed.

Archives

2016
2015
2014
2013
2012
Congruent Facebook Twitter Slideshare