Login Error - SQL 2008

schoolkid

Team

I'm getting the following error message while login into NAV 5.1

229, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]The select permission was denied on the object '$ndo$dbproperty', database 'Database Name', schema 'dbo'.

Please help

kine

And it worked and now it is not working? What did you do on the DB? Some changes?

schoolkid

Thanks for your reply!
It is a new database and I am trying to login first time. I have synchronized the logins successfully.

kine

Through SQL tools check, that the table has Select permissions for Public.

garak

Did you check the permissions on sql self?
How did you create this DB on the 2008 Server? Is it a backup from a other server?

Did you try first to "synchronize" your NAV logins?
If the error still occurs, then you could try this SQL command in SSMS:

use [Your_Database]
go
grant select on [$ndo$dbproperty] to public
go

Regards