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

sachin421 · 2014-02-20

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 · 2014-02-20

Hi sachin421,

Witch is version of navision?

Have you create a user en SQL Server?

Have you create a user in Navision?

sachin421 · 2014-02-20

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

mohana_cse06 · 2014-02-20

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

k0n4n · 2014-02-20

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 · 2014-02-20

Hi,

Try this in your NAV db

delete [dob].user

Thanks

suraj92291 · 2014-02-20

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 · 2014-02-21

HI,

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

sachin421 · 2014-02-21

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

sachin421 · 2014-02-21

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 · 2014-02-21

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 · 2014-02-22

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

postsaurav · 2014-02-22

Hey Sachin,

Please mark the issues as resolved.

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

Comments

Categories