Remote access activated by SETUSER

  • Hello,

    One of my jobs failed this morning with the following error:

    Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410)

    The job contains one step that is calling a stored procedure. I logged into QA as the owner of the job and ran the stored procedure and it worked fine. Does anyone have any suggestions as to where I should begin my troubleshooting? I already sifted through MS and couldn't find a possible resolution.

    Thank you,

    Melanie

  • What does the stored procedure do? If it touches something outside of the SQL Server then the account Agent is running under sounds like it doesn't have sufficient permissions.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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