Available databases list incomplete

Joeri

Hello,

I've a very strange problem, and I hope you can help me with this.

I have a environment on SQL 2005 with 2 databases and about 10 companies in each database. I have a couple of users with Windows Authentication and Database Authentication.

Now, i have a couple of users that have a problem with switching databases. When they goto "File" --> "Database" --> "Open" they only see the database on which they are currently working, but the other one is gone. He can still connect to the other database by simple typing in the name.
But then the same happens also the other way around. When he now goes to the list of available databases, he still only sees the database he is currently working on, and has to type in again the name of the database to goto that one.

The user i've tested with has all rights (super), i've synchronised the rights, and even made him DBO on the databases, but still no succes.

Now the really strange thing is that it doesn't happen with all users. Some users don't have this problem.

Can anyone help me with this ?

Thanks.

kriki

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

BTW which version of NAV and SQL2005 are you using?

I don't know how to fix this issue, but I can give some indications that might help:
-If you are on version 4.0SP3 or later, you can change the security model to standard (and not enhanced). This way you don't need to synchronize anymore. This pushes the NAV-tablepermissions to SQL. With standard security model, this is handled through an application role on SQL. This might fix it in case it is some security issue.

-Another way is this: instead of letting the users "search" the server and the DB, I would create 2 shortcuts to the finsql.exe with the servername + DBname in it. So if they want to switch DB, they close NAV and click on 1 of the shortcuts.