Error with Logins

ta5
ta5 Member Posts: 1,164
edited 2013-01-17 in SQL General
Hi

I have a strange issue. When adding, deleting a user, also when trying to sync we get this error:
15138,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The database principal owns a schema in the database, and cannot be dropped.

I have found this, but its not fully clear to me:
viewtopic.php?f=23&t=48458

NAV 2009R2, SQL Server 2008R2.

As far as I understand, it is about orphaned logins and/or schemas. What would be the best approach to get rid of the problem? What to check step by step?
Help greatly appreciated :D
Regards
Thomas

Answers

  • ta5
    ta5 Member Posts: 1,164
    Solved!
    I started sql profiler and started synch again in nav. Profiler shows the bad user.

    I deleted the users schema, the synch was successful then. After that, I deleted the user and recreated it again. Btw: It was a service user for the MiddleTier, after deleting and recreating the user I had to recreate the schema [$ndo$navlistener] again.

    Regards
    Thomas
  • kriki
    kriki Member, Moderator Posts: 9,124
    [Topic moved from 'NAV/Navision Classic Client' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories