When i open RTC I got the error related to permission.

sachin421

Hi Experts,
i have installed navision and sql and create a fresh database and then restore the backup to the database and create instance for the database everything happens sucessfully and as
i add user to the navision and close the RTC and after that i again open the the RTC i got the message 'You don't have access Microsoft dynamic Nav. verify you setup as a valid user '
even i upload the license. please help :roll:
Thanks in advance.

k0n4n

Hi sachin421,

Witch is version of navision?

Have you create a user en SQL Server?

Have you create a user in Navision?

sachin421

Thanks for the reply..
navision 2013 R2
adding user in navision

mohana_cse06

Did you try this blog?
http://blogs.msdn.com/b/nav/archive/2012/10/03/manually-restoring-the-nav-2013-demo-database.aspx

k0n4n

If the database is cronus, and you hace any user create in navision, enter in SQL management and delete all register in the tables:

-Active session
-User
-User default style sheet
-User metadata
-User personalization
-User property

Then you can access to navision and create your users.

IMPORTANT: When you create user in navision, you have setting permisions in the user card.

rspmca

Hi,

Try this in your NAV db

delete [dob].user



Thanks

suraj92291

Hi.
I think you are created invalid use in RTC and then enable that user so you have to
DELETE your user from "USER TABLE" using sql server managment studio.
Try this
First find all user using
SELECT * From [YourdbName].[dbo].[User]
And then delete them using
DELETE FROM [YourdbName].[dbo].[User]

postsaurav

HI,

Read it here..
http://saurav-nav.blogspot.in/2012/12/you-are-not-authorized-to-sign-in.html

sachin421

Thank you so much for the reply and your feedback so problem is solved by your suggestions.

sachin421

Hi expert,
by execute this query user is removed form the Navision and again I add the user into RTC its shows the error
" you don't have the following permission page user subform -execute .Page New -user card must close." what is it.
Thanks for the reply.

postsaurav

Hi Sachin,

I Think you are adding another user first.

When you get access to database after running the command, first thing that you need to do is add the user that you used to Login in RTC (Your Windows Login) as super Role to the database.

Once your user is added you can add other users.

sachin421

Thanks saurabh sir you are right it works. actually i am adding another user first.

postsaurav

Hey Sachin,

Please mark the issues as resolved.