Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

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.
0
Fraser_Admin
Asked:
Fraser_Admin
3 Solutions
 
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
 
Brendt HessSenior DBACommented:
The actual error message(s) returned here would be useful.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now