Post reply

Running a sp that refers to a linked server

  • October 20, 2003 at 10:08 am

    #106887

    I've scheduled a job to execute a sp that includes a reference to a linked server (connected over a VPN).

    The sp runs fine in QA, and only runs in EM if I run it immediately after I've run it in QA. If I leave it for while after running it in QA and then try to run it in EM it will fail. However, if I schedule it, it fails with the following error message:

    "SQL Server does not exist or access denied. [SQLSTATE 42000](Error 17)."

    Any ideas?

  • October 22, 2003 at 5:06 am

    #479060

    Hi,

    Try giving the Server a fully qualified name.

    eg. SERVERNAME.COMPANY.com


    Andy.

  • October 23, 2003 at 6:44 am

    #479270

    Already doing that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply