You may see this error when looping a linked server at a database table name or with a USE statement even and the solution seems to be sp_addlinkedserver which I suspect is used like so:
EXEC sp_addlinkedserver @server='YOURNAMEHERE'
I cannot tell for certain however as when I attempt to use it at my work I get a different error telling me:
User does not have permission to perform this action.
...even though I have the sysadmin server role. Huh? A powwow with the powers-that-be reveals that this is just not the sort of security hole that should be opened up to begin with. I guess that makes sense. :P
No comments:
Post a Comment