web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) SQL-Error 15138 by Add...

Microsoft Dynamics NAV (Archived)

SQL-Error 15138 by Adding a NAV-User

(0) Share

Report

Report

Posted on by Frank Zettelmeyer

55

The following error occures by adding a Window-user in Dynamics NAV.

15138, "42000" The database principal owns a schema object in the database and can not be deleted.

SQL:
{CALL [sp_revokedbaccess](?)}

Last weekend we executed all server-updates!

Thank you

Frank

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Rashed 3,765 on at

Like (0)

Report

Re: SQL-Error 15138 by Adding a NAV-User

find out which schema object the user that is being deleted owns.

It could be the owner of the db and you have to change the owner to sa.

Was this reply helpful? Yes No
Mohammad Atif on at

Like (0)

Report

Re: SQL-Error 15138 by Adding a NAV-User

Can you please look into this : :blog.sqlauthority.com/.../sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Alexander Ermakov 2

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans