SQL Authenticated Account is unable to select a View in MS SQL Server 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
If you check the How to Create a Linked Server doc, you'll understand that your current configuration works like this:

Be made using the login's current security context Specify that a connection will be made using the current security context of the
login for logins not defined in the list. If connected to the local
server using Windows Authentication, your windows credentials will be
used to connect to the remote server. If connected to the local server
using SQL Server Authentication, login name and password will be used
to connect to the remote server. In this case a login with the exact
same name and password must exist on the remote server.

Since your SQL Server login doesn't exist on windows you can't access the file. You should create a mapping to that specific login defining a remote user and password with permissions on that server to read the file.
Just beware that anyone logged in SQL Server with that SQL Server user will have the privileges of the Windows login you defined on the mapping.