3.60 running on SQL. Problem with permissions / fob-import

Tommy_Schou
Tommy_Schou Member Posts: 117
edited 2005-02-04 in Navision Attain
Hi!

I have a problem importing objects from a .fob-file into a DB running on SQL Server 2000.

I use windows authentication to logon to the Database and my user has only ONE role attached which is SUPER and it is NOT restricted to one Company.

The errors says:

The following error occurred ..
3704,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this operation on table blahh blahh...

Any suggestion as to the cause? :shock:

As you might have gathered I do not have much experience working with Navision running on SQL Server 2000 so be gentle! :)
Best regards
Tommy

Comments

  • fb
    fb Member Posts: 246
    In a SQL environment, there are a number of functions where Navision SUPER permissions alone are not sufficient. Examples include:
    • File, Database, New
    • File, Database, Alter
    • File, Company, New
    • Tools, Restore (when the .fbk contains objects)
    • File, Import (when the .fob file contains table re-designs)
    • etc, etc...
    In order to perform these functions, your Window Login must have special SQL server permissions. In SQL-speak, you must be a member of the 'db_owner fixed database role' or of the 'sysadmin fixed server role'.

    A quick-n-easy way to get these permissions is to login with a Windows Login that is a member of the Domain Admins group -- SQL <usually> maps Domain Admins to the 'sysadmin' role.
  • Tommy_Schou
    Tommy_Schou Member Posts: 117
    Thx a lot!

    I will get the SQL Admin on it right away! :)
    Best regards
    Tommy

Categories