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

All responses (10)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

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.
AADYA 26 on at

Like (0)

Report

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

Already given full permission .
Verified answer

AADYA 26 on at

Like (0)

Report

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

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.
Dan Eckhoff 1,305 on at

Like (0)

Report

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

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.
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

Can you try setting your user ad DbOwner in SQL Server? Normally the GRANT I've provided above fix this.
Dan Eckhoff 1,305 on at

Like (0)

Report

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

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

Like (0)

Report

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

Which NAV version is this error on ?
Dan Eckhoff 1,305 on at

Like (0)

Report

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

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

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

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];
GDP 274 on at

Like (0)

Report

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

Check your SQL server login permissions.