Hi,

sorry to dredge this old post up but it is exactly the same problem that I am facing.

I have given the guest account (on both databases DB_A & DB_B) connect permissions but still get an access denied error message in Navision Nav.

We are trying to do the exact same thing as the OP (view in DB_A which looks at a table in DB_B)..

the only difference is that this is in the SQL 2005 forum and we are actually using 2008 R2 so wondered if there are some specific differences with regards to the guest account between the two versions.

Thanks

Chris