Posted by rkershberg@gmail.com on 10/17/06 20:28

nigelrivett wrote:
> Check the user that you are connecting with. It is probably the sql
> server service account. If this is the local system account you won't
> have access to remote machines. It needs to be a domain account.
>
> When you run the sp it is connecting as your login which is why it
> works.
>
> www.nigelrivett.net
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

I have received the message below

Executed as user: XXXX\Laser. Remote access not allowed for Windows NT
user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step
failed.


The job (the execution of one stored procedure) is written and stored
on a machine running MSDE .. but it has access to another SQL Server
machine on the domain.

The user is set up as a Domain Admin and as a SA (system admin) on both
servers (MSDE and regular SQL Server).

I can not seem to get this stored proc to run as a scheduled job
(either remotely or from the machine running MSDE directly).

Please advise (again).
'
Thanks in advance for your time.

rkershberg@gmail.com

• Next in forum: Re: Using trigger to notify an assembly of changes.
• Prev in forum: Re: Case Statement in Where Clause
• Thread view: Re: Execute an schedule job from MSDE with LINKED servers in SQL Server

[Reply to this message]