Error when importing FOB file: Cannot find the object because it does not exist or you do not have permissions

There are some tasks in Dynamics NAV, where it is not sufficient to be a SUPER user, to complete them. You need more permissions added for your username on the SQL Server. For example, if you would try to upload a license file without having sufficient SQL permissions, you would get an error message: Database is invalid or cannot be accessed State ID: HY024.

Similarly, if you would try to import the FOB file which contains changes to the table structure (for example, developer added a few new fields to a table and sent you the FOB), you would get a different error message: The following SQL Server error or errors occurred when accessing the TABLE: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object “COMPANY$TABLE” because it does not exist or you do not have permissions.

Cannot find the object because it does not exist or you do not have permissions

If you get error message when importing FOB file, iy means, that you do not have sufficient SQL permissions. By default, if you are Dynamics NAV user, you would have only Public role assigned to you. However, for administrative tasks (like uploading a license file, or importing the FOB file), you need more permissions.

So, if you are trying to import the FOB and you get above error message, you will need to ask you SQL administrator to import the FOB for you, or to grant you sufficient permissions (either a sysadmin or db_owner server roles).

Related Links

Technorati Tags: , , ,

This entry was posted in Dynamics NAV / Navision, errors and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *