• Thanks. The account I'm using is a domain account, and it is being used successfully in another context. However, I have asked to meet with our AD administrator to review what might be going wrong.

    Just out of curiosity, do you know why the Test Connection feature in the linked server shortcut menu would appear to succeed if there is some kind of permissions issue in the linked sever given the way I configured it?

    Thanks again for any help,

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html