$ndo$usrproperty Error

te6

Hi All,

can somebody suggest me, to slove this issue

I am trying to synchronize my windows login id, the i am getting this error.

---

Microsoft Dynamics NAV Classic

---

The following SQL Server error or errors occurred:

208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '$ndo$usrproperty'.

SQL:
DELETE FROM [$ndo$usrproperty] WHERE [sid] = ?

---

OK

---

i am using NAV --> 2009 Sp1
OS --> Windows 7
SQL Server 2008

please suggest me..

matttrax

Anyone have any thoughts on this? I am encountering the same problem. I am a db_owner of the database in question. 2009 SP1, build 29626. Happy to provide any other information.

DenSter

http://support.microsoft.com/kb/2411497

matttrax

I saw that but didn't think it was the same. The one is a similar error when deleting a table from Object Designer. The error I'm getting is when I try to synch a user login.

"This problem occurs because the $ndo$usrproperty table only exists when you use the enhanced security model." and this synch is happening when the database is under Enhanced and always has been.

DenSter

Have you tried setting the security model to standard, and then back to enhanced? Maybe that will trigger NAV to create the view.

There's also a post here on mibuso with a SQL script to create the view.

matttrax

Tried moving to standard and that completed successfully at first glance, but upon logging out of the database and back in it says it cannot find the xp_ndo.dll file, even though it is in the location it references. So I can't put it back to Enhanced anymore. Thankfully it is a development database. Maybe if I log in as a database user I could do it since that shouldn't need the dll file?

The other NAV database on the same SQL Server, same default instance, still on Enhanced, remains working. A restart of SQL services, in fact the server itself, did not fix the development database.

I'll look into creating the view with a script as well.

DenSter

I'd recreate the extended stored procedures and try again.

matttrax

Recreating the stored procedures didn't help, but recreating the table did.

I used the script found here: viewtopic.php?f=33&t=28551&hilit=%24ndo%24usrproperty

I'm wondering what would cause that table to be dropped from multiple databases on the same SQL instance. It's not in the master, it's in the actual NAV databases.

Thanks for the help.

DenSter

I can't remember exactly but it had something to do with going from one certain version up to another certain version, and the conversion didn't completely handle that usrproperty table, something like that.