In MSSMS, when I try to Right click on my created Linked Server and choose Test Connection. I get this error message:
This would not happen if I had Admin Rights as I've tried. But I don't want to keep requesting for Admin Rights since I work for a company.
Can you please show me a work-around for this issue?
you can either use SQL service account and can setup linked server by that account
Or limit the access to server level for the login:
ALTER ANY LINKED SERVER
Please click the Mark as answer button and vote as helpful if this reply solves your problem
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?