Excel file as linked server

[gettingfedup]

Hi

I've added an excel file as a linked server and created a view in one of my databases to access this.

All works fine and 'sa' can return data from this view.

However, a new SQL user I've created can't. I get a 'Access to remote server is denied because no loggin-mapping exists'.

Any ideas how I can do this?

Thanks

 

[Skittle]

The login the user is using is not set up with mapped credentials to the Excel file. Never done it to Excel but I'm assuming the same principles apply as for any other data source.

You need to select the 'security' properties on the linked server and change a setting on the 'For a login not defined in the above, connections will' or add the users login to the 'above' list with impersonate set thew same remote user you have successfully used for yourself.

Dazed and confused