Oh yes.

The linked server is 2005. I've tried with the connecting server on 2008 and 2005.

The script for the linked server:

/****** Object: LinkedServer [196.41.x.x] Script...

Hi

Yes, sorry - just to clarify: in the orginal post the use only had write access, but after you post, it was changed to have all access, except dbo.

And no,...

Thanks a lot, but...

The user have all permissions except dbo, but it gives the error:

An invalid schema or catalog was specified for the provider "SQLNCLI10" for linked server "196.41.x.x.

Sigh.

Hi

Thank you, but no - it's not helping.

Firstly because it seems like a different error that is discussed and it is specific to Windows authentication. I connect via a...

Yes, the connection is to SQL Server which is an external connection.

The application gets installed on each client PC, but the tables in the application then gets connected to a...