The following SQL error was unexpected:The VIEW CHANGE TRACKING permission was denied on the object 'NAV App', database 'Live', schema 'dbo'.

(0) Share

Report

Posted on by AADYA

Navision Service Starts Fail or Sync Fail or Login Fail with Below Error Message

---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
The following SQL error was unexpected:

The VIEW CHANGE TRACKING permission was denied on the object 'NAV App', database 'Live', schema 'dbo'.

---------------------------
OK
---------------------------

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

GDP 274 on at

Like (0)

Report

Check your SQL server login permissions.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Check your NAV service user's permissions. Is it dbowner or not?

You can grant permission executing the following T-SQL:

GRANT VIEW CHANGE TRACKING ON [dbo].[Object] TO [YourDomain\YourUser];

GRANT VIEW CHANGE TRACKING ON [dbo].[NAV App] TO [YourDomain\YourUser];

Was this reply helpful? Yes No
Dan Eckhoff 1,305 on at

Like (0)

Report

I am also having this problem and the suggested fix isn't working.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Which NAV version is this error on ?

Was this reply helpful? Yes No
Dan Eckhoff 1,305 on at

Like (0)

Report

This is occurring on NAV 2018 version 11.0.20348. SQL version 12.0.5207.0 Standard and Server 2012 R2 Standard

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Can you try setting your user ad DbOwner in SQL Server? Normally the GRANT I've provided above fix this.

Was this reply helpful? Yes No
Dan Eckhoff 1,305 on at

Like (0)

Report

Thanks for the response, however...

The user I'm logged on as is a domain admin, dbo for the database, and the NAV service user. I had no issues a month ago when developing, compiling, etc.

Was this reply helpful? Yes No
Verified answer

AADYA 26 on at

Like (0)

Report

Friends, thanks for all your replay.

I understand this issue is related to some permission.I cant find out the solution.

I got a work around for this change the Service login to Local system, then sync the objects. After that i can able to change the login to domain user and then it is working.

Was this reply helpful? Yes No
AADYA 26 on at

Like (0)

Report

Already given full permission .

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

The user for which you have to set the permission described above is the user associated to your NAV service (not your NAV user account). I've not explicitly said that before because I've thinked tha it was obvious. If you've done this, it's quite strange that it doesn't work.

Was this reply helpful? Yes No