Linked Server Issue

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.
Fraser_AdminAsked:
Who is Participating?
 
Brendt HessSenior DBACommented:
The actual error message(s) returned here would be useful.
0
 
lcohanDatabase AnalystCommented:
"If I log into SSMS as sa instead of my domain user no problem...connection works perfect.  "


Can you login as SA into SQL SSMS and check under logins to see if your other "domain user" login is part of the SQL Server Admin (sysadmin) role?
0
 
Tony303Commented:
Can you navigate to the folder where the dbf file resides from your desktop logged in as you?
Can you, once at that folder, create files in that directory?

This I guess will prove the read/write properties of your AD account on that folder.

If you cannot get to that folder then there is something going on with your network rights, group policy etc.

If you can, we'll have to look elsewhere.
0
 
Fraser_AdminAuthor Commented:
yes i am sysadmin under my domain user login.

i can read from the folder ok but i cannot write.

the funniest part is if i log onto the sql server which has the linked server created and i try to do test connection it is working fine.  if i do the same thing from my computer it doesn't work.  seems to be pc specific under my login???
0
 
Fraser_AdminAuthor Commented:
the error went away
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.