Linked Server Issue
Posted on 2013-02-04
I have a linked server setup for a dbf file which resides on another server. All of a sudden my user (using ssms from my local machine) can no longer do a "test connection" on the link server without getting an error that the folder is not accessible. If I log into SSMS as sa instead of my domain user no problem...connection works perfect. I am an admin on the SQL box in question and can browse to the folder with the dbf no problem. This just started out of the blue. Last week i did not have this issue...
Please note this is on my local pc that i have the issue. If i log into the database server with remote desktop and run ssms from there as the same user the test connection works fine. Seems to be a pc issue more so than a user issue.