SQL Error 15151

kitik

Hi!

I use NAV5.0 with SQL. I created all the users in SQL and was trying to syncronize them with NAV. I received the following error:

15151, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$a$', because it does not exist or you do not have permission.

SQL:
GRANT SELECT, INSERT, UPDATE, DELETE ON "Object" TO [$ndo$a$]

Anyone knows what is wrong?
Thanks!

kine

try to change your security mode to simple, it seems like the application roles were corrupted... how did you create the DB? From some backup?

kitik

How do I change the security model?

The database was already created. I was just creating new users.

kine

OK, as a first step, check that File - Alter - Options - Security mode is simple. If yes, problem is elsewhere...

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]

tro#1

All,
I get the same error message:
The following SQL Server error(s) occurred: 15151,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$ar$', because it does not exist or you do not have permission.

SQL:
GRANT SELECT, INSERT, UPDATE, DELETE ON "Object" TO [$ndo$ar$]

The Recovery model was set to Full.
That is why I set it to Simple as recommended. When I try to do a Sync All afterwards I still get the same error message.

Some more information:
The database is on 4 SP2.

I did a "Synchronise Single Login" for all users. This worked fine. I am just not sure if this is the same as a "Synchronize All". If so then I am fine.

Is it the same?
Do you have any other recommendations?

Any idea is appreciated. Than you

kine

Sometime, when you remove users, there are still lines in "Member of" and other tables which are referencing the user. May be there is some record like this which leads to his problem... (Synchronize all is not going over User table but Member of table)

dmccrae

It is not the Recovery model but the Security model that was referred to. Choose the Standard Security model, in the Advanced tab.

tro#1

Thank you Kine, that solved the problem.

In fact there were "Member of" entries for some users which did not longer existing for that database.
I deleted those entries and could do a "Synchronization all" successfully.

Thank you also to dmccrae.
But on the "Advanced" Tab there are only the options: Locking and Caching.
This might be because we are still on 4 SP2.

kriki

tro#1 wrote:

Thank you also to dmccrae.
But on the "Advanced" Tab there are only the options: Locking and Caching.
This might be because we are still on 4 SP2.

Correct. Best upgrade to 4SP3 latest hotfix. It is a lot better on SQL.