Error when add users through "Windows Logins"

vh8000

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.

SQL:
{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.

kine

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.

vh8000

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.