Good morning experts !!
I have a procedure in SQL Server 2012 that uses views from another database on another server with SQL Server 2008, the SQL procedure runs smoothly.
It happens that this procedure I have to run it from Access (Microsoft Office Professional Plus 2010) by a pass-through query.
The user who runs it has all the permissions on both servers in both views and in the procedure, in the connection string of the pass-through query the correct user name appears; But when the query is executed it does not recognize the user name and the error that I attached
Needless to say, ODBC does the test perfectly smoothly.
Is it possible to say in the procedure with which user is to be executed? I can not think of anything else.
Thank you very much.