Dynamics NAV 5.0 sp1 on SQL 2005 error when sync all users

fig
fig Member Posts: 5
edited 2009-06-02 in NAV/Navision Classic Client
I created a new db on sql 2005 using NAV and restored company data into it. I get the following error when I try to add a new user or sync all users -- 1529,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The DEFAULT_SCHEMA clause cannot be used with a windows group or with principals mapped to certificates or asymetric keys.

This happens with Standard or Enhanced Security only with Standard Security, I can not sync users individually.

Answers

  • Prem
    Prem Member Posts: 34
    Hi Fig,

    Couple of things to be checked.... whats the authetication of the DB you backed up to Restore,

    does your SQL Secutity Table and the Navision User Table matches...? i mean the userid's..?

    Cheer's

    Prem
  • fig
    fig Member Posts: 5
    Windows Authentication with AD Groups associated to Roles for permissions and the individual user for access.

    Yes the users are the same in the sql security and in the NAV security table.

    Old db that looks like the same structure and security visibly looks the same works. I don't know but I think it could have more to do with SQL 2005 permissions and the db than the permission inside of NAV.
  • fig
    fig Member Posts: 5
    Problem solved by turning on SQL profiler. The group that came up in the error did not have access to the db and had to be manually set to public.

Categories