How do I allow non sysadmin accounts the ability to create/query linked servers in SQL Sever 2014? I want to allow a non-admin account the ability to query a linked server.

If I create a linked server with the following under a sysadmin account like below.

EXEC master.dbo.sp_addlinkedserver @server = N'LINKEDSERVER', @srvproduct=N'', @provider=N'IhOLEDB.iHistorian', @datasrc=N'linkedservername'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LINKEDSERVER',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL


When I run SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT  * FROM ihTags') from a sysadmin account (no matter what account it is), it works.

If I run the query from a non-sysadmin account I get the following error.


  Msg 7416, Level 16, State 2, Line 2 
   Access to the remote server is denied because no login-mapping exists.
According to Article: Access to the remote server is denied because no login-mapping exists. 

Need to specify User ID in the provider string if Non-SYSAdmin accounts are used. 

Example: 

EXEC master.dbo.sp_addlinkedserver 
    @server = N'MyLinkServerName',
    @provider = N'SQLNCLI',
    @srvproduct = 'SQLNCLI',
    @provstr = N'SERVER=MyServerName\MyInstanceName;User ID=myUser'