I am trying to select a view using a SQL authenticated account. This view is actually reading a spreadsheet from a local drive (through a LinkedServer). I am getting below error:
Msg 7416, Level 16, State 2, Line 1 Access to the remote server is denied because no login-mapping exists.
Currently, the linked server is set to For a login not defined in the list above, connection will be made using the login's current security context. The spreadsheet is on the same server.
How may I resolve this error and select the view using the same account? The account is added as db_owner.
P.S If I run the view using a windows authenticated account, it is working fine