User Login Fail on NAV 5.01 with SQL Server 2005

DEKO

Hi,

i have a problem with Windows Logins on SQL: every time a regular user tries to log in, NAV displays an error message indicating that there occurred a SQL Error while accessing the Session Table via dbo scheme.

Users with dbo role or admins don't have the problem, though.

On the server, the extended stored procedures that are required have been installed properly and permissions have been synchronized as well (standard level).

The same database currently also runs in a test environment where everything works fine. We set up the live system now, using exactly the same settings and the same version of the stored procs, but there it won't work any more. It drives us crazy ](*,)

Does anybody have an idea what the problem might be?

Thanks in advance!

ara3n

Here is similar thread, that I've run into.

http://www.mibuso.com/forum/viewtopic.p ... highlight=


same issue.

Did you add the users manually or were they already in the backup?
If they were part of backup, you need to delete and insert them again.

ara3n

In my case they are newly created users and I they still cannot login with groups.

BBlue

Hello,

I think you're having the same issue as described in the following post:

http://www.mibuso.com/forum/viewtopic.php?t=23830

Regards

kine

1) Which Security Model?
2) Is it some clear database created by NAV 5.01 or it is some upgraded database?

garak

is the error message like "You have no permissions to read the Session Table" :?:
So please check also, if the View Session (Database -> Views) are in the sql role "Public". Also check the liked posts.

Regards