NAV2013r2 User setup (not via RTC)

bigkid2071

We have just upgraded a Nav4 database through to NAV2013r2 for one of our clients, this database has then been passed over to me to work on for the customer.

What I have found is that via SQL I have been able to restore the Database, I have been able to setup the Service Instance and have access to the Development Environment for this Database.

However when I run RTC I get the error message "Your not a valid user" etc etc.

Is there any way that I can add myself into the users without having to go via the RTC.

I am setup via SQL, with all relevant permissions in the Server and the Database security, however cannot run RTC.

We obviously cant restore this database to the client as they too will not have access.

Many Thanks in advance.

mohana_cse06

Welcome to Mibuso

Please follow this blog
http://blogs.msdn.com/b/nav/archive/2012/10/03/manually-restoring-the-nav-2013-demo-database.aspx

bigkid2071

I already have access to a demo database, with no issues. This is trying to access a database that has been created by a colleague that does not have my user setup and was originally on another domain.

I need to be able to add in a new user without accessing RTC.

ftornero

You can insert yourself in this 3 sql tables

Access Control
User
User Property