Error when add users through "Windows Logins"

vh8000vh8000 Member Posts: 23
Hi All

Our company has been implemented NAV2009R2 for 1.5 years.

Last week when I tried to add user through "Windows Logins", the following error message pop-up:-
The following SQL Server error or errors occurred:
15138,"42000",[Microsoft][ODBC SQL Server Driver][SQL
Server]The database principal owns a schema in the database,
and cannot be dropped.

{CALL [sp_revokedbaccess](?)}

Same error occurs when I tried "Synchronize All Logins"

Has anyone run into the same problem and any suggestions/advice?

Thanks in advance.


  • Options
    kinekine Member Posts: 12,562
    Looks like that the user, who created the DB (or own some schema on the DB) is not in the NAV user table entered. NAV will revoke permissions on user accounts which are not entered in NAV but have some rights on the DB. It means, even when the used do not need to use NAV, but is using SQL directly, must be entered in NAV to prevent the permissions revoke.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    vh8000vh8000 Member Posts: 23
    Thanks for your reply kine.

    Tried days to check around the Database login users in SSMS in all areas (NAV Database Users, master, Security...) and remove users but no luck.

    Same error message pop-up whenever I "Add User" or "Sync. All Logins."

    Eventually, I:-

    - Uninstall SQL2008R2 - Database Engine component only
    - Add back the Database Engine component feature
    - Restore backup "Navision Database".BAK

    Then problem solved.

    I'm pretty sure this is not the best way but I cannot afford more time to fool around.

    Thanks and hope my solution will help others.
Sign In or Register to comment.